如何在VB.Net中放入带有整数值的SQL WHERE子句？(How to put SQL WHERE clause with integer value in VB.Net?)

如何在VB.Net中放入带有整数值的SQL WHERE子句？(How to put SQL WHERE clause with integer value in VB.Net?)

好的，我很抱歉，如果这对你来说太容易了，但我有点困惑，我不知道我需要什么方法。 请多多包涵。

在SQL Server Management Studio中，我有一个获取活动用户信息的查询。

SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = '1'

我的问题是我不知道或者我忘了如何在VB.Net中放置带有整数值的where子句。

这是我的代码

Public Shared Function FnGetUserID() As List(Of String)
        Dim lstUserID As New List(Of String)

        Dim cmd As New SqlCommand()
        Try
            cmd.Connection = DBConn.getConn()
            cmd.CommandType = CommandType.Text
            cmd.Connection.Open()

            Dim sql As String = ""
            sql += " SELECT DISTINCT UserID FROM tblUserInfo"

            cmd.CommandText = sql

            Dim sqlRdr As SqlDataReader = cmd.ExecuteReader
            While sqlRdr.Read
                lstUserID.Add(sqlRdr.Item("UserID").ToString)
            End While

            cmd.Connection.Close()
            cmd.Dispose()
        Catch ex As Exception
            cmd.Dispose()
            'lstSite = Nothing
        End Try

        Return lstUserID
    End Function
 
 我想出了这个 
 
Dim sql As String = ""
sql += " SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = @IsActive"

cmd.CommandText = sql

parameter.ParameterName = "@IsActive"
parameter.Value = "1"
cmd.Parameters.Add(parameter)
 
 我不知道这是否正确。 请帮我解决一下这个。 谢谢。 
Okay I'm sorry if this was too easy for you but I'm kinda confused and I don't know what approach I need for this. Please bear with me.
 
In SQL Server Management Studio I have a query that gets the active User information.
 
SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = '1'
 
My problem is that I don't know or rather I forgot how to put where clause with integer value in VB.Net.
 
Here's my code
 
Public Shared Function FnGetUserID() As List(Of String)
        Dim lstUserID As New List(Of String)

        Dim cmd As New SqlCommand()
        Try
            cmd.Connection = DBConn.getConn()
            cmd.CommandType = CommandType.Text
            cmd.Connection.Open()

            Dim sql As String = ""
            sql += " SELECT DISTINCT UserID FROM tblUserInfo"

            cmd.CommandText = sql

            Dim sqlRdr As SqlDataReader = cmd.ExecuteReader
            While sqlRdr.Read
                lstUserID.Add(sqlRdr.Item("UserID").ToString)
            End While

            cmd.Connection.Close()
            cmd.Dispose()
        Catch ex As Exception
            cmd.Dispose()
            'lstSite = Nothing
        End Try

        Return lstUserID
    End Function
 
and I came up with this
 
Dim sql As String = ""
sql += " SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = @IsActive"

cmd.CommandText = sql

parameter.ParameterName = "@IsActive"
parameter.Value = "1"
cmd.Parameters.Add(parameter)
 
I don't know if this is right or not. Please help me with this. Thanks.
                
最满意答案
                
                    
                        
 您的代码看起来正确。 
 
 如果列IsActive是整数，则可以将命令文本设置为以下任一项： 
 
"SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = 1"

"SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = '1'"
 
 如果要使用该参数，则使用命令文本是正确的： 
 
"SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = @IsActive"
 
 使用该参数时，您必须确保将其添加到sql命令对象中，如下所示： 
 
    Dim parameter As SqlClient.SqlParameter = New SqlClient.SqlParameter

    parameter.ParameterName = "@IsActive"
    parameter.Value = "1"
    cmd.Parameters.Add(parameter)
 
 在调用ExecuteReader之前，必须将该参数添加到命令中。 
Your code looks correct.
 
If the column IsActive is an Integer, you can set the command text to be either of the following:
 
"SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = 1"

"SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = '1'"
 
If you want to use the parameter, you are correct with using the command text:
 
"SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = @IsActive"
 
When using the parameter you have to make sure you add it to the sql command object as you are doing:
 
    Dim parameter As SqlClient.SqlParameter = New SqlClient.SqlParameter

    parameter.ParameterName = "@IsActive"
    parameter.Value = "1"
    cmd.Parameters.Add(parameter)
 
You must add the parameter to the command before you call ExecuteReader.
如何在VB.Net中放入带有整数值的SQL WHERE子句？(How to put SQL WHERE clause with integer value in VB.Net?)

                
 好的，我很抱歉，如果这对你来说太容易了，但我有点困惑，我不知道我需要什么方法。 请多多包涵。 
 
 在SQL Server Management Studio中，我有一个获取活动用户信息的查询。 
 
SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = '1'
 
 我的问题是我不知道或者我忘了如何在VB.Net中放置带有整数值的where子句。 
 
 这是我的代码 
 
Public Shared Function FnGetUserID() As List(Of String)
        Dim lstUserID As New List(Of String)

        Dim cmd As New SqlCommand()
        Try
            cmd.Connection = DBConn.getConn()
            cmd.CommandType = CommandType.Text
            cmd.Connection.Open()

            Dim sql As String = ""
            sql += " SELECT DISTINCT UserID FROM tblUserInfo"

            cmd.CommandText = sql

            Dim sqlRdr As SqlDataReader = cmd.ExecuteReader
            While sqlRdr.Read
                lstUserID.Add(sqlRdr.Item("UserID").ToString)
            End While

            cmd.Connection.Close()
            cmd.Dispose()
        Catch ex As Exception
            cmd.Dispose()
            'lstSite = Nothing
        End Try

        Return lstUserID
    End Function
 
 我想出了这个 
 
Dim sql As String = ""
sql += " SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = @IsActive"

cmd.CommandText = sql

parameter.ParameterName = "@IsActive"
parameter.Value = "1"
cmd.Parameters.Add(parameter)
 
 我不知道这是否正确。 请帮我解决一下这个。 谢谢。 
Okay I'm sorry if this was too easy for you but I'm kinda confused and I don't know what approach I need for this. Please bear with me.
 
In SQL Server Management Studio I have a query that gets the active User information.
 
SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = '1'
 
My problem is that I don't know or rather I forgot how to put where clause with integer value in VB.Net.
 
Here's my code
 
Public Shared Function FnGetUserID() As List(Of String)
        Dim lstUserID As New List(Of String)

        Dim cmd As New SqlCommand()
        Try
            cmd.Connection = DBConn.getConn()
            cmd.CommandType = CommandType.Text
            cmd.Connection.Open()

            Dim sql As String = ""
            sql += " SELECT DISTINCT UserID FROM tblUserInfo"

            cmd.CommandText = sql

            Dim sqlRdr As SqlDataReader = cmd.ExecuteReader
            While sqlRdr.Read
                lstUserID.Add(sqlRdr.Item("UserID").ToString)
            End While

            cmd.Connection.Close()
            cmd.Dispose()
        Catch ex As Exception
            cmd.Dispose()
            'lstSite = Nothing
        End Try

        Return lstUserID
    End Function
 
and I came up with this
 
Dim sql As String = ""
sql += " SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = @IsActive"

cmd.CommandText = sql

parameter.ParameterName = "@IsActive"
parameter.Value = "1"
cmd.Parameters.Add(parameter)
 
I don't know if this is right or not. Please help me with this. Thanks.
                
最满意答案
                
                    
                        
 您的代码看起来正确。 
 
 如果列IsActive是整数，则可以将命令文本设置为以下任一项： 
 
"SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = 1"

"SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = '1'"
 
 如果要使用该参数，则使用命令文本是正确的： 
 
"SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = @IsActive"
 
 使用该参数时，您必须确保将其添加到sql命令对象中，如下所示： 
 
    Dim parameter As SqlClient.SqlParameter = New SqlClient.SqlParameter

    parameter.ParameterName = "@IsActive"
    parameter.Value = "1"
    cmd.Parameters.Add(parameter)
 
 在调用ExecuteReader之前，必须将该参数添加到命令中。 
Your code looks correct.
 
If the column IsActive is an Integer, you can set the command text to be either of the following:
 
"SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = 1"

"SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = '1'"
 
If you want to use the parameter, you are correct with using the command text:
 
"SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = @IsActive"
 
When using the parameter you have to make sure you add it to the sql command object as you are doing:
 
    Dim parameter As SqlClient.SqlParameter = New SqlClient.SqlParameter

    parameter.ParameterName = "@IsActive"
    parameter.Value = "1"
    cmd.Parameters.Add(parameter)
 
You must add the parameter to the command before you call ExecuteReader.