Author: dwfreeman | Posted on: 1/9/2009 11:17:25 AM | Views : 296

I may be working in the wrong direction here. If so please advise accordingly. Suppose we want to display and manage data without using one of the databound controls (formview,dataview, etc). I am guessing we would ceate a datareader and somehow set a controls's value property to a field in the datareader. Something like this:

 <%
If GridView1.SelectedValue > 0 Then
Dim oConn As New Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("ASPNETDBConnectionString").ConnectionString)
Dim SQL As String = "SELECT * FROM TRPSites WHERE KeyID = @KeyID"
Using oConn
Dim command As New Data.SqlClient.SqlCommand(SQL)
command.Parameters.AddWithValue("@Key ...

Go to the complete details ...