foreach (GridViewRow g1 in GridView1.Rows)
{
OleDbCommand oleDbCmd4 = con.CreateCommand();
con.Open();
oleDbCmd4 = new OleDbCommand("INSERT INTO [Article of clients (step)] (CodArt, NumFas, CodPie,Operac, FasExt, CodMaq,CodUti, TiePre, TieFab, CodPro, Control) VALUES (@one,@two,@three,@four,@five,@six,@seven,@eight,@nine,@ten,@eleven)", con);
oleDbCmd4.Parameters.AddWithValue("@one", g1.Cells[0].Text);
oleDbCmd4.Parameters.AddWithValue("@two", g1.Cells[1].Text);
oleDbCmd4.Parameters.AddWithValue("@three", g1.Cells[2].Text);
oleDbCmd4.Parameters.AddWithValue("@four", g1.Cells[3].Text);
oleDbCmd4.Parameters.AddWithValue("@five", g1.Cells[4].Text);
oleDbCmd4.Parameters.AddWithValue("@six", g1.Cells[5].Text);
oleDbCmd4.Parameters.AddWithValue("@seven", g1.Cells[6].Text);
oleDbCmd4.Parameters.AddWithValue("@eight", g1.Cells[7].Text);
oleDbCmd4.Parameters.AddWithValue("@nine", g1.Cells[8].Text);
oleDbCmd4.Parameters.AddWithValue("@ten", g1.Cells[9].Text);
oleDbCmd4.Parameters.AddWithValue("@eleven", g1.Cells[10].Text);
oleDbCmd4.ExecuteNonQuery();
con.Close();
}
What I have tried:
Plz help. I have tried alot but it throw me this error Data type mismatch in criteria expression.