Solved

empty dataset

Posted on 2008-10-27
5
609 Views
Last Modified: 2013-12-17
I have a dataset which I am testing if it is null, my code is

if (userDataSet.Tables.Count == 0)
{
response.write ("Dataset is empty")
}

When nothing happened I decided to test if my IF condition was working, so I wrote

Response.Write(users.Tables.Count);

The code returned 1.

This is not correct since I know there are no rows in my table. Is the table heading counted as the first row in Tables.Count.

If this is so, should I write

if (userDataSet.Tables.Count == 1)
{
response.write ("Dataset is empty")
}

0
Comment
Question by:Mr_Shaw
  • 2
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
rpkhare earned 500 total points
ID: 22811419
There can be a DataTable without rows in a DataSet.

Check this:
http://msdn.microsoft.com/en-us/library/system.data.datatablecollection.collectionchanged.aspx

Note that:
DataSet.Tables.Count returns number of tables in dataset.
Whereas, DataSet.Tables[0].Rows.Count returns number of rows in the first table.
0
 
LVL 16

Expert Comment

by:Gyanendra Singh
ID: 22811451
try
0
 
LVL 16

Expert Comment

by:Gyanendra Singh
ID: 22811455
try this

userDataSet.Tables[0].Rows.count ==0
response.write ("Dataset is empty")
0
 
LVL 8

Expert Comment

by:rpkhare
ID: 22811509
BondinASP,

But this does not mean that DataSet is empty. There might be a table with no rows.
0
 

Author Closing Comment

by:Mr_Shaw
ID: 31510247
thanks
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question