Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
i am getting exception for update statement..
Sometimes i am getting Syntax error or Datatype mismatch error...

the code updates values

string new_val = new_value_txt.Text.ToString();
int rowindex = dataGridView3.CurrentCell.RowIndex;
int row = dataGridView3.CurrentCell.RowIndex;
string row_index_value = dataGridView3["ID", row].Value.ToString();

if (String.IsNullOrEmpty(new_value_txt.Text.Trim()) && String.IsNullOrEmpty(new_value_txt.Text.Trim()))
    MessageBox.Show("Please Enter a New Value..", "Enter a Value", MessageBoxButtons.OKCancel);

OleDbCommand cmd = new OleDbCommand("update Purchases SET " + name_of_column + " ='" + new_val + "' WHERE " + name_of_column + " = '" + cellvalue + "' AND  ID  = '" + row_index_value + "'   ", con);
MessageBox.Show("updated Successfully!!");
can someone please help me with this error...
Thanks in Advance.. Smile | :)
Posted 4-Mar-13 3:04am
CHill60 at 4-Mar-13 8:23am
A lot will depend on the actual content of your variables - are all of your database columns string or dates for example. Using parameterised queries will help you overcome this problem - see and also help protect you from sql injection
ryanb31 at 4-Mar-13 14:27pm
Besides the likelyhood of SQL injections, this should be really easy to figure out. Just put a breakpoint and see what the actual SQL statement is.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Advertise | Privacy | Mobile
Web01 | 2.8.150326.1 | Last Updated 4 Mar 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100