J
jason
hello everyone,
one of my developers is working with a DataGrid component, which uses a
DataTable as its DataSource.
the DataTable is populated by a method which calls a stored procedure
through an SqlCommand object, which accepts two input parameters which
affect the query range.
the problem she's experiencing is that with all input parameter values,
the DataTable is built correctly, and has data in it (this can be
verified through runtime debugging inspection - but also through
manually running the stored procedures with all the possible input
parameter values - they all return greater than zero rows). however,
when the input parameters are least restrictive (meaning the largest
range of rows returned) - even though the DataTable has information in
it, the DataBind operation seems to have no effect whatsoever. after
the DataBind, the DataGrid displays no data.
the only thing we can think of is if the DataGrid has a limitation of
the number of rows it can display? or perhaps just a raw amount of data
that can be bound to it? that seems unlikely though, since the number
of rows being returned by the least restrictive search is only 32,581.
thanks for any help,
jason
one of my developers is working with a DataGrid component, which uses a
DataTable as its DataSource.
the DataTable is populated by a method which calls a stored procedure
through an SqlCommand object, which accepts two input parameters which
affect the query range.
the problem she's experiencing is that with all input parameter values,
the DataTable is built correctly, and has data in it (this can be
verified through runtime debugging inspection - but also through
manually running the stored procedures with all the possible input
parameter values - they all return greater than zero rows). however,
when the input parameters are least restrictive (meaning the largest
range of rows returned) - even though the DataTable has information in
it, the DataBind operation seems to have no effect whatsoever. after
the DataBind, the DataGrid displays no data.
the only thing we can think of is if the DataGrid has a limitation of
the number of rows it can display? or perhaps just a raw amount of data
that can be bound to it? that seems unlikely though, since the number
of rows being returned by the least restrictive search is only 32,581.
thanks for any help,
jason