12 Oct 2018 12 Oct 2018 0 Comments  957 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  1393 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 0 Comments  1092 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  1395 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.
06 Jun 2009 04 Oct 2018 40 Comments  234555 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert data from Excel sheet into SQL Server database table 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.