astigka2030
Addict
- Joined
- Nov 8, 2014
- Posts
- 29
- Reaction
- 3
- Points
- 70
- Age
- 22
Hi mga master sa C# patulong nmn sa update statement eto po code ko:
OleDbConnection oleDbConnection = new
OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\COMPAQ\\Desktop\\data.accdb;Persist Security Info=False;");
OleDbCommand update = new OleDbCommand("Update Registered SET [StudentNumber]="+textBox1.Text+" ,LastName=" + textBox2.Text + "' ,FirstName='" + textBox3.Text + "' WHERE SID=" + textBox6.Text + "", oleDbConnection);
oleDbConnection.Open();
update.ExecuteNonQuery();
oleDbConnection.Close();
MessageBox.Show("Data Updated!");
Ok nmn sya pag tatlong textbox lng ang i-eedit pero pag dadagdagan ko na sya nag syntax error na may iba pa bang paraan para madagdagan ko ung pwede pang i-edit?
Salamat sa makakatulong!
OleDbConnection oleDbConnection = new
OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\COMPAQ\\Desktop\\data.accdb;Persist Security Info=False;");
OleDbCommand update = new OleDbCommand("Update Registered SET [StudentNumber]="+textBox1.Text+" ,LastName=" + textBox2.Text + "' ,FirstName='" + textBox3.Text + "' WHERE SID=" + textBox6.Text + "", oleDbConnection);
oleDbConnection.Open();
update.ExecuteNonQuery();
oleDbConnection.Close();
MessageBox.Show("Data Updated!");
Ok nmn sya pag tatlong textbox lng ang i-eedit pero pag dadagdagan ko na sya nag syntax error na may iba pa bang paraan para madagdagan ko ung pwede pang i-edit?
Salamat sa makakatulong!