protected void btnUploadExcel_Click(object sender, EventArgs e) { try { if (excelUpload.HasFile) { extension = String.Empty; extension = excelUpload.FileName.Substring(excelUpload.FileName.LastIndexOf(".")); string FileName = excelUpload.FileName; excelUpload.SaveAs(HttpContext.Current.Server.MapPath("excelfile/" + FileName)); StateData sdata = new StateData(); dt = ReadExcelFile.ReadAsDataTable(FileName); for (int i = 0; i < dt.Rows.Count; i++) { sdata.Name = dt.Rows[i][0].ToString(); sdata.Save(); } } } catch (Exception ex) { } }