Hello
I need your help, I am developing an app in C# using an
Access database(2007), the problem I think is the query update, I have
searched over internet but nothing works, I have a datagridview and It
has 3 columns the user needs to puts data to the last 2 columns(5 rows),
I already do it but when I fill the columns in the datagridview It
doenst store the data in the database access. So please I need you help
this is my code, help very apreciated :D
private void btnGuardar_Click(object sender, EventArgs e)
{
//using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Databsename.accdb"))
//{
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Databasename.accdb;Persist Security Info=false");
int grade = 1;
string x;
string comment;
for (int i = 0; i < this.dataGridView4.Rows.Count-1; i++)
{
x = dataGridView4.Rows[i].Cells[1].Value.ToString();
//Console.WriteLine(x);
MessageBox.Show(x);
grade = int.Parse(x);
comment = dataGridView4.Rows[i].Cells[2].Value.ToString();
MessageBox.Show(comment);
OleDbCommand cmd = new OleDbCommand("Update archievemnet set grade= @GRADE comment=@COMMENT WHERE idLine =1 ", conn);
cmd.Parameters.Add(new OleDbParameter("@GRADE", OleDbType.Integer));
cmd.Parameters["@GRADE"].Value = grade;
cmd.Parameters.Add(new OleDbParameter("@comment", OleDbType.VarChar));
cmd.Parameters["@COMMENT"].Value = comment;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
//}
}
|