null values in Gridview (Full Version)

All Forums >> [Web Development] >> General Web Development



Message

truwebs -> null values in Gridview (3/27/2007 9:15:39)

Hello,

I have a gridview that will not display records that have null values for some fields.

Anybody know how to get these records to display?

Thanks,

TRU



mar0364 -> RE: null values in Gridview (3/27/2007 15:58:47)

I would love to help. Why would you want to show a record that has a null value? I'm a little confused as to what you’re asking. There is a property you can set in the gridview that will display some text if the record meets a certain condition.

Thanks!
Rich



truwebs -> RE: null values in Gridview (3/27/2007 16:57:01)

I have a table where some records have fields where there is not data.

I have created a gridview with edit/delete options. to display the table. The gridview does not display records where there are null value fields.

Does that make more sense?

Thanks,

TRU



mar0364 -> RE: null values in Gridview (3/29/2007 14:48:48)

Did you ever get this sorted out?

Regards!
Rich



truwebs -> RE: null values in Gridview (3/29/2007 22:47:17)

Not yet. Getting closer. Figured out it was due to my sql statement with inner joins to other tables. I have been told I need to adjust with outer joins to remedy the problem.

Thanks for inquiring.



truwebs -> RE: null values in Gridview (4/5/2007 22:11:40)

Indeed my select statement was the problem. Created outer joins to fix the problem between related tables in the db.

TRU



susall -> RE: null values in Gridview (6/15/2009 8:53:19)

My sql query works fine using outer joins... I get the rows that contain regular data and the one column in which nulls are allowed. However, the DataView still doesn't display the rows. I've checked the bound fields in the gridview, and the ConvertEmptyStringToNull property is already set to True. I'm at a loss at this point. MSDN does offer an article on handling NULLs, but their suggestions aren't working.
-su



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625