pikoolas
چهارشنبه 03 آبان 1391, 13:59 عصر
سلام . من از کد زیر برای اضافه کردن مقداری به دیتابیس اکسس استفاده می کنم . برنامه خطایی نداره و لی مقداری به دیتا بیس اضافه نمیشه ؟؟؟
private void btnNew_Click(object sender, EventArgs e)
{
OleDbConnection oleDbConnection = new OleDbConnection();
oleDbConnection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\db1.mdb";
OleDbCommand oleDbCommand = new OleDbCommand();
oleDbCommand.Connection = oleDbConnection;
// oleDbCommand.CommandText = "insert into Tabel1 (Number, LastName, Phone,Mobile, Address) values('" + txtName.Text + "','" + txtFamily.Text + "','" + txtPhone.Text + "','" + txtMobile.Text + "','" + txtAddress.Text + "')";
oleDbCommand.CommandText = "insert into Table1 ([Number]) values('89')";
try
{
oleDbConnection.Open();
oleDbCommand.ExecuteNonQuery();
oleDbConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btnNew_Click(object sender, EventArgs e)
{
OleDbConnection oleDbConnection = new OleDbConnection();
oleDbConnection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\db1.mdb";
OleDbCommand oleDbCommand = new OleDbCommand();
oleDbCommand.Connection = oleDbConnection;
// oleDbCommand.CommandText = "insert into Tabel1 (Number, LastName, Phone,Mobile, Address) values('" + txtName.Text + "','" + txtFamily.Text + "','" + txtPhone.Text + "','" + txtMobile.Text + "','" + txtAddress.Text + "')";
oleDbCommand.CommandText = "insert into Table1 ([Number]) values('89')";
try
{
oleDbConnection.Open();
oleDbCommand.ExecuteNonQuery();
oleDbConnection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}