Doubt in inserting data from form to database

Question

Hi I am new in c#.I am doing billing project i have one form for billing it works well. But my doubt is when i click save button i got an exception Data type mismatch in criteria expression. But one thing all text box are fill it saved successfully. When some fields are empty i got the above exception please help me..... Thanks in advance....

leathu raj · Answer

thanks

leathu raj · Answer

thanks for your reply... now it runs correctly

leathu raj · Answer

Thanks for your reply.... now its work well

Biswa Pujarini Mohapatra · Answer

can you post your code here only database insert part is enough

Abhay Shanker · Answer

HI Cross check below points records you are submitting has same data type as mentioned in table/stored procedure no of submitting records are always matched with the columns in the table handled nullable records correctly

Deepak Kumar Choudhary · Answer

You should check 1.String should be within single Quotes. 2.Numeric values should not be within Quotes The only reason this error occurs is on inserting wrong datatype to the field. Please check if the description (Datatype) about your field is mentioned correctly. And please specify what value you are supplying that gives this error.