Uploaded a record but facing error export to excel.

Question

Uploading the bulk data in sql using C# as front end but getting error export to excel the procedure is written in sql using if exisits.

alice yang · Answer

Hi, Check this link: http://www.c-sharpcorner.com/blogs/import-and-export-data-from-excel-to-database

Khan Abrar Ahmed · Answer

try this code string constr = ConfigurationManager.ConnectionStrings[ "constr" ].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand( "SELECT * FROM Customers" )) { using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = cmd; using (DataTable dt = new DataTable()) { sda.Fill(dt); using (XLWorkbook wb = new XLWorkbook()) { wb.Worksheets.Add(dt, "Customers" ); Response.Clear(); Response.Buffer = true ; Response.Charset = "" ; Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" ; Response.AddHeader( "content-disposition" , "attachment;filename=SqlExport.xlsx" ); using (MemoryStream MyMemoryStream = new MemoryStream()) { wb.SaveAs(MyMemoryStream); MyMemoryStream.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); } } } } } } or try below links https://www.aspsnippets.com/Articles/Export-data-from-SQL-Server-to-Excel-in-ASPNet-using-C-and-VBNet.aspx http://www.c-sharpcorner.com/UploadFile/cd7c2e/export-sql-data-to-excel-using-Asp-Net/

Maahi · Answer

i think you didnt get issue. Issue is I have uploaded a bulk record from front end in c# ok Then am loading the record in temp table using table type ok I have used if exisits condition from based on the if exisit condition if the record is valid it will update the master else it will insert into the table unmatched records. So i need unmatched records of the table and this table am trying to export in excel in c# . When i execute the procedure its working but export to excel no record found. If possible plz provide solution for the same. Export to excel method is working but from sql server the records are getting generate.

Khan Abrar Ahmed · Answer

Hi check this link http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-excel-file-records-into-sql-server-database-using/ or post your code and error message.

Uploaded a record but facing error export to excel.

Answers (4)