C # Access database links

private void Button1_Click (object sender, EventArgs e)
{

String strconnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + @ "E:\map\SansMachine.mdb";

OleDbConnection objconnection = new OleDbConnection (strconnection); Establish a connection
Objconnection.open (); Open connection
OleDbCommand sqlcmd = new OleDbCommand (@ "SELECT * from Paramfactvalue where testno=10", objconnection); SQL statements
OleDbDataReader reader = sqlcmd.              ExecuteReader (); Execute Query

while (reader. Read ())
{//This read call is important! If you don't write, the runtime will prompt for no data
age = (int) reader.getstring (0); Gets the value of the field

TextBox1.Text = reader["Name"]. ToString ();
TextBox2.Text = reader["Thevalue"]. ToString ();


}

Objconnection.close ();
Reader. Close ();

｝

C # Access database links