how to display excel file data in gridview?

Here's an article on how to import excel sheet data to Gridview Control in Asp.net C#, bonus point is here pagination is also maintanied by using session

hi Friends i am sending the code please check it... please dont share me any link once check this and tell me where i did mistake.. design page/// code/// protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { AddDefaultFirstRecord(); } } private void AddDefaultFirstRecord() { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Patient ID", typeof(int))); dt.Columns.Add(new DataColumn("Assay", typeof(string))); dt.Columns.Add(new DataColumn("Well", typeof(string))); dt.Columns.Add(new DataColumn("Flag", typeof(string))); dt.Columns.Add(new DataColumn("Value", typeof(string))); dt.Columns.Add(new DataColumn("S/CO", typeof(string))); dt.Columns.Add(new DataColumn("Result", typeof(string))); gvexcel.DataSource = dt; gvexcel.DataBind(); } protected void btnupload_click(object sender, EventArgs e) { string connString = ""; string strFileType = Path.GetExtension(fileupload1.FileName).ToLower(); string path = fileupload1.PostedFile.FileName; if (strFileType.Trim() == ".xls") { connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFileType + ";Extended Properties=\"Excel 12.0;IMEX=1;HDR=NO;TypeGuessRows=0;ImportMixedTypes=Text\""; } //string query = "Select [Patient ID],[Assay],[Well],[Flag],[Value],[S/CO],[Result] from [Sheet1$]"; OleDbConnection conn = new OleDbConnection(connString); if (conn.State == ConnectionState.Closed) conn.Open(); OleDbCommand cmd = new OleDbCommand("Select [Patient ID],[Assay],[Well],[Flag],[Value],[S/CO],[Result] from [Sheet1$]", conn); OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); gvexcel.DataSource = ds.Tables[0]; gvexcel.DataBind(); da.Dispose(); conn.Close(); conn.Dispose(); } }

hi Friends i am sending the code please check it... please dont share me any link once check this and tell me where i did mistake.. design page/// code/// protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { AddDefaultFirstRecord(); } } private void AddDefaultFirstRecord() { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Patient ID", typeof(int))); dt.Columns.Add(new DataColumn("Assay", typeof(string))); dt.Columns.Add(new DataColumn("Well", typeof(string))); dt.Columns.Add(new DataColumn("Flag", typeof(string))); dt.Columns.Add(new DataColumn("Value", typeof(string))); dt.Columns.Add(new DataColumn("S/CO", typeof(string))); dt.Columns.Add(new DataColumn("Result", typeof(string))); gvexcel.DataSource = dt; gvexcel.DataBind(); } protected void btnupload_click(object sender, EventArgs e) { string connString = ""; string strFileType = Path.GetExtension(fileupload1.FileName).ToLower(); string path = fileupload1.PostedFile.FileName; if (strFileType.Trim() == ".xls") { connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strFileType + ";Extended Properties=\"Excel 12.0;IMEX=1;HDR=NO;TypeGuessRows=0;ImportMixedTypes=Text\""; } //string query = "Select [Patient ID],[Assay],[Well],[Flag],[Value],[S/CO],[Result] from [Sheet1$]"; OleDbConnection conn = new OleDbConnection(connString); if (conn.State == ConnectionState.Closed) conn.Open(); OleDbCommand cmd = new OleDbCommand("Select [Patient ID],[Assay],[Well],[Flag],[Value],[S/CO],[Result] from [Sheet1$]", conn); OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); gvexcel.DataSource = ds.Tables[0]; gvexcel.DataBind(); da.Dispose(); conn.Close(); conn.Dispose(); } }