Data type mismatch error in Access

Question

0.00/5 (No votes)

See more:

This is coding for update data in access databese based on serial number.
In database it in integer datatype. Enter the serial number through textbox. It is in string datatype. I converted into integer data type and then check the where conditon in query string. Please do some help.

C#

protected void Button11_Click(object sender, EventArgs e)
   {
     int x;
     String s;
     s = TextBox1.Text;
     x=(Convert.ToInt32(s));
    cmd = new OleDbCommand("update userdata set firstname='" + TextBox2.Text + "', lastname='" + TextBox7.Text + "', department='" + TextBox3.Text + "', software='" + TextBox4.Text + "', hardware='" + TextBox5.Text + "' where sno='" + s +"'", con);
    cmd.ExecuteNonQuery();

Error:pre>Data type mismatch in criteria expression.

Thank you,

Posted 11-Oct-11 0:23am

anusangeetha

Add a Solution

Comments

Muralikrishna8811 11-Oct-11 6:33am

hi check your sno datatype in database if it is int just remove ' from query

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2011-10-11T00:32:00

Please, don't do it that way. That is an invitation to the accidental or deliberate destruction of your database.
Use Parametrised queries instead (and your problem will disapear as well).

C#

cmd = new OleDbCommand("UPDATE userdata SET firstname=@FN, lastname=@LN, department=@DP, software=@SW, hardware=@HW WHERE sno=@SN", con);
cmd.Parameters.AddWithValue("@FN", TextBox2.Text);
cmd.Parameters.AddWithValue("@LN", TextBox7.Text);
cmd.Parameters.AddWithValue("@DP", TextBox3.Text);
cmd.Parameters.AddWithValue("@SW", TextBox4.Text);
cmd.Parameters.AddWithValue("@HW", TextBox5.Text);
cmd.Parameters.AddWithValue("@SN", x);
cmd.ExecuteNonQuery()

Oh, and BTW: don't use the default name for controls. You may remember that TextBox5 has the Hardware today, but in six weeks time? No chance. If you call it tbHardware instead, then it is obvious when you write it, and when you look back on it for maintenance.

Uday P.Singh · Answer 2 · 2011-10-11T00:29:00

Try this

C#

cmd = new OleDbCommand("update userdata set firstname='" + TextBox2.Text + "', lastname='" + TextBox7.Text + "', department='" + TextBox3.Text + "', software='" + TextBox4.Text + "', hardware='" + TextBox5.Text + "' where sno=" + x +"", con);

But I recommend you to use parametrized query to avoid SQL injection attacks.

hope it helps :)

Tejas Vaishnav · Answer 3 · 2011-10-11T00:33:00

Hello Friend

your are converting TextBox1.Text value to int variable named "x", and you pass your string value "s" to your query... and also cast your sno in ' ' so its become a string instead of int,
so try this query instead of yours

C#

protected void Button11_Click(object sender, EventArgs e)
{
     int x;
     string s;
     s = TextBox1.Text;
     x=(Convert.ToInt32(s));
     cmd = new OleDbCommand("update userdata set firstname='" + TextBox2.Text + "', lastname='" + TextBox7.Text + "', department='" + TextBox3.Text + "', software='" + TextBox4.Text + "', hardware='" + TextBox5.Text + "' where sno=" + x, con);
}
 cmd.ExecuteNonQuery();

Data type mismatch error in Access

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0