The below code returns Object variable or With block variable not set.
at
dgResults.DataSource = objDataReader
What does this mean?
code.....
' Set up our connection.
Dim objConnection As SqlConnection
objConnection = New SqlConnection("Server=localhost;Database=customers;UID=sa;PWD=go;")
objConnection.Open()
'Specify the SQL string
Dim strSQL As String = "Select First_Name,Last_Name from USERS_TBL WHERE ID=" & strUserID2 & ""
'Create a command object
Dim objCommand As SqlCommand
objCommand = New SqlCommand(strSQL, objConnection)
objCommand.ExecuteNonQuery()
'Get a datareader
objDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection)
'Do the DataBinding
dgResults.DataSource = objDataReader
dgResults.DataBind()
getFirst = objDataReader("FIRST_NAME")
getlast = objDataReader("LAST_NAME")
getuserinfo = getlast & "," & getFirst
' Close the datareader/db connection
objDataReader.Close()
Open in new window