Connection to a MS Access database

[Eifel-benz]

How to get connection to a MS Access database?
How to read from a MS Access database?
How to close the connection to a MS Access database?

[Artur Sorszegi]

Hi

Accessing an Access database is just as easy as accessing any other
database. You should use OleDb data providers to establish a connection. A
connection string is something like this. The Provider is the most important
thing to remember. Note, that the database must exist.

dbconn.Connecti onString =
@"Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source=c:\inetp ub\wwwroot\stud ydotnet\study.m db";

You can read data just as easily as with any other datasource. You can use a
DataAdapter to fill a DataSet, or use the DataReader to read data. In either
case, you can use SQL SELECT statement to get the data.

And closing, well, simply call Close() on the connection. It really doesn't
work that much different from other data providers.

-Artur
"Eifel-benz" <Ei********@lyc os.de> wrote in message
news:78******** *************** ***********@mic rosoft.com...

How to get connection to a MS Access database?
How to read from a MS Access database?
How to close the connection to a MS Access database?

[Ross Jones]

Just for info, in case you hadn't seen it if you can't remember a connection
string you can always visit http://www.connectionstrings.com/ which should
help.

Ross.

"Artur Sorszegi" <ar***********@ freemail.hu> wrote in message
news:%2******** *******@TK2MSFT NGP11.phx.gbl.. .

Hi

Accessing an Access database is just as easy as accessing any other
database. You should use OleDb data providers to establish a connection. A
connection string is something like this. The Provider is the most important thing to remember. Note, that the database must exist.

dbconn.Connecti onString =
@"Provider=Micr osoft.Jet.OLEDB .4.0;Data
Source=c:\inetp ub\wwwroot\stud ydotnet\study.m db";

You can read data just as easily as with any other datasource. You can use a DataAdapter to fill a DataSet, or use the DataReader to read data. In either case, you can use SQL SELECT statement to get the data.

And closing, well, simply call Close() on the connection. It really doesn't work that much different from other data providers.

-Artur
"Eifel-benz" <Ei********@lyc os.de> wrote in message
news:78******** *************** ***********@mic rosoft.com...

How to get connection to a MS Access database?
How to read from a MS Access database?
How to close the connection to a MS Access database?

[Irfan]

Hi,

Here's the code

string strConnect
= "Provider=Micro soft.Jet.OLEDB. 4.0 ;Data
Source="+Server .MapPath(".\\db \\forum.mdb");
string strSelect = "SELECT * FROM
topics ORDER BY TopicCreateDate DESC";
try
{

//create a new
OleDbConnection object using the connection string
OleDbConnection objConnect
= new OleDbConnection (strConnect);

//open the connection to
the database
objConnect.Open ();

//create a new
OleDbCommand using the connection object and select
statement
OleDbCommand objCommand =
new OleDbCommand(st rSelect, objConnect);

//declare a variable to
hold a DataReader object
OleDbDataReader
objDataReader;

//execute the SQL
statement against the command to fill the DataReader
objDataReader =
objCommand.Exec uteReader();

DataGrid1.DataS ource =
objDataReader;
DataGrid1.DataB ind();

if (DataGrid1.Item s.Count
== 0)
{
outError.InnerH tml
= "There are currently no Postings for this topic, start
the posts with the form above.";
}

//close the DataReader and
Connection
objDataReader.C lose();
objConnect.Clos e();

}

catch (Exception objError)
{

//display error details
outError.InnerH tml = "<b>*
Error while accessing data</b>.<br />"
+ objError.Messag e
+ "<br />" + objError.Source ;
return; //and stop
execution
}

Irfan

[irfan]

Sorry, seems to be self explainatory!. it shows the usage
of a datagrid control and how the data from db is attached
to it.