BindData and Write Data From Excel to DataGrid in Web.

private void btnReadExcel_Click(object sender, System.EventArgs e)
{
try
{
string szConn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = "+ Server.MapPath("sample3.xls") +"; Extended Properties = Excel 8.0;";
OleDbDataAdapter ExcelAdapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", szConn);
DataSet ExcelDs = new DataSet();
ExcelAdapter.Fill(ExcelDs, "Sheet1");
DataGrid1.DataSource = ExcelDs.Tables["Sheet1"];
DataGrid1.DataBind();
}
catch(Exception Ex)
{
Response.Write(Ex.Message);
}
}


private void btnWriteExcel_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
DataGrid1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
}