Is it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...
I can directly use to read and display Excel or CSV files using asp web control(GridView, sqldatasource etc). I do NOT want to upload the file first to an sql database before reading them, I just want to read the files directly. I am using asp.net 2.0 and c#.
How to upload the file directly from the client machine. I have one button for mail sending.
If i click the button, the from, to, subject comes using pageload. Like that the default file also could be added as a attachment directly from the client machine.
How to upload the file directly(using file upload control or eithout using file upload control)...
Now the same code when I copy it in my project having masterpage . there is no compiler error but it is genereating excel file withno data in it but in fact there is data in the grid view at runtime.
I have developed an application where I need to create a page to read data from Excel File and then update it to the database. The code that I wrote works only when the application runs from my machine. When I deployed the application to the server it gave an error- 'C:PRFileIimport_File.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. here is mu code -
protected void InsertData(object sender, EventArgs e) { OleDbConnection oConn = new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\PuertoRicoFile\Puertorico_Iimport_File.xls ; Extended Properties=Excel 8.0 "); OleDbCommand oCmd = new OleDbCommand("select * from [Puertorico_Data$]", oConn); oConn.Open(); //Here [Puertorico_Data$] is the name of the sheet in the Excel file where the data is present OleDbDataReader oleDbReader = oCmd.ExecuteReader(); string AgentIP = ""; string TagName = ""; string Status = ""; string Severity = ""; int EventCount = 0; string EarliestEvent = ""; string LatestEvent = ""; while (oleDbReader.Read()) { AgentIP = (string)oleDbReader[0]; // valid(oleDbReader, 0);//Here we are calling the valid method TagName = (string)oleDbReader[1]; //valid(oleDbReader, 1); Status = (string)oleDbReader[2]; //valid(oleDbReader, 2); Severity = (string)oleDbReader[3]; //valid(oleDbReader, 3); EventCount = Convert.ToInt32(oleDbReader[4]); //oleDbReader[0]; //valid(oleDbReader, 4); EarliestEvent = (string)oleDbReader[8]; //validate(oleDbReader, 8); EarliestEvent = EarliestEvent.Substring(0, 19); LatestEvent = (string)oleDbReader[9]; //validate(oleDbReader, 9); LatestEvent = EarliestEvent.Substring(0, 19); InsertDataIntoSql(AgentIP, TagName, Status, Severity, EventCount, EarliestEvent, LatestEvent); } SqlConnection mySQLconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["IssNetworkReportingSystemConnString"].ConnectionString); mySQLconnection.Open(); SqlCommand cmdSql = new SqlCommand("AddMonth_Event_TotalInfo_for_Puertorico", mySQLconnection); cmdSql.CommandType = CommandType.StoredProcedure; dbReader = cmdSql.ExecuteReader(); dbReader.Close(); cmdSql = new SqlCommand("AddQtr_Event_TotalInfo_for_Puertorico", mySQLconnection); cmdSql.CommandType = CommandType.StoredProcedure; dbReader = cmdSql.ExecuteReader(); dbReader.Close(); oConn.Close(); lblMsg.Text = "Data Imported Sucessfully"; lblMsg.ForeColor = System.Drawing.Color.Green; } public void InsertDataIntoSql(string agentIP, string tagName, string Stat,string severity,int eventCount, string eEvent, string lEvent) {//inserting data into the Sql Server SqlConnection mySQLconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["IssNetworkReportingSystemConnString"].ConnectionString); mySQLconnection.Open(); SqlCommand sqlSelect = new SqlCommand("SELECT SeverityID from Severity where SeverityDesc=@SeverityDesc",mySQLconnection); sqlSelect.CommandType = CommandType.Text; sqlSelect.Parameters.Add("@SeverityDesc", SqlDbType.NVarChar).Value = severity; dbReader = sqlSelect.ExecuteReader(); int severityId = Convert.ToInt32(dbReader.Read()); dbReader.Close(); SqlCommand sqlInsert = new SqlCommand("Insert into IdsData_Puertorico(AgentIP,TagName,Status,SeverityID,EventCount,EarliestEvent,LatestEvent)" + " values (@AgentIP,@TagName,@Status,@SeverityID,@EventCount,@EarliestEvent,@LatestEvent )" ,mySQLconnection); sqlInsert.CommandTimeout = 0; //timeout unlimited sqlInsert.CommandType = CommandType.Text; sqlInsert.Parameters.Add("@AgentIP", SqlDbType.NVarChar).Value = agentIP; sqlInsert.Parameters.Add("@TagName", SqlDbType.NVarChar).Value = tagName; sqlInsert.Parameters.Add("@Status", SqlDbType.NVarChar).Value = Stat; sqlInsert.Parameters.Add("@SeverityID", SqlDbType.Int).Value = Convert.ToInt32(severityId); sqlInsert.Parameters.Add("@EventCount", SqlDbType.Int).Value = Convert.ToInt32(eventCount); sqlInsert.Parameters.Add("@EarliestEvent", SqlDbType.DateTime).Value = DateTime.Parse(eEvent); sqlInsert.Parameters.Add("@LatestEvent", SqlDbType.DateTime).Value = DateTime.Parse(lEvent); sqlInsert.CommandType = CommandType.Text; sqlInsert.ExecuteNonQuery(); mySQLconnection.Close(); }
I am developing a application which is social related, and medical also, where there are lots of offline data which we have to show per user, insted of asking database for all the data, to reduce the preassure on the db server, i have thought of using xml for the offline data source.
When a user logs in, the old data will be loaded from the xml file from his folder which approx of ( less than 1 mb) each file). the updated info will be fetched from the db with the index of that table.
Can we use xml in getting data using writer and reader in vs 2012.
I am reading data from Excel file using oledbdataadapter and binding to gridview.Every thing working fine.but if the cell is having some text along with bar sysmol ( | ) [Ex : 12345 | 789123] that cell data is not reading from excel file.All fileds in excel sheet is text format only.Some times it's reading correctly & some times it not reading(empty).Is there any problem with bar symbol ( | )
I'm having two grid view and one button on aspx page , on click of export to excel button i want to transfer these grid view data to excel sheet.. My requirement is to trasnfer to same excel file with two sheets(One sheet for one grid view).
ID Name Contact No Address 1 ABC XXXXXXX ABCNM2 XYZ xxxxxxx ASDFG
Now my requirement is read data from this excel sheet and den encrypt Contact No field for each row and den save data in database, how should it will be done I have to use some ready made available encryption algo for that.
I used this coding for export to excel, by using this coding i got only 65,536 rows only. How to bind more than 65,536 records or how to move the balace records to sheet 2 by using this method.
Protected Sub btnExportExcel_Click(ByVal sender As Object, ByVal e As EventArgs) Dim ars_stock As New DataTable ars_stock = cls.FillDataTable("select top 70000 * from spal..po_acc_details") Response.Clear() Response.Buffer = True
I want to insert data in sql server from sheet within excelsheet ,there are three sheets in the file which i want to upload in three different tables,currently i am doing by selecting an individual sheet and the table to upload thus doing it three times for three sheets can i do it in one go,like passing all the sheets to a function or something like that or how can i do it in a better way and also i cannot directly upload sheet into table as i have to map one column of excel to different table of database to get its value like i need statecode but statename is provided in the sheet so i map statecode to statename in a staging table and then i upload the data...
I'm building a User Control that will allow a user to select input parameters, run a query and then view the results in a GridView control. That part is obviously very easy. However, I've been asked to also provide the option of viewing and/or printing the data in a PDF, Excel or CSV file format.
Are there any .Net 2.0, built-in classes that allow for exporting and printing data in these formats in Visual Studio 2005?
A couple of years ago, I worked on a website that offered this functionality in Crystal Reports, but on this particular assignment, we aren't currently using Crystal - I'm not at work right now, and I can't remember if we're running the "Standard" or "Enterprise" edition of Visual Studio.
URL....the code works good when my webform is not inside content place holder of Master page.but, when i use same code in the webform which lies inside content place holder of a Master page, downloading of excel doesnot happen.
I'm exporting data to an excel sheet from the ojects list. The data is exporting to excel sheet well, but I'm unable to see the grid format for the data. The data is looking with out the rows and columns lines.I think I'm missing to set some property or somethnig ehwn exporting.
I have code to export the grid to excel . i have taken it from [URL] now i want to save excel file directly without asking user to save it or open it at client side. i want to save it on server folder. how to do that .
I am uploading an Excel file into DataSet/Gridview but once the file is uploaded, then i want to be able to make changes the data that is uploaded like making changes the data inside the Gridview or deleting the data etc. Here is my code:
I have created a CSV file on the server and want to send it to the user using the following code:
Dim strPhysicalPath As String strPhysicalPath = Server.MapPath( "CSV/" & PathVirtual) Dim objFileInfo As System.IO.FileInfo = New System.IO.FileInfo(strPhysicalPath) Response.Clear() Response.ContentType = "application/vnd.ms-excel" Response.AddHeader("Content-Disposition", "attachment; filename=" & objFileInfo.Name) Response.AddHeader("Content-Length", objFileInfo.Length.ToString()) Response.WriteFile(strPhysicalPath) Response.Flush() Response.End()
This seems to work fine except when the downloaded file is viewed in Excell the html code behind the page from which it came is also appended to the file. Does anyone have any idea why it does this?