datareader problem

[Vkas]

how to find out the total number of rows in a database through datareader
any guide

[Curtis Rutland]

Well, what I would do is use another query:

Dim query as string = "select count(*) from table"
Dim cmd as new SqlCommand(query,connection) 'use your existing connection
cmd.Connection.Open
Dim count as Int32
count = cmd.ExecuteScalar()
cmd.Connection.Close()

[Vkas]

thanks!!!!!!
but i have another question in my mind

i had tried it worked!!!!!!!!!!!!!!
but if i use a query

Dim query as string = "select empid from table"

only the 1st column of the table


and i want retrieve all the values of the this column in a listbox

then what should i do???????????/

when i use execute scalar it return me a single value in the list box what about the others

[Curtis Rutland]

Please read these two articles:

http://bytes.com/topic/net/insights/...e-your-program
http://bytes.com/topic/net/insights/...rogram-part-ii

They should get you started.