ExecuteReader Error

[sthmpsn1]

What does this message mean?? Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: ExecuteReader: Connection property has not been initialized.

here is my code

<%@ Page Language=&quot;VB&quot; Debug=&quot;true&quot; ContentType=&quot;text/html&quot; ResponseEncoding=&quot;iso-8859-1&quot; %>
<%@ import Namespace=&quot;System.Data.sqlClient&quot; %>
<%@ import Namespace=&quot;System.Data&quot; %>
<%@ import Namespace=&quot;System.Drawing&quot; %>
<%@ import Namespace=&quot;System.Web.HttpCookie&quot; %>
<script runat=&quot;server&quot;>
Public Sub Page_Load(Source as Object, E As EventArgs)
if Not IsPostBack Then
BindData
End If
End Sub
Sub BindData
Dim dbconn As SqlConnection = New SqlConnection(&quot;server=AM1ST_FS1;database=HRINFO;uid=sa;&quot
Dim selectCMD As SqlCommand = New SqlCommand(&quot; Select * From phonelist where location = 1st Floor Order by lastName&quot
dbconn.open()
fstfloor.DataSource = selectCMD.ExecuteReader()
fstfloor.DataBind()
dbconn.close()
End Sub

 

[JohnYingling]

The command object needs to know the connection to use.
Either
' Assign connection at NEW for Command object
Dim selectCMD As SqlCommand = New SqlCommand(&quot; Select * From phonelist where location = 1st Floor Order by lastName&quot;, dbconn)

OR
'Assign coonection manually before exeute
selectCmd.Connection = dbconn
fstfloor.DataSource = selectCMD.ExecuteReader()

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript