connection string of SqlConnection

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?

quintoncoert

Posting Whiz in Training

266 posts since May 2007

Reputation Points: 160

Solved Threads: 3

4 Years Ago

0

please follow following link
http://www.codeproject.com/cs/database/linkAccessInCSharp.asp

or write following code

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(); 
    }
}

kailash.kandpal

Newbie Poster

2 posts since Jul 2007

Reputation Points: 10

Solved Threads: 1

4 Years Ago

0

http://www.connectionstrings.com/ the best damn link hands down in finding the right string to use to connect to a given array of database types.

Killer_Typo

Master Poster

781 posts since Apr 2004

Reputation Points: 152