Member Avatar for ja0

Hi,

I want to know how to get the total of rows (of myRead) after I executed:

myRead = myCommnd.ExecuteReader();

The only way I get it is using a loop, but exist a command for that?

Thanks!

  • 4 Contributors
  • 6 Replies
  • 128 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by ja0
Member Avatar for rohand

Why are you not uisng the Count() function in your SQL statement ? or execute the query in Adapter and then fill the Datatable and you will goood to go...

Hi,

I want to know how to get the total of rows (of myRead) after I executed:

myRead = myCommnd.ExecuteReader();

The only way I get it is using a loop, but exist a command for that?

Thanks!

Member Avatar for ja0

Why are you not uisng the Count() function in your SQL statement ? or execute the query in Adapter and then fill the Datatable and you will goood to go...

I am copying more than 1M of rows. In other tutorial I read that Count() probably will not be fast enough...

Can you explain to me a little bit more about execute the query in Adapter?

Member Avatar for ja0

BTW I forget to say that I am using now BulkCopy and SqlDataAdapter so I can use the NotifyAfter...but I want to know how to get the total of rows to show the percent of progress copying.

Thanks!

Member Avatar for edepperson

You can't. The SqlDataReader is read forward only. The RecordsAffected property is only accurate after calling Close. If you must have a count, then use the Count function as Rohand said. If the query is using indexed fields in the where clause for the count, it will be fast enough.

Member Avatar for nick.crane

Can you please clarify.
You want to get the count of rows for a query, before doing the query, so you can accurately report the query progress?

Member Avatar for ja0

Can you please clarify.
You want to get the count of rows for a query, before doing the query, so you can accurately report the query progress?

Before storing the data to a another table, so as you said to report the query saving progress.
But I already know how to do this. I just want a method to know the total of rows without using a loop.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.