how to use datareader with sqldatasource defined in aspx file?

[Casper]

Hi,

i know how to use datareader in code-behind, e.g. like this:

Dim oConnection As OleDbConnection
Dim comd As OleDbCommand
Dim dtreader As OleDbDataReader

oConnection = New OleDbConnection ()
oConnection.Con nectionString = Application("co nnect")
oConnection.Ope n()

sql = "SELECT * from table"
comd = New OleDbCommand(sq l, oConnection)
dtreader = comd.ExecuteRea der
...

This works perfect, but how to use dtreader when the datasource is defined
in the aspx file like this?
<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:cat %>"
SelectCommand=" SELECT * table"></asp:SqlDataSour ce>

I tried this in code-behind:
Dim dtreader As OleDbDataReader
dtreader=sqldat asource1.??? 'there is no ExecuteReader available in
the list
Thanks for helping.
Casper

[Eliyahu Goldin]

You can set the DataSourceMode attribute to DataReader and the sqldatasource
will be using a datareader automatically. Is that what you are after?
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Casper" <s@sdwrote in message
news:eA******** ******@TK2MSFTN GP06.phx.gbl...

Hi,

i know how to use datareader in code-behind, e.g. like this:

Dim oConnection As OleDbConnection
Dim comd As OleDbCommand
Dim dtreader As OleDbDataReader

oConnection = New OleDbConnection ()
oConnection.Con nectionString = Application("co nnect")
oConnection.Ope n()

sql = "SELECT * from table"
comd = New OleDbCommand(sq l, oConnection)
dtreader = comd.ExecuteRea der
...

This works perfect, but how to use dtreader when the datasource is defined
in the aspx file like this?
<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:cat %>"
SelectCommand=" SELECT * table"></asp:SqlDataSour ce>

I tried this in code-behind:
Dim dtreader As OleDbDataReader
dtreader=sqldat asource1.??? 'there is no ExecuteReader available in
the list
Thanks for helping.
Casper

[Casper]

Thanks for replying.
I did it in tthe aspx file but how can i link the sqlsource2 defined in the
aspx file to the data reader defined in the code-behind? I don't want to
redefine all the sql statement and parameter in the code-behind. That's my
problem.


"Eliyahu Goldin" <RE************ **************@ mMvVpPsS.orgsch reef in
bericht news:uC******** ******@TK2MSFTN GP03.phx.gbl...

You can set the DataSourceMode attribute to DataReader and the
sqldatasource will be using a datareader automatically. Is that what you
are after?
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Casper" <s@sdwrote in message
news:eA******** ******@TK2MSFTN GP06.phx.gbl...

>Hi,

i know how to use datareader in code-behind, e.g. like this:

Dim oConnection As OleDbConnection
Dim comd As OleDbCommand
Dim dtreader As OleDbDataReader

oConnection = New OleDbConnection ()
oConnection.Con nectionString = Application("co nnect")
oConnection.Ope n()

sql = "SELECT * from table"
comd = New OleDbCommand(sq l, oConnection)
dtreader = comd.ExecuteRea der
...

This works perfect, but how to use dtreader when the datasource is
defined in the aspx file like this?
<asp:SqlDataSo urce ID="SqlDataSour ce1" runat="server"
ConnectionStri ng="<%$ ConnectionStrin gs:cat %>"
SelectCommand=" SELECT * table"></asp:SqlDataSour ce>

I tried this in code-behind:
Dim dtreader As OleDbDataReader
dtreader=sqlda tasource1.??? 'there is no ExecuteReader available
in the list
Thanks for helping.
Casper

[Eliyahu Goldin]

If you already have the datareader, there is no reason to use sqldatasource.
Instead of databinding with DataSourceID, do with DataSource="<%# myReader
%>" in the markup or myControl.DataS ource=myReader; codebhind.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Casper" <s@sdwrote in message
news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

Thanks for replying.
I did it in tthe aspx file but how can i link the sqlsource2 defined in
the aspx file to the data reader defined in the code-behind? I don't want
to redefine all the sql statement and parameter in the code-behind. That's
my problem.


"Eliyahu Goldin" <RE************ **************@ mMvVpPsS.orgsch reef in
bericht news:uC******** ******@TK2MSFTN GP03.phx.gbl...

>You can set the DataSourceMode attribute to DataReader and the
sqldatasourc e will be using a datareader automatically. Is that what you
are after?
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Casper" <s@sdwrote in message
news:eA******* *******@TK2MSFT NGP06.phx.gbl.. .

>>Hi,

i know how to use datareader in code-behind, e.g. like this:

Dim oConnection As OleDbConnection
Dim comd As OleDbCommand
Dim dtreader As OleDbDataReader

oConnection = New OleDbConnection ()
oConnection.Con nectionString = Application("co nnect")
oConnection.Ope n()

sql = "SELECT * from table"
comd = New OleDbCommand(sq l, oConnection)
dtreader = comd.ExecuteRea der
...

This works perfect, but how to use dtreader when the datasource is
defined in the aspx file like this?
<asp:SqlDataS ource ID="SqlDataSour ce1" runat="server"
ConnectionStr ing="<%$ ConnectionStrin gs:cat %>"
SelectCommand=" SELECT * table"></asp:SqlDataSour ce>

I tried this in code-behind:
Dim dtreader As OleDbDataReader
dtreader=sqld atasource1.??? 'there is no ExecuteReader available
in the list
Thanks for helping.
Casper

[Casper]

Thanks

"Eliyahu Goldin" <RE************ **************@ mMvVpPsS.orgsch reef in
bericht news:eW******** ********@TK2MSF TNGP03.phx.gbl. ..

If you already have the datareader, there is no reason to use
sqldatasource. Instead of databinding with DataSourceID, do with
DataSource="<%# myReader %>" in the markup or
myControl.DataS ource=myReader; codebhind.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Casper" <s@sdwrote in message
news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

>Thanks for replying.
I did it in tthe aspx file but how can i link the sqlsource2 defined in
the aspx file to the data reader defined in the code-behind? I don't want
to redefine all the sql statement and parameter in the code-behind.
That's my problem.


"Eliyahu Goldin" <RE************ **************@ mMvVpPsS.orgsch reef in
bericht news:uC******** ******@TK2MSFTN GP03.phx.gbl...

>>You can set the DataSourceMode attribute to DataReader and the
sqldatasour ce will be using a datareader automatically. Is that what you
are after?
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Casper" <s@sdwrote in message
news:eA****** ********@TK2MSF TNGP06.phx.gbl. ..
Hi,

i know how to use datareader in code-behind, e.g. like this:

Dim oConnection As OleDbConnection
Dim comd As OleDbCommand
Dim dtreader As OleDbDataReader

oConnection = New OleDbConnection ()
oConnection.Con nectionString = Application("co nnect")
oConnection.Ope n()

sql = "SELECT * from table"
comd = New OleDbCommand(sq l, oConnection)
dtreader = comd.ExecuteRea der
...

This works perfect, but how to use dtreader when the datasource is
defined in the aspx file like this?
<asp:SqlData Source ID="SqlDataSour ce1" runat="server"
ConnectionSt ring="<%$ ConnectionStrin gs:cat %>"
SelectCommand=" SELECT * table"></asp:SqlDataSour ce>

I tried this in code-behind:
Dim dtreader As OleDbDataReader
dtreader=sql datasource1.??? 'there is no ExecuteReader available
in the list
Thanks for helping.
Casper