How to validate column in between given position?

Question

0.00/5 (No votes)

See more:

i have 45 rows and 45 columns in data table.
* validate third column,(12 Th row to 39 row)in this in between field have at least one value(my requirement is the value is '1')
* if 3rd column 19 row value is '1' then other fields or empty.that's not a problem.
* if no row have any value then only through the error
How to do it.

What I have tried:

i have used looping for rows and column given below.

C#

for(int j= 3; j<= columncountvalue; j++)
	{
for (int i = 12; i <= rowcountvalue; i++)
            {
                if (ds.Tables[s].Columns[3][i].ToString().Trim() == "") 
                {

			// statements
		        }
            }
    }

C#

now i want which condition used for that requirements.

Posted 3-Oct-16 2:13am

Raja Ganapathy

Updated 3-Oct-16 2:27am

v3

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)

#realJSOP · Accepted Answer · 2016-10-03T02:23:00

0) You're using the same variable in both for loops. That is NOT going to give you the expected result.

1) You're hard coding the column number in your if statement instead of using the iterator.

Is this what you meant to do?

C#

for(int j = 3; j <= columncountvalue; j++)
{
    for (int i = 12; i <= rowcountvalue; i++)
    {
        if (string.IsNullOrEmpty(ds.Tables[s].Columns[j][i].ToString().Trim() )) 
        {
            // statements
        }
    }
}

And by the way, if you run into a null value in your table, the code will throw an exception because you tried to call ToString() on a null reference.

Further, if you didn't subtract 1 from columncountvalue and rowcountvalue, you'll probably get an out-of range exception when it hits the end of the rows and or columns.

Finally, I would probably iterate rows before columns, but that's more a matter of style I suppose.