Get RecordCount or HasRows from SQLDataAdapter?

[Jack Black]

Hi, all! What is the method for either testing for rows in a
recordset or returning the number of rows in a recordset from a
populated Adapter or from a DataSet? I know you can use HasRows with
a Reader, but I can't use a Reader in this particular instance...

Thanks!
Jack

[Ken Tucker [MVP]]

Hi,

Dataset.tables(0).rows.count

Ken
-------------
"Jack Black" <ja********@hotmail.com> wrote in message
news:vm********************************@4ax.com...
Hi, all! What is the method for either testing for rows in a
recordset or returning the number of rows in a recordset from a
populated Adapter or from a DataSet? I know you can use HasRows with
a Reader, but I can't use a Reader in this particular instance...

Thanks!
Jack

[Jack Black]

Ken, thanks for the reply!

I came across a reference to <DataGrid>.Items.Count before you
replied, so I gave that a whirl and it worked (the dataset is
populating a DataGrid in this chunk of code). I'd imagine it's best
to eliminate that extra grid-population overhead... Yes, No?

Jack

On Wed, 22 Sep 2004 16:56:41 -0400, "Ken Tucker [MVP]"
<vb***@bellsouth.net> wrote:

Hi,

Dataset.tables(0).rows.count

Ken
-------------
"Jack Black" <ja********@hotmail.com> wrote in message
news:vm********************************@4ax.com.. .
Hi, all! What is the method for either testing for rows in a
recordset or returning the number of rows in a recordset from a
populated Adapter or from a DataSet? I know you can use HasRows with
a Reader, but I can't use a Reader in this particular instance...

Thanks!
Jack