Here Mudassar Ahmed Khan has explained with an example, how to implement CRUD operations without using Entity Framework in ASP.Net MVC Razor.

This article will illustrate how to implement CRUD operations i.e. Select, Insert, Edit, Update and Delete using ADO.Net in ASP.Net MVC Razor.

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.

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.

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.