Category - SQL Server
Results 1 - 5 of 160
Here Mudassar Ahmed Khan has explained with an example, how to set and read SQL Server Connection String for SQL Server Authentication in Web.Config file in ASP.Net using C# and VB.Net.

In ASP.Net Web Applications, one has to reference the System.Configuration Assembly in order to read the SQL Server Connection String for SQL Server Authentication from the ConnectionStrings section of the Web.Config file.
Here Mudassar Ahmed Khan has explained with an example, how to set and read SQL Server Connection String for Windows Authentication in Web.Config file in ASP.Net using C# and VB.Net.

In ASP.Net Web Applications, one has to reference the System.Configuration Assembly in order to read the SQL Server Connection String for Windows Authentication from the ConnectionStrings section of the Web.Config file.
Here Mudassar Ahmed Khan has explained with an example, how to call (consume) WCF Service (SVC) without using Proxy in ASP.Net using C# and VB.Net.

The WCF Service (SVC) can be called (consumed) without using Proxy by making use of the ChannelFactory class in ASP.Net.
Here Mudassar Ahmed Khan has explained with an example, how to call (consume) WCF Service (SVC) without adding Service Reference in ASP.Net using C# and VB.Net.
The WCF Service (SVC) can be called (consumed) without adding Service Reference by making use of the ChannelFactory class in ASP.Net.
Here Mudassar Ahmed Khan has explained with an example, how to import (insert) data from Excel file into SQL Server database table using SqlBulkCopy in ASP.Net MVC Razor.

The uploaded Excel file data will be read using OLEDB library and the read data will be inserted into SQL Server database table 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 into SQL Server database table using the SqlBulkCopy class.
Results 1 - 5 of 160