View Single Post
  #1 (permalink)  
Old December 22nd, 2004, 10:57 AM
datagram datagram is offline
Authorized User
 
Join Date: Dec 2004
Location: New Smyrna Beach, Florida, USA.
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to datagram Send a message via AIM to datagram
Default How to get "SELECT COUNT(*)" return information?

Here is a part of my code...

Me.SqlCommand1.Connection = Me.SqlConnection1
SqlConnection1.Open()
Me.SqlCommand1.CommandText = "SELECT COUNT(*) AS in_process FROM tbl_current_call_list WHERE repname ='" & repname & "' AND in_process='yes'"

What do I use to see just the number of rows its returning? A reader or dataset or something? I just want to be able to see the number of rows, not any of the information.
Thank you