DaniWeb Forum Index > Software Development > C#

C# RSS

connection string of SqlConnection

Please support our C# advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: May 2007

Posts: 266

Reputation: quintoncoert is an unknown quantity at this point

Solved Threads: 3

quintoncoert quintoncoert is offline

Offline

Posting Whiz in Training

connection string of SqlConnection

Jul 9th, 2007

i am trying to connect to an MS Access database but i am new to C#. I have looked at, amongst others, Paladin's response to dark omen about connecting to a database and since i have connected to a database before in Visual Basic most of it makes sense to me.

However i do not understand the argument list for the connection string of the SqlConnection object's SqlConnection constructor. On various info sources the arg list for the constructor seems to differ slightly so i assume that some arguments are optional. can someone please tell me what the bare minimum of arguments are for connecting to an MS Access database on a local pc and what each argument means?

Last edited by quintoncoert; Jul 9th, 2007 at 8:29 am. Reason: ommited information

•

Join Date: Jul 2007

Posts: 2

Reputation: kailash.kandpal is an unknown quantity at this point

Solved Threads: 1

kailash.kandpal kailash.kandpal is offline

Offline

Newbie Poster

Re: connection string of SqlConnection

Jul 9th, 2007

please follow following link
http://www.codeproject.com/cs/databa...ssInCSharp.asp

or write following code

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
using System;
using System.Data;
using System.Data.OleDb;
 
public class Test{
    public static void Main()
    {
    string source = "Provider=Microsoft.JET.OLEDB.4.0;" + "data     source=""C:\\Winnt\\Profiles\\Administrator\\Personal\\db2.mdb
    string command="SELECT Name, Assets FROM Bank_customer_data";
    OleDbCommand mCommand = new OleDbCommand(); 
    OleDbConnection mConnection=new OleDbConnection(source);
    mConnection.Open();
    mCommand.ActiveConnection=mConnection; 
    mCommand.CommandText=command;
    OleDbDataReader mReader;
    mCommand.Execute(out mReader); 
    // Use Read to  read data line by line.
    while (mReader.Read()) 
        { //The data is extracted with the methods GetString and GetInt32
        Console.WriteLine(mReader.GetString(0) + ":" + mReader.GetInt32(1));
        }
    // Close the Reader when done. 
    mReader.Close();
    // Close the connection when done. 
    mConnection.Close(); 
    }
}
 
using System;
using System.Data;
using System.Data.OleDb;

public class Test{
    public static void Main()
    {
    string source = "Provider=Microsoft.JET.OLEDB.4.0;" + "data     source=""C:\\Winnt\\Profiles\\Administrator\\Personal\\db2.mdb
    string command="SELECT Name, Assets FROM Bank_customer_data";
    OleDbCommand mCommand = new OleDbCommand(); 
    OleDbConnection mConnection=new OleDbConnection(source);
    mConnection.Open();
    mCommand.ActiveConnection=mConnection; 
    mCommand.CommandText=command;
    OleDbDataReader mReader;
    mCommand.Execute(out mReader); 
    // Use Read to  read data line by line.
    while (mReader.Read()) 
        { //The data is extracted with the methods GetString and GetInt32
        Console.WriteLine(mReader.GetString(0) + ":" + mReader.GetInt32(1));
        }
    // Close the Reader when done. 
    mReader.Close();
    // Close the connection when done. 
    mConnection.Close(); 
    }
}