How do I perform a boolean test to see if a value is or is not in a DB?

Hello all,

I know this is easier than it looks...

I used the ASP.NET WebMatrix's "Select Data Method" to buid the following code.

============================================================================
 Function DoesAccountExist(ByVal userName As String) As System.Data.DataSet
        Dim connectionString As String = "server='(local)'; trusted_connection=true; database='Clients'"
        Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)
       
        Dim queryString As String = "SELECT [Account].[UserName] FROM [Account] WHERE ([Account].[UserName] = @UserNam"& _
"e)"
        Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
        dbCommand.CommandText = queryString
        dbCommand.Connection = dbConnection
       
        Dim dbParam_userName As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
        dbParam_userName.ParameterName = "@UserName"
        dbParam_userName.Value = userName
        dbParam_userName.DbType = System.Data.DbType.String
        dbCommand.Parameters.Add(dbParam_userName)
       
        Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.SqlClient.SqlDataAdapter
        dataAdapter.SelectCommand = dbCommand
        Dim dataSet As System.Data.DataSet = New System.Data.DataSet
        dataAdapter.Fill(dataSet)
       
        Return dataSet
    End Function

==============================================================================

My problem is. I want this to be a boolean function and simply return a TRUE/FALSE indicating wheter a value I pass it is or is NOT in the dataSet.

Any thoughts?

-TH
Start Free Trial