working on my first page and SQL commands

[sthmpsn1]

I am trying to connect to a database and need to have two sql statements for my query incase I would have an EOF error. Right now I am getting an error message on this script. How would I fix this?

Public Sub Page_Load(Source as Object, E As EventArgs)
if Not IsPostBack Then

Dim dbconn As SqlConnection = New SqlConnection("server=AM1ST_FS1;database=HRINFO;uid=sa;&quot

Dim selectCMD As SqlCommand = New SqlCommand("Select * from employeeinfo where userID = '" & request.servervariables("AUTH_USER&quot & "'", dbconn)
if selectCMD.EOF
selectCMD = New SqlCommand("Select * from employeeinfo where userID = 'AM1ST_DOMAIN\" & request.servervariables("AUTH_USER&quot & "'", dbconn)
end if
selectCMD.CommandTimeout = 30

Dim empDA As SqlDataAdapter = New SqlDataAdapter
empDA.SelectCommand = selectCMD

dbconn.Open()

Dim empDS As DataSet = New DataSet
empDA.Fill(empDS, "employeeinfo&quot
dbconn.Close()
End If
End Sub

 

[Zarcom]

what is the error message?

 

[sthmpsn1]

BC30456: 'EOF' is not a member of 'System.Data.SqlClient.SqlCommand'.

 

[Alcar]

try this:

Dim selectCMD As SqlCommand = New SqlCommand()
selectCMD.CommandText = "Select * from employeeinfo where userID = '" & request.servervariables("AUTH_USER&quot & "'"
selectCmd.Connection = dbconn

if selectCMD.ExecuteNonQuery() = 0 then
selectCMD.CommandText = "Select * from employeeinfo where userID = 'AM1ST_DOMAIN\" & request.servervariables("AUTH_USER&quot & "'"

end if


hth