data insert problem

Question

0.00/5 (No votes)

See more:

hi there,

there is total 10 field in table(access). whenever i leave textbox blank it gives error ("datatype mismatch in criteria expression").

how can i solve it.

Posted 9-Feb-14 17:18pm

Bhatt Aniruddh

Add a Solution

Comments

Siva Hyderabad 9-Feb-14 23:22pm

which textbox.,which datatype you take for that?

[no name] 10-Feb-14 0:05am

for mobile number (textbox). number datatypes

Karen Mitchelle 10-Feb-14 0:23am

the error message already said it. Could you give us enough information for this. Textboxes receive and store values as string. So if in your table, it is declared as int, and you store it directly, a datatype mismatch will occur.

[no name] 10-Feb-14 0:30am

so what is the solution....

Karen Mitchelle 10-Feb-14 0:36am

Can you please give me at least the scenario of what your problem looks like? Thanks..

[no name] 10-Feb-14 3:29am

filed datatypes
srno autonumber
name text
contact text
amount number

whenever i leave txtamount. then it gives error.

Karen Mitchelle 10-Feb-14 3:58am

You have fields on your database, that's what you mentioned above. Then when you leave the txtamount with no value, and click a button so that it has to be saved on your database, you got that error? Is that it?
or,
the moment the cursor left the textbox, that error immediately pop?

I can't understand the "I leave the txtamount" scenario you are saying..

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)

Abhinav S · Answer 1 · 2014-02-09T17:33:00

Solution 1

Your question does not provide enough information to answer the question completely.

However, this error occurs when you are inserting the wrong data type in a column for e.g. int in a datetime field etc.

Posted 9-Feb-14 17:33pm

Abhinav S

Comments

[no name] 9-Feb-14 23:55pm

when i leave number filed leave then it gives error.

Siva Hyderabad · Answer 2 · 2014-02-09T18:20:00

Solution 2

for mobile number ,You should given like..

In SQL you need to create the column as "varchar" datatype

To access that value in C# take "string" variable

Posted 9-Feb-14 18:20pm

Siva Hyderabad

Updated 9-Feb-14 18:27pm

v2

Aravindba · Answer 3 · 2014-02-09T18:24:00

Hai

Try to check no of fields u have to insert,may be u have 10 fields but u try to insert only 9 values so it gives error,check insert query,paste ur insert query here ,then find error easily.

And if u insert integer give single qutos ,if it is string give double quots.

Why u leave empty text box ? u try to insert empty values so it gives error.so change the column in a access table like select column and give "Required" as No in each column,may be for number column cant give empty value,so make it as mandatory field.