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



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
4.882813E-02