Where to set provider name in web.config or page itself ?

Question

0.00/5 (No votes)

See more:

If i set provider in sql connection string in web.config file ( providerName="System.Data.SqlClient") then should i also include "using System.Data.SqlClient" in page level coding.

Can i write ado.net code without "using statement" in page by help of provider name specified in sql conn string in web.config?

Please explain.

What I have tried:

I have written providerName="System.Data.SqlClient"
I have also included "using System.Data.SqlClient"

Posted 5-Apr-17 18:24pm

jayesh_n

Updated 5-Apr-17 19:37pm

v4

Add a Solution

Comments

Bryian Tan 6-Apr-17 1:05am

web.config. Example.

<connectionStrings>    <add name="MySqlConnection" connectionString="Data Source=Hello;User ID=test;Password=Pass;Initial Catalog=Table1;Integrated Security=True" providerName="System.Data.SqlClient" />      </connectionStrings>

Is the application throwing error message or something?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Answer 1 · 2017-04-05T19:37:00

The System.Data.SqlClient provider is the default .NET Framework Data Provider for SQL Server.
The System.Data.OleDb provider is the .NET Framework Data Provider for OLE DB.
The System.Data.Odbc provider is the .NET Framework Data Provider for ODBC.
The System.Data.OracleClient provider is the .NET Framework Data Provider for Oracle.
source: SqlDataSource.ProviderName Property (System.Web.UI.WebControls)[^]

You will have to specify at both the place ( Connection string and code )

Few Examples
SQL Server

C#

using System.Data.SqlClient;
class Program
{
    static void Main()
    {
        string sqlConnString = "Data Source=ServerName;Initial Catalog=DbName;Integrated Security=True"; // for SQL provider name is not mandatory
        SqlCommand objSQLCmd = new SqlCommand();
        
    } 
}

OLEDB

C#

using System.Data.OleDb;
class Program
{
    static void Main()
    {
        string oleConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='D://abc.xls'; Extended Properties= 'Excel 12.0;HDR=Yes;IMEX=1'"; // provider name is mandatory here
        OleDbCommand objOleDBExcelCmd = new OleDbCommand();
    } 
}