Results 1 - 5 of 6
24 Jun 2019 24 Jun 2019 0 Comments  619 Views
Here Mudassar Ahmed Khan has explained with an example, how to get list of Sheet (WorkSheet) names of Excel file in ASP.Net using C# and VB.Net.

The Excel file will be first uploaded and copied to a Folder (Directory) on Server and then it will be read and opened using OLEDB and the Sheet (WorkSheet) Names of the Excel file will be fetched.
12 Oct 2018 12 Oct 2018 0 Comments  2945 Views
Here Mudassar Ahmed Khan has explained with an example, how to upload, read and display Excel file data using WebGrid in ASP.Net MVC Razor.

The uploaded Excel file data will be read using OLEDB library into a DataSet and then the DataSet will be used to populate WebGrid in ASP.Net MVC Razor.
04 Oct 2018 04 Oct 2018 0 Comments  6447 Views
Here Mudassar Ahmed Khan has explained with an example, how to import Excel data to SQL Server Database using Stored Procedure in ASP.Net using C# and VB.Net.

The Excel file will be first uploaded and copied to a folder on Server. Then using Stored Procedure and OLEDB, the data from Excel file will be read and imported into SQL Server Database Table.
04 Oct 2018 04 Oct 2018 3 Comments  12170 Views
Here Mudassar Ahmed Khan has explained with an example, how to import Excel data to SQL Server Database in ASP.Net using C# and VB.Net.

The Excel Sheet data will be read into a DataTable and then then DataTable data will be imported into SQL Server Database using SqlBulkCopy in ASP.Net.
19 Sep 2018 19 Sep 2018 0 Comments  5928 Views
Here Mudassar Ahmed Khan has explained with an example, how to display Excel file in Web Page in ASP.Net using C# and VB.Net.

The Excel File will be read into a DataTable using OLEDB and ADO.Net and the DataTable will be used to display the Excel File in ASP.Net GridView.
Results 1 - 5 of 6