How can I check whether a dataset is empty or not in C#.net

if Dataset.HasRows=true then

dataset contains data otherwise empty

What you mean is...

if(Dataset.HasRows)

{

//do whatever

}

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

{

}

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

third one is right answer to say

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

third one is right answer to say

All above answers are wrong.

Use,

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

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

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

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)

{}

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;}

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

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");

}

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}

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

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

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" );
            }

Thank you Seeker911, your answer helped me :)

Code
if(dataset.Tables.count!=0)
{
do some operation
}
else
{
nothing...
}