Equivalent for RecordCount

[ElenaR]

In VB6, I could count the number of records in a recordset
using recordcount.

Is there an equivalent in VB.NET, to be able to count the
rows in a Data Set?

Thanks in Advance,
Elena

[Cor]

dataset.tables(x).rows.count

"> In VB6, I could count the number of records in a recordset

using recordcount.

Is there an equivalent in VB.NET, to be able to count the
rows in a Data Set?

[William Ryan]

DataSet's can contain multiple tables, so there is not inhernet count
property b/c it wouldn't know which one you wanted a count for.

However, for a DataTable, you can use MyDataSet.Tables("DataTableName Or
Index").Rows.Count

If you are only doing it once, don't worry about using the table name, but
in general use an index to reference it. Or as the ADO.NET guru Bill
Vaughn suggests, you can an enumeration so you get the clarity of a real
name with the performance of an index.
"ElenaR" <el**********@yahoo.com> wrote in message
news:0c****************************@phx.gbl...

In VB6, I could count the number of records in a recordset
using recordcount.

Is there an equivalent in VB.NET, to be able to count the
rows in a Data Set?

Thanks in Advance,
Elena

[ElenaR]

Thanks Cor,

You're always such a help.

Elena

-----Original Message-----
dataset.tables(x).rows.count

"> In VB6, I could count the number of records in a

recordset

using recordcount.

Is there an equivalent in VB.NET, to be able to count the rows in a Data Set?

.

[ElenaR]

With this code (dataset.tables(x).rows.count), I get a
task error:
Property access must assign to the property or use its
value.

I pasted the code below to be a reference.

Elena

strsql = "Select * from Action where item_identifier = " &
Val(TextBox5.Text) & " order by action_identifier"
' Create data adapter object
Dim daID As OleDbDataAdapter = New OleDbDataAdapter
(strsql, CriticalParts.conn)
' Create a dataset object and fill with data using data
adapter's Fill method
Dim dsID As DataSet = New DataSet
daID.Fill(dsID, "Action")

dsID.Tables(1).Rows.Count()

-----Original Message-----
dataset.tables(x).rows.count

"> In VB6, I could count the number of records in a

recordset

using recordcount.

Is there an equivalent in VB.NET, to be able to count the rows in a Data Set?

.

[Cor]

ElenaR,

All Net indexes starts at 0, Microsoft VisualBasic indexes at 1

dsID.Tables(1).Rows.Count

And you have 1 table so

dsID.tables(0).Rows.Count

Cor

[Chris Dunaway]

On Fri, 7 Nov 2003 09:17:29 -0800, ElenaR wrote:

With this code (dataset.tables(x).rows.count), I get a
task error:
Property access must assign to the property or use its
value.
dsID.Tables(1).Rows.Count()

Count is a property and not a method. You need to assign the count to some
variable or something:

lngRecordCount = dsID.Tables(1).Rows.Count

--
Chris

To send me an E-mail, remove the underscores and lunchmeat from my E-Mail
address.

Cor,

With an index of 0, I still get the same error:
Property access must assign to the property or use its
value.

-----Original Message-----
ElenaR,

All Net indexes starts at 0, Microsoft VisualBasic indexes at 1

dsID.Tables(1).Rows.Count

And you have 1 table so

dsID.tables(0).Rows.Count

Cor
.

[Cor]

And of course what Chris said, this would be the next error.
:-))

All Net indexes starts at 0, Microsoft VisualBasic indexes at 1

dsID.Tables(1).Rows.Count

And you have 1 table so
dsID.tables(0).Rows.Count

[Cor]

Hi Elenora

dim a as integer = dsID.Tables(0).Rows.Count

I am in a hurry have to go to a funeral in some minutes.
(Not nearby persons)

Cor

[ElenaR]

perfect!

Elena

-----Original Message-----
On Fri, 7 Nov 2003 09:17:29 -0800, ElenaR wrote:

With this code (dataset.tables(x).rows.count), I get a
task error:
Property access must assign to the property or use its
value.
dsID.Tables(1).Rows.Count()

Count is a property and not a method. You need to assign

the count to somevariable or something:

lngRecordCount = dsID.Tables(1).Rows.Count

--
Chris

To send me an E-mail, remove the underscores and lunchmeat from my E-Mailaddress.
.