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.

Solution 1

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

Solution 2

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

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

Comments

[abramlimpin]

Would it be the same effect if you check first if the SqlDataAdapter returns null value?

[Hogan]

@eibhrum - you can have an empty data adapter.

[Hogan]

Since when does a data adapter have a rows attribute?

[BrokenGlass]

typo - should have been dt - fixed

[BrokenGlass]

dt.Rows.Count is a property not a method, so this won't compile

[im useless]

@brokenglass, what would i do?

[Hogan]

yes I saw that just before your comment... seems between the two of us we might write a line that compiles. :D