hi
refer below thread
http://www.aspforums.net/Threads/163566/Export-DataTable-to-Excel-without-any-dll-using-C-and-VBNet-in-ASPNet/?s=2#Replies
I use below code to export data from database into excel:
public void DataTableToExcel(DataTable dt)
{
HttpResponse response = HttpContext.Current.Response;
response.Clear();
response.ClearHeaders();
response.ClearContent();
response.Charset = Encoding.UTF8.WebName;
response.AddHeader("content-disposition", "attachment; filename=" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls");
response.AddHeader("Content-Type", "application/Excel");
response.ContentType = "application/vnd.xlsx";
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
GridView gridView = new GridView();
gridView.DataSource = dt;
gridView.DataBind();
gridView.RenderControl(htw);
response.Write(sw.ToString());
gridView.Dispose();
dt.Dispose();
response.End();
}
}
}
protected void Imgsave_Click(object sender, ImageClickEventArgs e)
{
using (SqlConnection conn = General.GetConnection())
{
using (SqlCommand _cmd = General.GetCommand("Estate_ViewInfoB", conn))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
_cmd.Connection = conn;
sda.SelectCommand = _cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
DataTableToExcel(dt);
}
}
}
}
}
now I want import this excel file into database how I can do it?
Best regards
neda