SQL Server Connection Strings In ASP.NET Web Applications for different data providers
02
September
2013
A connection string provides the information that a provider needs to communicate with a particular database. The Connection String includes parameters such as the name of the driver, Server name and Database name , as well as security information such as user name and password.

 

An ADO.NET Data Provider is a class that can communicate with a specific type of database or data store. Usually Data Providers use a connection string containing a collection of parameters to establish the connection with the database through applications. The .NET Framework provides mainly three data providers, they are

 

  Microsoft SQL Server
  OLEDB
  ODBC

 

Here you can see how to make a connection string to the following ADO.NET Data Providers.

 

with ms-ACCESS 2007

 

using System.Data.OleDb;
//2.
    OleDbConnection x; //Create connection
    OleDbCommand y; //to run sql command
    OleDbDataReader z; //To hold data
    private void button1_Click(object sender, EventArgs e)
        {
            //3
            x = new OleDbConnection(“provider=microsoft.ace.oledb.12.0;data source=d:\\database1.accdb”);
            x.Open();
            //4
       y = new OleDbCommand(“select * from emp”, x);
   //5
      z = y.ExecuteReader();
            //6
            while (z.Read())
            {
                //MessageBox.Show(z[“empno”].ToString() + ” ” + z[“ename”].ToString() + ” ” + z[“sal”].ToString());
                MessageBox.Show(z[0].ToString() + ” ” + z[1].ToString() + ” ” + z[2].ToString());
            }
            //7
            x.Close();
      }

 

ACCESS –2003

 

   x = new OleDbConnection(“provider=microsoft.jet.oledb.4.0;data source=d:\\database1.mdb”);
How to connect with Excel:-
  OleDbConnection x;
  OleDbCommand y;
  OleDbDataReader z;
        private void button1_Click(object sender, EventArgs e)
        {
            x = new OleDbConnection(“provider=microsoft.ace.oledb.12.0;data source=c:\\Book1.xlsx;extended properties=excel 12.0”);
            x.Open();
            y = new OleDbCommand(“select * from [sheet1$]”, x);
            z = y.ExecuteReader();
            while (z.Read())
            {
      MessageBox.Show(z[0].ToString() + ” ” + z[1].ToString() + ” ” +     z[2].ToString());
            }
            x.Close();
        }
How to connect with Oracle
        OleDbConnection x;
        OleDbCommand y;
        OleDbDataReader z;
        private void button1_Click(object sender, EventArgs e)
        {
            x = new OleDbConnection(“provider=msdaora;user id=scott;password=tiger”);
            x.Open();
            y = new OleDbCommand(“select * from emp”, x);
            z = y.ExecuteReader();
            while (z.Read())
            {
                MessageBox.Show(z[0].ToString() + ” ” + z[1].ToString() + ” ” + z[2].ToString());
            }
            x.Close();
        }
how to make connectvitiy with oracle using Oracleclient:-

 

Add reference :- system.data.oracleclient
using System.Data.OracleClient;
        OracleConnection x;
        OracleCommand y;
        OracleDataReader z;
        private void button1_Click(object sender, EventArgs e)
        {
            x = new OracleConnection(“user id=scott;password=tiger”);
            x.Open();
            y = new OracleCommand(“select * from emp”, x);
            z = y.ExecuteReader();
            while (z.Read())
            {
                MessageBox.Show(z[0].ToString() + ” ” + z[1].ToString() + ” ” + z[2].ToString());
            }
            x.Close();
        }
Pin It