Counting rows with a SqlDataAdapter

Question

I have a problem in my code. I want to get the row count from my SqlDataAdapter if there are any rows.

Answer 1

Maybe try dt.Rows.Count since that is a table and has rows.

Answer 2

You were doing an assignment instead of a comparison, you have to use == :

if (dt.Rows.Count == 0 )
{
    // code here
}