private void button1_Click(object sender, EventArgs e)

string connectionString;

connectionString = "Provider = microsoft.jet.OLEDB.4.0;" + "Data Source = c:\\Users\\hossein\\db1.mdb";

OleDbConnection connection = new OleDbConnection(connectionString);

// The insertSQL string contains a SQL statement that

// inserts a new row in the source table.

string insertSQL;

insertSQL = "INSERT INTO shakhsi("

+ "shomareh_meli," +

"name," + "last_name," +

"name_father," +

"tarikh_tavalod," +

"telephon," +

"mobile," +

"address)VALUES('"

"','" + textBox2.Text +

"','" + textBox3.Text +

"','" + textBox4.Text +

"','" + textBox6.Text +

"','" + textBox7.Text +

"','" + textBox8.Text +

"','" + textBox9.Text + "')";

OleDbCommand command = new OleDbCommand(insertSQL);

// Set the Connection to the new OleDbConnection.

// Open the connection and execute the insert command.

try

catch (Exception ex)

Console.WriteLine(ex.Message);

// The connection is automatically closed when the

// code exits the using block.

private void button5_Click(object sender, EventArgs e)

string connectionString;

connectionString = "Provider = microsoft.jet.OLEDB.4.0;" + "Data Source = c:\\Users\\hossein\\db1.mdb";

OleDbConnection connection = new OleDbConnection(connectionString);

string insertSQL;

insertSQL = "DELETE from shakhsi where shomareh_meli="+textBox1.Text;

OleDbCommand command = new OleDbCommand(insertSQL);

try

catch (Exception ex)

Console.WriteLine(ex.Message);

private void button6_Click(object sender, EventArgs e)

Binding currentBinding;

DataSet employeesTable = new DataSet();

OleDbConnection sc;

OleDbDataAdapter dataConnect;

try

sc = new OleDbConnection("Provider = microsoft.jet.OLEDB.4.0;" + "Data Source = c:\\Users\\hossein\\db1.mdb");

catch (Exception ex)

MessageBox.Show(ex.Message);

return;

dataConnect = new OleDbDataAdapter("SELECT * FROM shakhsi where shomareh_meli="+textBox1.Text, sc);

dataConnect.Fill(employeesTable, "shakhsi");

try

currentBinding = new Binding("Text", employeesTable, "shakhsi.name");

currentBinding = new Binding("Text", employeesTable, "shakhsi.last_name");

currentBinding = new Binding("Text", employeesTable, "shakhsi.name_father");

currentBinding = new Binding("Text", employeesTable, "shakhsi.tarikh_tavalod");

currentBinding = new Binding("Text", employeesTable, "shakhsi.telephon");

currentBinding = new Binding("Text", employeesTable, "shakhsi.mobile");

currentBinding = new Binding("Text", employeesTable, "shakhsi.address");

catch (Exception ex)

MessageBox.Show(ex.Message);

return;

private void button7_Click(object sender, EventArgs e)

OleDbConnection connection = new OleDbConnection("Provider = microsoft.jet.OLEDB.4.0;" + "Data Source = c:\\Users\\hossein\\db1.mdb");

string queryString = "UPDATE shakhsi SET shomareh_meli='" + textBox1.Text +

"',name='" + textBox2.Text +

"',last_name='" + textBox3.Text +

"',name_father='" + textBox4.Text +

"',tarikh_tavalod='" + textBox6.Text +

"',telephon='" + textBox7.Text +

"',mobile='" + textBox8.Text +

"',address='" + textBox9.Text + "'WHERE shomareh_meli=" + textBox1.Text;

OleDbCommand command = new OleDbCommand(queryString, connection);