How to write "for-loop" to check condition in C#.net

Question

1.00/5 (1 vote)

See more:

I have some data in data set.I want to check the data with a specific condition,if the condition is true then a text box should be visible otherwise text box should n't be visible.In dataset I have 20 records.

the condition is like:

C#

if ((dataset.Tables[0].Rows[i][0].ToString())=="FirstName"&&(dataset.Tables[0].Rows[i][3].ToString())=="block")
                     
{
     divFirstName.Visible = true;
     txtFName.Text = objUser.FirstName;
}

Note:
Here "firstname" and "block" are the values in columns.
if a particular row meets the condition,then we have to show text box.
we need to search that values in data set rows collection.

How to write for loop for this requirement?

Thanks in Advance

Posted 8-Sep-15 4:30am

Member 10714689

Updated 8-Sep-15 4:40am

Leo Chapiro

v3

Add a Solution

Comments

PIEBALDconsult 8-Sep-15 10:39am

Please first look at the DefaultView property of the DataTable; it has a RowFilter property that will likely do what you want.
Something like: dataset.Tables[0].DefaultView.RowFilter = "column0='FirstName' AND column3='block'"
Then dataset.Tables[0].DefaultView will "contain" only those rows, with no additional coding by you.
See also: http://www.codeproject.com/Tips/850878/On-Why-to-Use-DataViews

Richard MacCutchan 8-Sep-15 10:51am

That's a +5 solution.

ZurdoDev 8-Sep-15 11:04am

Look at what PIEBALDconsult said and do that. However, your code is already written for a loop so if you don't realize that my guess is you copied the code somewhere and don't understand what it does. Asking us to turn it into a loop for you will not do you any good because you need to understand how code works.

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)

VR Karthikeyan · Answer 1 · 2015-09-08T06:39:00

Solution 1

You can use foreach loop here as follows,

C#

foreach(DataRow objRow in dataset.Tables[0].Rows)
{
   if(objRow[0].ToString().Trim() == "FirstName" &&
      objRow[3].ToString().Trim() == "block")
   {
      divFirstName.Visible = true;
      txtFName.Text = objUser.FirstName;
   }
}

Posted 8-Sep-15 6:39am

VR Karthikeyan

Comments

PIEBALDconsult 8-Sep-15 14:08pm

Don't use foreach when for will work.
Don't call ToString on string fields -- just cast. And in this case you don't even need to do that.

VR Karthikeyan 8-Sep-15 23:25pm

@PIEBALDconsult, Thank you for your information. May I know the reasons for above, it will helps me to understand C# better. Thanks again

PIEBALDconsult 9-Sep-15 0:32am

http://www.codeproject.com/Tips/850878/On-Why-to-Use-DataViews