i am try to update my stock using update command but data type miss match criteria error occured

Question

0.00/5 (No votes)

See more:

C#

try
           {
               con = new OleDbConnection(s);
               con.Open();

               sq = "Update BillTable Set Quantity ="+ textBox5.Text + " where Id = " + textBox2.Text;

               cmd = new OleDbCommand(sq,con);
               cmd.ExecuteNonQuery();
               MessageBox.Show("row updated...");

               con.Close();
           }//end f try


           catch (Exception ex)
           {
               MessageBox.Show(ex.ToString());
           }

Posted 25-Oct-14 22:18pm

Shashi14321

Add a Solution

Comments

Richard MacCutchan 26-Oct-14 4:31am

What errors are you seeing? You should also use proper parameterized queries in your SQL, your code is open to SQL injection attack.

1 solution

Add a Solution

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

Sheepings · Answer 1 · 2014-10-26T06:31:00

Do not use string concatenation in query strings, as its highly unsafe.

Your issue in your case is the missing " symbol and the ; symbol for closing the statement as well as the query at then end of your query string.

C#

string sq = ("Update BillTable Set Quantity = " + textBox5.Text + " where Id = " + textBox2.Text + ";");

In MySQL, SQL, you can use Named parameters like @Yourname in your query. But in OleDB you need to specify your parameters in the order of your query and use ? instead of @. See below:

C#

//Opp being your table. ? is your target value parameters which acts as a placeholder. Conn is your connection.

    String dStr = "Two";
    String eStr = "Three";
    OleDbCommand cmdcom = new OleDbCommand("Insert Into Opp [Year] VALUES (?eNum);", Conn);
    cmdcom.Parameters.AddWithValue("?eNum", OledbType.VarChar).Value = dStr);

Parameters in OleDb queries are only assigned by position and the names are disregarded entirely. You can use named queries if added in an orderly way. Meaning; if your query has multiple placeholders ?, they will be called in the order they are wrote. Example:

C#

cmdcom.Parameters.AddWithValue("?dNum", OledbType.VarChar).Value = dStr);
cmdcom.Parameters.AddWithValue("?eNum", OledbType.VarChar).Value = eStr);
//dNum, then eNum etc...

Also, some words are Reserved Words In OleDB and are required to be wrapped in [] brackets. If Year were a reserved word (which it is), you would also wrap that in square brackets.

i am try to update my stock using update command but data type miss match criteria error occured

1 solution

Solution 1

Add your solution here

Preview 0

i am try to update my stock using update command but data type miss match criteria error occured

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us