hello dear ! how to make a connection with MS acess database???????????

Question

how we can make a coneection with access database nad how to access tabls and data in c#

Kapil Soni · Answer

using System; using System.Data.OleDb; class OleDbTest{ public static void Main() { //create the database connection OleDbConnection aConnection = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db1.mdb); //create the command object and store the sql query OleDbCommand aCommand = new OleDbCommand(select * from emp_test aConnection); try { aConnection.Open(); //create the datareader object to connect to table OleDbDataReader aReader = aCommand.ExecuteReader(); Console.WriteLine(This is the returned data from emp_test table); //Iterate throuth the database while(aReader.Read()) { Console.WriteLine(aReader.GetInt32(0).ToString()); } //close the reader aReader.Close(); //close the connection Its important. aConnection.Close(); } //Some usual exception handling catch(OleDbException e) { Console.WriteLine(Error: {0} e.Errors[0].Message); } } } Thanks accept is as acnswer if its helps you

Muhammad Usman · Answer

sallam bhi i wll tried with c#. nd thaxxxxxxxxxx for help and but m asked abt coonection with c# any way if u have code for my question thn reply me soon thannnnnnnnnnnnnnxxxxxxx

Crish · Answer

hi use below line for connecting MSAccess Database. public static OleDbConnection myConn = new OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;data source= & (MyDB.mdb));

Syed Shakeer · Answer

Hi below is code for storing MSAccess connection String in WEB.Config For MsAccess database we have to wrte Proivder name as System.Data.OleDb connectionStrings > add name =  MS-db1ConnectionString  connectionString =  Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " C:\Documents and Settings\INTHIYAAZPS\My Documents\MSAccess\db1.mdb "  providerName =  System.Data.OleDb  /> connectionStrings > above Data Source will take the Path of your stored MSAccess database..here my MSaccess database stored path is C:\Documents and Settings\INTHIYAAZPS\My Documents\MSAccess\db1.mdb write the Connection string in Pageload as follows:- first Import the NameSpace for MSAccess as Using System.Data.OleDb { OleDbConnection conn_MSACCESS = new OleDbConnection ( ConfigurationManager .ConnectionStrings[ MS-db1ConnectionString ].ConnectionString); conn_MSACCESS.Open(); Response.Write( MS_ACCESS_connection Connected sucessfully ); conn_MSACCESS.Close(); }