It is a very hard question to answer, or rather it is a very abstract question. However take a look at these classes...
OleDbCommand
OleDbDataReader
The OleDbDataReader is a lightweight class (stream) for reading data from the database. There are lots of other classes.
I have used the following connection string...
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[databaseFilename]
Here is a small fragment of code you can use...
Code:
command = new OleDbCommand();
command.Connection = new OleDbConnection(connectionString);
command.CommandText = sql;
try
{
command.Connection.Open();
reader = command.ExecuteReader();
}
catch(OleDbException e)
{
throw new Exception(e.Message);
}
Naturally, some declarations come before this. It will give you a reader from which you can read. Besides the above you should study the database features of .NET more throughly since they are quite different from traditional ASP (at least the way I used these). E.g. take a look at how to use stored procedures, data sets etc.
Read about the objects in the MSDN.
Hope it helps
Jacob.
using access database in C#
