Counting rows with a SqlDataAdapter

c# dataadapter sqldataadapter
im useless picture im useless · Mar 30, 2011 · Viewed 12.9k times · Source

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

Answer

Hogan picture Hogan · Mar 30, 2011

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

Related questions

How to use a DataAdapter with stored procedure and parameter

I want to fill a DataGridView control using DataAdapter. But I don't know how to do it since I'm using a stored procedure with parameter. Can someone cite an example please?

Read More
C# - Using DataAdapter to Update SQL table from a DataTable -> SQL table not updating

I select * from an Excel spreadsheet into dt. I want to take those values and update the SQL table. (the SQL table exists because of a manual import to SQL from the original Excel spreadsheet, has a primary key set. …

Read More
DataAdapter.Update() does not Update the Database

I'm sure there is an extremely simple reason that this one line isn't working, but it has evaded for the past week, so I'm hoping someone else will notice my fault. I have been working on this project for several …

Read More