«

I will have both web and win clients and would like to page my data. I
could not find out how the datagrid control does it's paging.

What library/methods can I use in .Net 2.0 to do paging of SQL data in a web
service?

Thanks in advance,
Donald Adams

Hi

did you think using the "RowNum" of the Sql2005 ?
this way you can send to the WebService
which would call the SP with from RowNum and To RowNum
and you'de get the relevant rows
from example from row 50 to 59

--
-------------------------------------
If my answer helped you please press "Yes" bellow

×�×� תשובה זו עזרה לך, ×�×*×� הצבע "כן"

Adlai Maschiach
http://blogs.microsoft.co.il/blogs/adlaim/


"Donald Adams" wrote:

> I will have both web and win clients and would like to page my data. I
> could not find out how the datagrid control does it's paging.
>
> What library/methods can I use in .Net 2.0 to do paging of SQL data in a web
> service?
>
> Thanks in advance,
> Donald Adams
>

Hi,

Thanks, I can use that, but I'm actually wanting to know how does dataGrid
use my SqlDataObject, or ObjectSource and add paging and sorting to it....
so I can do the same in my webservice.
A code sample would be most helpful.

,,,Donald Adams

"Adlai Maschiach" <> wrote in
message news:38680CA2-D33C-4340-8959-...
> Hi
>
> did you think using the "RowNum" of the Sql2005 ?
> this way you can send to the WebService
> which would call the SP with from RowNum and To RowNum
> and you'de get the relevant rows
> from example from row 50 to 59
>
> --
> -------------------------------------
> If my answer helped you please press "Yes" bellow
>
> ×�×� תשובה זו עזרה לך, ×�×*×� הצבע "כן"
>
> Adlai Maschiach
> http://blogs.microsoft.co.il/blogs/adlaim/
>
>
> "Donald Adams" wrote:
>
>> I will have both web and win clients and would like to page my data. I
>> could not find out how the datagrid control does it's paging.
>>
>> What library/methods can I use in .Net 2.0 to do paging of SQL data in a
>> web
>> service?
>>
>> Thanks in advance,
>> Donald Adams
>>

They do it by using PagedDataSource class.

--
Teemu Keiski
AspInsider, ASP.NET MVP
http://blogs.aspadvice.com/joteke
http://teemukeiski.net



"Donald Adams" <> wrote in message
news:C1636943-61E2-463F-B2F7-...
> Hi,
>
> Thanks, I can use that, but I'm actually wanting to know how does dataGrid
> use my SqlDataObject, or ObjectSource and add paging and sorting to it....
> so I can do the same in my webservice.
> A code sample would be most helpful.
>
> ,,,Donald Adams
>
> "Adlai Maschiach" <> wrote in
> message news:38680CA2-D33C-4340-8959-...
>> Hi
>>
>> did you think using the "RowNum" of the Sql2005 ?
>> this way you can send to the WebService
>> which would call the SP with from RowNum and To RowNum
>> and you'de get the relevant rows
>> from example from row 50 to 59
>>
>> --
>> -------------------------------------
>> If my answer helped you please press "Yes" bellow
>>
>> ×�×� תשובה זו עזרה לך, ×�×*×� הצבע "כן"
>>
>> Adlai Maschiach
>> http://blogs.microsoft.co.il/blogs/adlaim/
>>
>>
>> "Donald Adams" wrote:
>>
>>> I will have both web and win clients and would like to page my data. I
>>> could not find out how the datagrid control does it's paging.
>>>
>>> What library/methods can I use in .Net 2.0 to do paging of SQL data in a
>>> web
>>> service?
>>>
>>> Thanks in advance,
>>> Donald Adams
>>>