Click here to Skip to main content
13,050,840 members (72,833 online)
Rate this:
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.. :)
Posted 4-Mar-13 2:04am
CHill60 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 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170713.1 | Last Updated 4 Mar 2013
Copyright © CodeProject, 1999-2017
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