using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Configuration;
using System.Data;
using System.Data.Odbc;
public partial class _Default : System.Web.UI.Page
{
protected void Button_Upload_Click(object sender, EventArgs e)
{
if ((FileUpload1.PostedFile != null))
{
if (!string.IsNullOrEmpty(FileUpload1.PostedFile.FileName))
{
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
string Extension = Path.GetExtension(FileUpload1.PostedFile.FileName);
string FolderPath = "ExcelFiles";
string FilePath = Server.MapPath("~/" + FolderPath + "\\" + FileName);
FileUpload1.SaveAs(FilePath);
DataSet ds_ExcelData = ReadExcelData(FilePath);
gvData.DataSource = ds_ExcelData.Tables[1];
gvData.DataBind();
}
}
}
public DataSet ReadExcelData(string fileName)
{
string strCon = @"Driver={Microsoft Excel Driver (*.xls)};DBQ=" + fileName;
OdbcConnection con = new OdbcConnection(strCon);
DataSet ds = new DataSet();
con.Open();
DataTable dt_SheetNames = con.GetSchema("Tables");
ds.Tables.Add(dt_SheetNames);
for (int i = 0; i < dt_SheetNames.Rows.Count; i++)
{
OdbcCommand cmd = new OdbcCommand(@"SELECT * FROM [" + dt_SheetNames.Rows[i]["TABLE_NAME"].ToString() + "]");
cmd.Connection = con;
OdbcDataAdapter da = new OdbcDataAdapter(cmd);
da.Fill(ds, dt_SheetNames.Rows[i]["TABLE_NAME"].ToString());
}
con.Close();
return ds;
}
}