need help in dataset

Question

0.00/5 (No votes)

See more:

Hi,

I want a help in following requirment.

I have one dataset. Dataset has many columns and contain values.

In my local variable i have stored one string value.
Now my question is how can i check variable value is there exist in particular column all rows in dataset.

e.g.

i have dataset with two coloumns EMPName and EMPId.
I have one string "TEST" in varible.
now i want to check "TEST" is there in EMPName column

Posted 6-Nov-13 23:20pm

Pro86

Add a Solution

3 solutions

Solution 1

Hello shashikant86,

C#

//Dataset Itself can not contains Rows and coloumns .
//Dataset will contain Datatable in it .
//and in that datatable (dt) we will check the number of rows in datatable
Bool IsExist = false ;
for (int i = 0;i < ds.Tables[0].rows.count;i++)
    {
        if(ds.Tables[0].rows[i].contains("TEST"))
        {
            IsExist = true ;
        }
    }

Posted 7-Nov-13 0:01am

zapbuild

Solution 2

C#

//Sample code
int TotalCount = 0;
int MatchedCount = 0;
DataRow[] drMatched;
drMatched = dataSet1.Tables["Employee"].Select("EmpName Like 'TEST%'");
TotalCount = dataSet1.Tables["Employee"].Rows.Count;
MatchedCount = drMatched.Length;
if(TotalCount != MatchedCount)
{
//if code
}
else
{
//else code
}

Posted 7-Nov-13 0:02am

thatraja

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)

Pro86 · Accepted Answer · 2013-11-08T01:15:00

I have written below code to resolved issue

VB

If ds.Tables.Count > 0 Then
            If ds.Tables(0).Rows.Count > 0 Then
                For Each row As DataRow In ds.Tables(0).Rows

                    If row("EMPName") = "TEST" Then
                    Return
                    Else

                    End If
                Next
            End If
        Else
        End If