Null value validation

Question

0.00/5 (No votes)

See more:

Good Evening to all in my project i am using rad grid how can i validate the null values in update command and insert command.Please help me any one.

Thanks in advance
By
Meganathan

Posted 26-Oct-12 3:45am

meganathanm

Add a Solution

Comments

E.F. Nijboer 26-Oct-12 10:13am

Your question isn't very clear. Have you checked out DBNull?

meganathanm 26-Oct-12 10:24am

Thank you for your reply i am not check the db value. First i am insert the first record at that time i am failed to fill the some required value in text box and click on insert how can i validate and give the alert.I get the text box value from code behind as follows
string Booksubcategoryname = (insertedItem["Booksubcategoryname"].Controls[0] as TextBox).Text;

Sergey Alexandrovich Kryukov 26-Oct-12 12:58pm

Are you working with System.DBNull? If so what's the problem?
http://msdn.microsoft.com/en-us/library/system.dbnull.aspx
--SA

Sandeep Mewara 28-Oct-12 4:04am

Please elaborate and be specific.
Use the "Improve question" link to edit your question and provide better information.

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)

Frederico Barbosa · Answer 1 · 2012-10-29T07:15:00

Solution 1

Use the static method "bool System.String.IsNullOrEmpty(string value)", something like this:

C#

string text = SomeControl.Text;
if (String.IsNullOrEmpty(text))
{
    // Warn user or whatever...
}
else
{
    // use string...
}

Posted 29-Oct-12 7:15am

Frederico Barbosa

Comments

meganathanm 29-Jan-13 10:16am

Thank you for your reply Mr.Frederico Barbosa Your code is working fine for me but i need the client side validation.