Is this valid??

[tehon3299]

Is this a valid SQL Statement??

"SELECT Last INTO txtLast.Text.ToString FROM tmUserInfo WHERE UserID = tehon3299"

UserID is in table tmUserInfo and Last is in the table also. If I put that query in the SQL Query Analyzer with out the INTO statement it works fine. Im just not sure about that INTO statement. It must be wrong, because it is not working.

Thanks

 

[wayko]

the into command is used for inserting
insert into table
item value itemname

 

[Robby]

It looks like you want txtLast to display the value of Last for user tehon3299, am I correct?

try this...

    Private Function GetTableValue(ByVal sUser As String) As String
        Dim drSqlReader As SqlDataReader
        Dim SqlCMD As SqlCommand
        Dim SqlCN As New SqlConnection(Conn)Conn is your connection string
        Dim strSql As String, sTemp As String
        Try
            If SqlCN.State = ConnectionState.Closed Then SqlCN.Open()
            strSql = "SELECT Last FROM tmUserInfo WHERE UserID = " & sUser & ""
            SqlCMD = New SqlCommand(strSql, SqlCN)
            drSqlReader = SqlCMD.ExecuteReader()

            While drSqlReader.Read
                sTemp = CType(drSqlReader.Item("UserID"), String)
            End While
        Catch
            sTemp = ""
        Finally
            If Not SqlCN.State = ConnectionState.Closed Then SqlCN.Close()
            If Not drSqlReader.IsClosed Then drSqlReader.Close()
            If Not SqlCMD Is Nothing Then SqlCMD.Dispose()
        End Try
        Return sTemp
    End Function

call the function like this...
txtLast.Text = GetTableValue ("tehon3299")