How to validate in Data Table columnwise

Question

0.00/5 (No votes)

See more:

CSS

I have a datatable having a 5 rows and 4 columns

this 5 rows and 4 columns should fill


Datatable Name is dtexam

Should be like this:
Name  Mark1 Mark2 Mark3

V1     20    20     20   <----

v2     30    30     10   <----

v3     50    40     10   <----

v4     50    20     10   <----

v5     40    30     50   <----




shouldnot be like this:

Name  Mark1 Mark2 Mark3

V1     20           20

v2     30           10

v3     50    40     10

v4     50    20

v5     40           50


   For row validation i did like this..

   if(dtexams.rows.count<=0)
   {
      obal.mess("Please fill marks");
   }

  for this Scenario it checking rowwise correct.

  i want columnwise also to validate..

Posted 13-Jul-12 22:37pm

Salt Pepper

Add a Solution

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)

Shemeer NS · Answer 1 · 2012-07-13T23:11:00

It would be better if you validate this from the UI control itself instead of looping in datatable...

Or else you can try something like this

C#

for (int i = 0; i < dt.Rows.Count; i++)
{
    if (!ValidateMarks(dt.Rows[i]))
    {
        //Please enter valid mark
    }
                   
}

where ValidateMarks Method will look like

C#

private bool ValidateMarks(System.Data.DataRow dRow)
{
    if (dRow["Mark1 "] != null || dRow["Mark1 "] != DBNull.Value || dRow["Mark1 "].ToString().Trim() != "")
    {
        return true;
    }
    return true;
}