How to learn how many records i have in database

[Salih Ataoz]

at vb6
there is recordcount property

ex:
msgbox rst.recordcount
at .net
i dont know how to learn how many records i have in
database is there any property to learn it

[Cor]

Hi Salih,

There is not one methode,
When it is a dataset by instance you can do
ds.tables(0).rows.count

But there are a lot more possibilities.

I hope it give you an idea?

Cor

i dont know how to learn how many records i have in
database is there any property to learn it

[Herfried K. Wagner [MVP]]

* "Salih Ataoz" <an*******@discussions.microsoft.com> scripsit:

there is recordcount property

ex:
msgbox rst.recordcount
at .net
i dont know how to learn how many records i have in
database is there any property to learn it

This depends on how you access the database.

ADO.NET group:

<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microso ft.public.dotnet.framework.adonet>

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>