I have

SQLReader clmReader;

clmReader.Read();

if (clmReader.IsDBNull )

The IsDBNull is not correct; what did I leave out?

Todd

if(clmReader.HasRows)

This serves your purpose.

Hope this helps.

Hi, rtCary

Yes you can use if (dataReader.HasRows). Also i will suggest to wrap your code under "using" . Below is the sample code

            using (SqlConnection connection = new SqlConnection("xx--Your Connection String—xx"))
            {
                using (SqlCommand command = new SqlCommand("xx-Your Command--xx", connection))
                {
                    connection.Open();
                    using (SqlDataReader dataReader = command.ExecuteReader(CommandBehavior.CloseConnection))
                    {
                        if (dataReader != null)
                            if (dataReader.HasRows)
                            {
                               //your logic
                            }
                    }
                }
            }

The using statement guarantees that resources are properly cleaned up and that they're cleaned up in the most timely manner.

Thank you both!

Todd