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)
{
}
}
