Wrox Home  
Search P2P Archive for: Go

  Return to Index  

ado_dotnet thread: number rows in dataset rowset


Message #1 by "Alex Smotritsky" <alex.smotritsky@v...> on Fri, 21 Feb 2003 11:58:18
I'm extracting one rowset from my db into a dataset. How do I get the 
number of rows in the rowset? I can't find the property that would provide 
this, I assume iterating thru the whole thing isn't necessary. Thanks.
Message #2 by "Brian Smith" <bsmith@l...> on Fri, 21 Feb 2003 13:04:01 -0000
DataSet.Tables["Table"].Rows.Count

brian

-----Original Message-----
From: Alex Smotritsky [mailto:alex.smotritsky@v...] 
Sent: Fri, 21 Feb 2003 11:58
To: ADO.NET
Subject: [ado_dotnet] number rows in dataset rowset


I'm extracting one rowset from my db into a dataset. How do I get the 
number of rows in the rowset? I can't find the property that would
provide 
this, I assume iterating thru the whole thing isn't necessary. Thanks.
=== Fast Track ADO.NET with C# is a concise introduction to the
concepts, techniques, and libraries that you will need in order to start
using ADO.NET in your applications. The book covers DataSets and Typed
DataSets, accessing data using DataReaders and DataAdaptors, the close
relationship between ADO.NET and XML, how and where to use ADO.NET in
your enterprise applications, and how to use Web Services and ADO.NET to
easily pass data between applications.
http://www.wrox.com/books/1861007604.htm

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
 

Message #3 by "Alex Smotritsky" <alex.smotritsky@v...> on Fri, 21 Feb 2003 08:32:19 -0500
Thanks a lot!

-----Original Message-----
From: Brian Smith [mailto:bsmith@l...] 
Sent: Friday, February 21, 2003 8:04 AM
To: ADO.NET
Subject: [ado_dotnet] RE: number rows in dataset rowset


DataSet.Tables["Table"].Rows.Count

brian

-----Original Message-----
From: Alex Smotritsky [mailto:alex.smotritsky@v...] 
Sent: Fri, 21 Feb 2003 11:58
To: ADO.NET
Subject: [ado_dotnet] number rows in dataset rowset


I'm extracting one rowset from my db into a dataset. How do I get the 
number of rows in the rowset? I can't find the property that would
provide 
this, I assume iterating thru the whole thing isn't necessary. Thanks.
=== Fast Track ADO.NET with C# is a concise introduction to the
concepts, techniques, and libraries that you will need in order to start
using ADO.NET in your applications. The book covers DataSets and Typed
DataSets, accessing data using DataReaders and DataAdaptors, the close
relationship between ADO.NET and XML, how and where to use ADO.NET in
your enterprise applications, and how to use Web Services and ADO.NET to
easily pass data between applications.
http://www.wrox.com/books/1861007604.htm

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
 


===
Fast Track ADO.NET with C# is a concise introduction to the concepts,
techniques, and libraries that you will need in order to start using
ADO.NET in your applications. The book covers DataSets and Typed
DataSets, accessing data using DataReaders and DataAdaptors, the close
relationship between ADO.NET and XML, how and where to use ADO.NET in
your enterprise applications, and how to use Web Services and ADO.NET to
easily pass data between applications.
http://www.wrox.com/books/1861007604.htm

Message #4 by "h@f... on Fri, 21 Feb 2003 10:50:55 -0800 (PST)
hi, Dear
Assume ur dataset name is ds
so code will be
dim table as datatable
dim row as integer
table = ds.tables.item(0) ' assume u have only one table in ur dataset
rows = tabe.rows.count
Hafiz Qasim
Punjab University, Lahore
 Alex Smotritsky <alex.smotritsky@v...> wrote:I'm extracting one rowset from my db into a dataset. How do I get the 
number of rows in the rowset? I can't find the property that would provide 
this, I assume iterating thru the whole thing isn't necessary. Thanks.
===
Fast Track ADO.NET with C# is a concise introduction to the concepts, techniques, and libraries that you will need in order to start
using ADO.NET in your applications. The book covers DataSets and Typed DataSets, accessing data using DataReaders and DataAdaptors,
the close relationship between ADO.NET and XML, how and where to use ADO.NET in your enterprise applications, and how to use Web
Services and ADO.NET to easily pass data between applications.
http://www.wrox.com/books/1861007604.htm


---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more
Message #5 by "Alex Smotritsky" <alex.smotritsky@v...> on Fri, 21 Feb 2003 19:07:16 -0500
Thanks Hafiz.


-----Original Message-----
From: h@f... [mailto:hafizqasim@y...] 
Sent: Friday, February 21, 2003 1:51 PM
To: ADO.NET
Subject: [ado_dotnet] Re: number rows in dataset rowset



hi, Dear
Assume ur dataset name is ds
so code will be
dim table as datatable
dim row as integer
table = ds.tables.item(0) ' assume u have only one table in ur dataset
rows = tabe.rows.count Hafiz Qasim Punjab University, Lahore  Alex
Smotritsky <alex.smotritsky@v...> wrote:I'm extracting one rowset
from my db into a dataset. How do I get the 
number of rows in the rowset? I can't find the property that would
provide 
this, I assume iterating thru the whole thing isn't necessary. Thanks.
=== Fast Track ADO.NET with C# is a concise introduction to the
concepts, techniques, and libraries that you will need in order to start
using ADO.NET in your applications. The book covers DataSets and Typed
DataSets, accessing data using DataReaders and DataAdaptors, the close
relationship between ADO.NET and XML, how and where to use ADO.NET in
your enterprise applications, and how to use Web Services and ADO.NET to
easily pass data between applications.
http://www.wrox.com/books/1861007604.htm


---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more

===
Fast Track ADO.NET with C# is a concise introduction to the concepts,
techniques, and libraries that you will need in order to start using
ADO.NET in your applications. The book covers DataSets and Typed
DataSets, accessing data using DataReaders and DataAdaptors, the close
relationship between ADO.NET and XML, how and where to use ADO.NET in
your enterprise applications, and how to use Web Services and ADO.NET to
easily pass data between applications.
http://www.wrox.com/books/1861007604.htm


  Return to Index