OleDbCommand / ADO.Net Recordset

[Sarah]

I've used the OldDbCommand to retrieve some data (SELECT query) -- I have
two questions.

1. How do I find out how many records where retrieved WITHOUT looping
through the results and incrementing a counter? Is there a direct way of
some sort?

2. How do I initialize an array and add all my Primary Keys ("ProductID") to
an array while looping through the results?

Thanks.

 

[Bob Johnson]

Sarah...

1st questions (maybe i'm missing something) --- if you're retreiving the
rows into a dataset/datatable, why not just do dataTable.rows.count?

Otherwise, you executeScalar select count(*) from Tablename...

2nd question; look into the OleDbDataReader.GetSchemaTable Method

http://msdn.microsoft.com/library/d...DbOleDbDataReaderClassGetSchemaTableTopic.asp

 

[Terry Burns]

Good answer !

Sarah...

1st questions (maybe i'm missing something) --- if you're retreiving the
rows into a dataset/datatable, why not just do dataTable.rows.count?

Otherwise, you executeScalar select count(*) from Tablename...

2nd question; look into the OleDbDataReader.GetSchemaTable Method

http://msdn.microsoft.com/library/d...DbOleDbDataReaderClassGetSchemaTableTopic.asp


("ProductID")