Thank you
See below:
Public
Shared Function GetEmployeesAffected(ByVal Column As String, _ByVal Value As String) As IntegerDim DBConnection As SqlConnection = EPICConnection()
Dim cmdSelect As New SqlCommand
cmdSelect.Connection = DBConnectioncmd
Select.CommandText = "Select COUNT(*) As RecordCount FROM Employees WHERE @Column = @Value"
Dim prmColumn As New SqlParameter("@Column", SqlDbType.VarChar)
cmdSelect.Parameters.Add(prmColumn)
cmdSelect.Parameters("@Column").Value = Column Dim prmValue As New SqlParameter("@Value", SqlDbType.VarChar)
cmdSelect.Parameters.Add(prmValue)
cmdSelect.Parameters("@Value").Value = Value
DBConnection.Open()
Dim icount As Integer = cmdSelect.ExecuteScalar
DBConnection.Close()
Return icount End Function
Replies
Know the answer? Post it — somebody with the same question will find it here.