Remove From My Forums

How to use a DataReader with SQLDataSource?

Question
0

Sign in to vote

User-1087288840 posted
Hello. I have put a SQLDataSource on my page and everything is adjusted and it works properly. I read an article here which was indicating that you can use a DataReader in order to get data from sqldatasource, but it doesn't say how, the only thing that is said is to use DataSourceMode property in order to adjust it for a DataReader. Can you tell me "how" please? A bunch of codes would be enough, though. Thank U

Tuesday, March 29, 2011 6:58 PM

Answers

0

Sign in to vote
User77042963 posted

You need to set DataSourceMode="DataReader" first and in your code you will do something like this:

Dim reader As System.Data.SqlClient.SqlDataReader = DirectCast(SqlDataSource1.[Select](DataSourceSelectArguments.Empty), System.Data.SqlClient.SqlDataReader)

You can see a sample code I posted early:

http://jingyangli.wordpress.com/2008/07/24/dynamically-textbox-and-save-data-to-database-with-a-sqldatasource/
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, March 29, 2011 9:16 PM