لو سمحتو ممكن تقولولي وين الخطأ في ال update statement syntax؟
oleDbConnection1=new OleDbConnection();
oleDbConnection1.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=grades.mdb";
oleDbConnection1.Open();
try
{
oleDbCommand1=new OleDbCommand("update marks set " + "name ='" + textBox9.Text +"', first ="+ textBox10.Text +", second ="+ textBox11.Text +", hw="+ textBox12.Text +", final ="+ textBox13.Text +" where number ='"+ textBox8.Text +"'" ,oleDbConnection1);
oleDbDataAdapter1=new OleDbDataAdapter();
oleDbDataAdapter1.UpdateCommand=oleDbCommand1;
oleDbCommand1.ExecuteNonQuery();
}
catch(Exception eee)
{
MessageBox.Show(eee.ToString());
}
finally
{
oleDbConnection1.Close();
}