Import the excel file using file upload option

Question

My code as follows

protected void btnimport_Click(object sender, EventArgs e)
{
string path = System.IO.Path.GetFileName(fileupload15.PostedFile.FileName);
fileupload15.PostedFile.SaveAs(Server.MapPath("~/Import_Excel/" + path));
GvSch.DataSource = ImportExcelXLS(path, false, out message);
GvSch.DataBind();
}

i create a new folder name called Import_Excel in that folder i want to save the selected excel file.

In run mode i click the choose file and select the excel file and click import button

When i run the above code shows error as follows

ilistsource does not contain any data sources

please help me.
what is the mistake from my above code.

Kyle Story · Answer

You have provided a very limited information about your issue. I'm guessing that GvSch is a GridView control and that ImportExcelXLS method converts the excel file to DataTable right? Then it is possible that an issue lies in that method and it is not generating the required data source for the GridView. Without seeing the method I cannot say for sure but nevertheless here is a way you can read your uploaded XLS file in C# and then convert that XLS to a DataTable : private static DataTable ImportExcelXLS( string path) { ExcelFile file = ExcelFile .Load(path); CreateDataTableOptions options = new CreateDataTableOptions ( A1  1000 5); return file.Worksheets.ActiveWorksheet.CreateDataTable(options); }

Suthish Nair · Answer

ilistsource trying to bind with some source but not available during runtime. put a break point debug the code and find the exact line throwing the error..

Sahil Sharma · Answer

I hope this article helps http://www.c-sharpcorner.com/uploadfile/0c1bb2/uploading-and-downloading-excel-files-from-database-using-as/