Category - .Net
18 Jun 2020 18 Jun 2020 0 Comments  1363 Views
Here Mudassar Ahmed Khan has explained with an example, how to import (insert) Excel file data into Database using SqlBulkCopy in ASP.Net Core MVC.

The uploaded Excel file data will be read using OLEDB library and the read data will be inserted into SQL Server database using SqlBulkCopy.

SqlBulkCopy class as the name suggests does bulk insert from one source to another and hence all rows from the Excel sheet can be easily read and inserted using the SqlBulkCopy class.
09 Mar 2020 09 Mar 2020 0 Comments  1668 Views
Here Mudassar Ahmed Khan has explained with an example, how to use ConfigurationManager.AppSettings in .Net Core and ASP.Net MVC Core.

Microsoft has replaced ConfigurationManager.AppSettings class of System.Configuration namespace with IConfiguration interface in .Net Core 2.0.
09 Mar 2020 09 Mar 2020 0 Comments  2340 Views
Here Mudassar Ahmed Khan has explained with an example, how to read AppSettings from AppSettings.json file in .Net Core and ASP.Net MVC Core.

Microsoft has replaced System.Configuration class with IConfiguration interface in .Net Core 2.0.
09 Mar 2020 09 Mar 2020 0 Comments  2039 Views
Here Mudassar Ahmed Khan has explained with an example, how to use ConfigurationManager.ConnectionStrings in .Net Core and ASP.Net MVC Core.

Microsoft has replaced ConfigurationManager.ConnectionStrings class of System.Configuration namespace with IConfiguration interface in .Net Core 2.0.
09 Mar 2020 09 Mar 2020 0 Comments  6659 Views
Here Mudassar Ahmed Khan has explained with an example, how to read Connection String from AppSettings.json file in .Net Core and ASP.Net MVC Core.

Microsoft has replaced System.Configuration class with IConfiguration interface in .Net Core 2.0.