Hello, I've tried this code without using a where statement and it works fine, but as soon as I put one in I get this error:
Name 'dgResults' is not declared.
I tried declarion Putting Dim in front of it, and then all by itself..I don't get it. Thx in Advance
<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
sub Page_Load(sender as Object, e as EventArgs)
Dim Find_Item = request.form("Find_Item")
'Create a connection string
Dim connString as String
connString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & _
Dim objConnection as OleDbConnection
objConnection = New OleDbConnection(connString)
Dim strSQL as String = "SELECT * FROM Profiles WHERE First_Name = '" & Find_Item & "' "
Dim objCommand as OleDbCommand
objCommand = New OleDbCommand(strSQL, objConnection)
Dim objDataReader as OleDbDataReader
objDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection)
dgResults.DataSource = objDataReader
<pre><asp ataGrid id="dgResults" runat="server" /></pre>
Users Browsing this Thread
There are currently 1 users browsing this thread.
(0 members and 1 guests)