J
jp2msft
I have a TableAdapter linked to an SQL Server 2000 table. Some of the cells
have null string values.
In VS2005, I can preview the data linked by the TableAdapter in design mode,
and all fields are displayed - even the ones with cells containing null
values (they just show "null" in the cell).
When I run my application, I create a DataTable and use an SqlDataAdapter
and fill it using the TableAdapter.
To search my data, I use the DataTable's Select method; however, any row
that contains a null value will not show up in the DataRows that are returned.
Has anyone ever encountered something like this?
Why is this happening, and how do I get around it?
have null string values.
In VS2005, I can preview the data linked by the TableAdapter in design mode,
and all fields are displayed - even the ones with cells containing null
values (they just show "null" in the cell).
When I run my application, I create a DataTable and use an SqlDataAdapter
and fill it using the TableAdapter.
To search my data, I use the DataTable's Select method; however, any row
that contains a null value will not show up in the DataRows that are returned.
Has anyone ever encountered something like this?
Why is this happening, and how do I get around it?