"Dan" <d@d.d> wrote in message
news:%23jSkSi2SHHA.4188@TK2MSFTNGP06.phx.gbl...
> Hi,
>
> i defined a datalist and a datasource like this:
>
> <asp:DataList ID="DataList1" runat="server">
> .....
> </asp:DataList>
> <asp:SqlDataSource ID="SqlDataSource1" runat="server"
> ConnectionString="<%$ ConnectionStrings:cat %>"
> SelectCommand="select * from dbtable"
> </asp:SqlDataSource>
>
> Now i discovered the property DataSourceMode in the tag <sqldatasource>
> with two options: datareader and dataset.
> My question is: i tried both without seeing any difference. So what's the
> purpose of this, and what is then used by default?
>
> Thanks
> Dan
>

> The modes differ by the controls used for data access. Use datareader mode
> if you need read-only recordser with no paging or sorting. It is much
> lighter than the dataset mode. The default is dataset.
>
> --
> Eliyahu Goldin,
> Software Developer & Consultant
> Microsoft MVP [ASP.NET]
> http://msmvps.com/blogs/egoldin
> http://usableasp.net
>
>
> "Dan" <d@d.d> wrote in message
> news:%23jSkSi2SHHA.4188@TK2MSFTNGP06.phx.gbl...
>> Hi,
>>
>> i defined a datalist and a datasource like this:
>>
>> <asp:DataList ID="DataList1" runat="server">
>> .....
>> </asp:DataList>
>> <asp:SqlDataSource ID="SqlDataSource1" runat="server"
>> ConnectionString="<%$ ConnectionStrings:cat %>"
>> SelectCommand="select * from dbtable"
>> </asp:SqlDataSource>
>>
>> Now i discovered the property DataSourceMode in the tag <sqldatasource>
>> with two options: datareader and dataset.
>> My question is: i tried both without seeing any difference. So what's the
>> purpose of this, and what is then used by default?
>>
>> Thanks
>> Dan
>>
>
>