How to count no of record ?

[Agnes]

In my store procedure , i will select * from myTable, and I will while-loop
the result by using datareader in vb.net .
Now, Can I know the number of records before I while-loop the resut ??

[Imran Koradia]

AFAIK, you won't know the number of records. You can change the query to
say:

Select *, Count(*) from myTable which will also give you the count.

hope that helps..
Imran.

"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:u1**************@TK2MSFTNGP09.phx.gbl...

In my store procedure , i will select * from myTable, and I will
while-loop
the result by using datareader in vb.net .
Now, Can I know the number of records before I while-loop the resut ??

[CT]

Not unless you have the row count returned as a different result set, making
the stored procedure return two results; the row count and the actual rows.

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:u1**************@TK2MSFTNGP09.phx.gbl...

In my store procedure , i will select * from myTable, and I will
while-loop
the result by using datareader in vb.net .
Now, Can I know the number of records before I while-loop the resut ??

[Agnes]

Could you give me a little sample , how to return two result ???
Thanks a lot
"CT" <ca******@spammersgoawaydotnetservices.biz> ¦b¶l¥ó
news:eX**************@TK2MSFTNGP14.phx.gbl ¤¤¼¶¼g...

Not unless you have the row count returned as a different result set, making the stored procedure return two results; the row count and the actual rows.
--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:u1**************@TK2MSFTNGP09.phx.gbl...

In my store procedure , i will select * from myTable, and I will
while-loop
the result by using datareader in vb.net .
Now, Can I know the number of records before I while-loop the resut ??

[CT]

Sure, do something like this:

SELECT COUNT(*) FROM TableName;
SELECT * FROM TableName

Once results have been returned to the client, read the scalar value in the
first resultset, and move the "real" data in the second resultset using the
NextResult method of the datareader.

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:Oe**************@TK2MSFTNGP14.phx.gbl...

Could you give me a little sample , how to return two result ???
Thanks a lot
"CT" <ca******@spammersgoawaydotnetservices.biz> ¦b¶l¥ó
news:eX**************@TK2MSFTNGP14.phx.gbl ¤¤¼¶¼g...

Not unless you have the row count returned as a different result set,

making

the stored procedure return two results; the row count and the actual

rows.

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:u1**************@TK2MSFTNGP09.phx.gbl...

> In my store procedure , i will select * from myTable, and I will
> while-loop
> the result by using datareader in vb.net .
> Now, Can I know the number of records before I while-loop the resut ??
>
>
>

[Imran Koradia]

why not put the * and count(*) in the same sql so you don't hit the server
twice?

select *, Count(*) from myTable

"CT" <ca******@spammersgoawaydotnetservices.biz> wrote in message
news:Oz**************@TK2MSFTNGP09.phx.gbl...

Sure, do something like this:

SELECT COUNT(*) FROM TableName;
SELECT * FROM TableName

Once results have been returned to the client, read the scalar value in
the first resultset, and move the "real" data in the second resultset
using the NextResult method of the datareader.

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:Oe**************@TK2MSFTNGP14.phx.gbl...

Could you give me a little sample , how to return two result ???
Thanks a lot
"CT" <ca******@spammersgoawaydotnetservices.biz> ¦b¶l¥ó
news:eX**************@TK2MSFTNGP14.phx.gbl ¤¤¼¶¼g...

Not unless you have the row count returned as a different result set,

making

the stored procedure return two results; the row count and the actual

rows.

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:u1**************@TK2MSFTNGP09.phx.gbl...
> In my store procedure , i will select * from myTable, and I will
> while-loop
> the result by using datareader in vb.net .
> Now, Can I know the number of records before I while-loop the resut ??
>
>
>

[Imran Koradia]

disregard my previous msg - I wasn't thinking :(

"CT" <ca******@spammersgoawaydotnetservices.biz> wrote in message
news:Oz**************@TK2MSFTNGP09.phx.gbl...

Sure, do something like this:

SELECT COUNT(*) FROM TableName;
SELECT * FROM TableName

Once results have been returned to the client, read the scalar value in the first resultset, and move the "real" data in the second resultset using the NextResult method of the datareader.

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:Oe**************@TK2MSFTNGP14.phx.gbl...

Could you give me a little sample , how to return two result ???
Thanks a lot
"CT" <ca******@spammersgoawaydotnetservices.biz> ¦b¶l¥ó
news:eX**************@TK2MSFTNGP14.phx.gbl ¤¤¼¶¼g...

Not unless you have the row count returned as a different result set,

making

the stored procedure return two results; the row count and the actual

rows.

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:u1**************@TK2MSFTNGP09.phx.gbl...
> In my store procedure , i will select * from myTable, and I will
> while-loop
> the result by using datareader in vb.net .
> Now, Can I know the number of records before I while-loop the resut ?? >
>
>

[CT]

Heck, it's Friday, right? ;-)

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Imran Koradia" <no****@microsoft.com> wrote in message
news:uE**************@TK2MSFTNGP11.phx.gbl...

disregard my previous msg - I wasn't thinking :(

"CT" <ca******@spammersgoawaydotnetservices.biz> wrote in message
news:Oz**************@TK2MSFTNGP09.phx.gbl...

Sure, do something like this:

SELECT COUNT(*) FROM TableName;
SELECT * FROM TableName

Once results have been returned to the client, read the scalar value in

the

first resultset, and move the "real" data in the second resultset using

the

NextResult method of the datareader.

--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:Oe**************@TK2MSFTNGP14.phx.gbl...

> Could you give me a little sample , how to return two result ???
> Thanks a lot
>
>
> "CT" <ca******@spammersgoawaydotnetservices.biz> ¦b¶l¥ó
> news:eX**************@TK2MSFTNGP14.phx.gbl ¤¤¼¶¼g...
>> Not unless you have the row count returned as a different result set,
> making
>> the stored procedure return two results; the row count and the actual
> rows.
>>
>> --
>> Carsten Thomsen
>> Enterprise Development with VS .NET, UML, and MSF
>> http://www.apress.com/book/bookDisplay.html?bID=105
>> "Agnes" <ag***@dynamictech.com.hk> wrote in message
>> news:u1**************@TK2MSFTNGP09.phx.gbl...
>> > In my store procedure , i will select * from myTable, and I will
>> > while-loop
>> > the result by using datareader in vb.net .
>> > Now, Can I know the number of records before I while-loop the resut ?? >> >
>> >
>> >
>>
>>
>
>