I'm getting the following error:

System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. Parameter name: value

The table that I am pulling from is only returning one record when I get the error. If I add a second item to the table, everything behaves as it should. Is there something quirky with how the DataGrid distinguishes between AlternatingItem and Item when there is only one record. Has anyone seen this before?

Thanks in advance for any suggestions...I've tried everything I can think of!

Have you tryed >>ExecuteReader or ExecuteNonQuery<<?
Because the ExecuteScalar returns one row from table.

Hey,

Could this be a paging error? Are you somehow on a different page that this is giving you an error?

Can you post any relevant code?

Brian