There are
two ways to connect to an Access database
:
1)Visually, with design-time tools.
2)Programmatically.
Programmatically:
include these namespaces in your project:
using System.Data;
using System.Data.OleDb;
and have a example for string connection:
public void Accessdata()
{
System.Data.OleDb.OleDbConnection conn =
new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data source= C:\Documents and Settings\username\" +
@"My Documents\AccessFile.mdb";
try
{
conn.Open();
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}
Visually, with design-time tools
Creating Connections to Access Databases[
^]