18
private void btnSave_Click(object sender, EventArgs e)
{
//this.dataGridView1.CurrentRow.Cells[5].Value.ToString())
string sqlCommand;
sqlCommand =
"Update Inventory SET @ItemDescription= ? " + ",@ItemNumber= ?" +
",@ItemCode= ? " + ",@ItemType= ?" + ",@Location= ? " +
",@DateItemCreated= ? " +
",@Unit= ? " +
",@OurPrice= ? " + ",@StudentPrice= ? " + ",@PONumber= ? " +
",@Quantity= ? " + " Where ItemNumber= ? ";
myOleDbCommand = new OleDbCommand(sqlCommand, myOleDbConnection);
myOleDbCommand.Parameters.Add("ItemDescription", this.dataGridView1.CurrentRow.Cells[0].Value.ToString());
myOleDbCommand.Parameters.Add("ItemNumber",Int32.P arse( this.dataGridView1.CurrentRow.Cells[1].Value.ToString()));
myOleDbCommand.Parameters.Add("ItemCode", this.dataGridView1.CurrentRow.Cells[2].Value.ToString());
myOleDbCommand.Parameters.Add("ItemType", this.dataGridView1.CurrentRow.Cells[3].Value.ToString());
myOleDbCommand.Parameters.Add("Location", this.dataGridView1.CurrentRow.Cells[4].Value.ToString());
myOleDbCommand.Parameters.Add("DateItemCreated", this.dataGridView1.CurrentRow.Cells[5].Value.ToString());
myOleDbCommand.Parameters.Add("Unit", this.dataGridView1.CurrentRow.Cells[6].Value.ToString());
myOleDbCommand.Parameters.Add("OurPrice", this.dataGridView1.CurrentRow.Cells[7].Value.ToString());
myOleDbCommand.Parameters.Add("StudentPrice", this.dataGridView1.CurrentRow.Cells[8].Value.ToString());
myOleDbCommand.Parameters.Add("PONumber", this.dataGridView1.CurrentRow.Cells[9].Value.ToString());
myOleDbCommand.Parameters.Add("Quantity", this.dataGridView1.CurrentRow.Cells[10].Value.ToString());
myOleDbCommand.ExecuteNonQuery();
this.myDataSet.AcceptChanges();
myOleDbDataAdapter.Update(myDataSet, "Inventory");
}//end Save
I am having a problem, when I am trying to update my access database with the help of "datagriedview" in C#. It gives me an error at runtime i.e OleDbException was unhandled "No value given for one or more required parameters."
Could any one tell me what I am doing wrong?
Also the 5th column in my database is date/time type in my access database, but I am only interested in date portion.
