formview show error while updating

Question

1.00/5 (2 votes)

See more:

I am new to programming.
I am working on project.
I have bind Gridview and on the selection of the row from gridview a formview
appear with all details .
I have give option over their to edit record.
I have total 32 textbox.
amoung them i have field whose datatype is Decimal and Datetime
But if the decimal field are left blank and click on update it show error that
Error converting data type varchar to numeric.
And after update how to return from edit mode to readonly mode in form view

Posted 9-Apr-12 4:41am

Yadav Anil

Updated 9-Apr-12 9:02am

ZurdoDev

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 9-Apr-12 12:49pm

There are many ways to screw up things. How can we know which one is your favorite? :-)
"Improve question" is above.
--SA

1 solution

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)

SASS_Shooter · Answer 1 · 2012-04-13T11:25:00

Instead of blindly passing data to the database(?) -- not sure if that is where you are sending your data since you don't specify!

You need to meet with the users, determine what the default values should be, then set the fields to the default value if xn.Text.Length.Equals(0) | xn is one of your 32 text boxes.

The other alternative (if there is no default) is change the database to accept null values. Then null is the default value if no value is entered.

Programming 101 for this problem.