Uploaded a record but facing error export to excel.

Maahi

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

alice yang9y ago
Hi,

Check this link:

http://www.c-sharpcorner.com/blogs/import-and-export-data-from-excel-to-database
Khan Abrar Ahmed9y ago
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/
Maahi9y ago
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 Ahmed9y ago
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.