Helper function in page_load sub; resultset from SqL

[276q]

I'm kind of new to asp.net from classic asp, I need to get records/
fields from a resultset to display on aspx page (no datalist,
repeater, or datagrid):
<script runat="server">

Sub Page_Load(Sender As Object, E As EventArgs)
dim strConnection as SQLConnection
dim objCommand as SQLCommand
Dim objDataReader As SQLDataReader
strConnection = New SqlConnection("Data Source=myserver.net;Initial
Catalog=thedb;User Id=me;Password=you;")
objCommand = New SqlCommand( "select cbid,name,category from
cardbanners where grouping = '468A'", strConnection)
strConnection.Open()
objDataReader = objCommand.ExecuteReader()
''what data object do i store the resulset from objCommand?
DataSource = objDataReader
DataBind()


objDataReader.Close
strConnection.Close
End Sub

</script>
''''''''''
I want to take, for examplfe, a field 'dbo.caredbanners.category' from
my resultset and put it into a function (based on an user entered name
via request.querystring, or a condition on date object) that i can
simply call <%# mycategoryfunc%> on my aspx
Thanks in advance, Ed

 

[Masudur]

I'm kind of new to asp.net from classic asp, I need to get records/
fields from a resultset to display on aspx page (no datalist,
repeater, or datagrid):
<script runat="server">

Sub Page_Load(Sender As Object, E As EventArgs)
dim strConnection as SQLConnection
dim objCommand as SQLCommand
Dim objDataReader As SQLDataReader
strConnection = New SqlConnection("Data Source=myserver.net;Initial
Catalog=thedb;User Id=me;Password=you;")
objCommand = New SqlCommand( "select cbid,name,category from
cardbanners where grouping = '468A'", strConnection)
strConnection.Open()
objDataReader = objCommand.ExecuteReader()
''what data object do i store the resulset from objCommand?
DataSource = objDataReader
DataBind()

objDataReader.Close
strConnection.Close
End Sub

</script>
''''''''''
I want to take, for examplfe, a field 'dbo.caredbanners.category' from
my resultset and put it into a function (based on an user entered name
via request.querystring, or a condition on date object) that i can
simply call <%# mycategoryfunc%> on my aspx
Thanks in advance, Ed

Hi,

here is a step by step procedure...

http://www.aspfree.com/c/a/Database/ADO-NET-101-SqlDataReader-2/2/

Thanks
Masudur
http://munnacs.110mb.com