anup2006

 Profile Answers by anup2006 

• Feb 3rd, 2006

 

if Dataset.HasRows=true then

dataset contains data otherwise empty

Gavin

• Feb 16th, 2006

 

What you mean is...

if(Dataset.HasRows)

{

//do whatever

}

Nandagopal

• Feb 25th, 2006

 

Hi

HasRows property is only for DataReader objects.  For DataSet you can check whether it has a DataTable or not .. since the DataSet is a collection of DataTable you can check whether it has loaded a table or not using the following code

DataSet dt=new DataSet();

if (dt.Tables.Count>0) // has tables in it

{

}

else // otherwise it is empty

{

}

vishalsharma

 Profile Answers by vishalsharma Questions by vishalsharma

• Mar 2nd, 2006

 

first two are wrong there is nothing a property like DataSet.HasRows in dataset

third one is right answer to say

Guest

• Mar 2nd, 2006

 

first two are wrong there is nothing a property like DataSet.HasRows in dataset

third one is right answer to say

inxs

• Apr 3rd, 2006

 

All above answers are wrong.

Use,

DataSet_objectName.Tables[0].Rows.Count > 0

prakhar

• Apr 6th, 2006

 

the above ans is wrong as dataset is empty , it will throw error while acessing the first table . so the third is correct answere.

Omar

• Apr 17th, 2006

 

Hi

Checking the dataset like:

if(DataSetObj.Tables[0].Rows.Count> 0)

is right only if you use another "if" statement above it, which is:

if(DataSetObj.Tables.Count > 0)

Regards

Ujjwal Prakash

• Apr 21st, 2006

 

Absolutly Right..

To check that if a dataset has data or not we will have to first check if it has any table or not and then we ll have to look into the tables to check the row count.

eg:

if (ds.Tables.Count==0)

{

Console.Write("Empty Dataset");

}

else

{

 oreach(DataTable dt in ds)

{}

Srinivas

• Apr 25th, 2006

 

I think we have an method like IsNothing.Using that we can find That dataset has some data or notike :-- DataSet ds = new DataSet() if not IsNothing(ds) { TRUE block;}

Dhejo

• May 16th, 2006

 

None of the answer seems completly correct. First check if(dataset== null)

then check of dataset.Tables == null if these checks are not made exception will occur when u check dataset.Tables.count or dataset.Tables[0].Rows.Count

omi

• May 24th, 2006

 

hi,

Forget all answers this is check and true

DataSet ds=new DataSet();

if(ds.Tables.Count ==0)

{

MessageBox.Show("There are "+ds.Tables.Count.ToString()+"Tables");

}

sqlDataAdapter1.Fill(ds,"hello");

if(ds.Tables.Count>0)

{

MessageBox.Show("There are "+ds.Tables.Count.ToString()+"Tables");

}

Shipra

• Jun 6th, 2006

 

u can directly comapre dataset to null  or counting the tables like in below case...

if(dsExample==null || dsExample.Tables.Count==0){ //empty dataset}

else{//not empty}

John Jiang

 Profile Answers by John Jiang 

• Jul 2nd, 2008

 

IsNothing is only used in VB or VB.NET. someone is really confused

Sanjida123

 Profile Answers by Sanjida123 

• Jun 3rd, 2010

 

Check if (dataset != null), and then work on dataset.

Seeker911

 Profile Answers by Seeker911 

• Jun 14th, 2011

 

Here it is folks:

1. You need to firstly check to see if the dataset actually exists
2. Then check if it has one or more tables
3. Then check the row count for each table to see if any one table has data

Example.

            System.Data.DataSet data = new System.Data.DataSet();

            //data = bla bla get some data;

            bool dataFound = false;

            if( data != null && data.Tables.Count > 0 && data.Tables[ 0 ].Rows.Count > 0 )
            {
                foreach( System.Data.DataTable table in data.Tables )
                {
                    if( table.Rows.Count > 0 )
                    {
                        //we have data
                        dataFound = true;
                        break;
                    }
                }
            }

            if( dataFound )
            {
                Console.WriteLine( "we have data" );
            }
            else
            {
                Console.WriteLine( "we have NO data" );
            }

Anais

• May 31st, 2012

 

Thank you Seeker911, your answer helped me :)

Rajavel

• Nov 19th, 2012

 

Code
if(dataset.Tables.count!=0)


{


do some operation


}


else


{


nothing...


}

Bucked Naked

• Sep 11th, 2013

 

Wrong. Try this for better results:

Code
DataSet ds = <get a dataset somehow>;


if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows > 0)


{


    // There is something in the DataSet.


}

Chandrashekhar

• Nov 16th, 2013

 

DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(sqlString, sqlConn);
da.Fill(ds);

It is work i sure

Deepak

• Mar 11th, 2015

 

Check if dataset object is instanciated
Check uf it contains tables
Question is not to check whether it has records or not Question is if it is empty
Checking the row in first table does not help as there can exists more then one table