|
| |
|
|
truwebs
Posts: 80
Joined: 7/10/2006
Status: offline
 |
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
Posts: 3297
Joined: 4/5/2002
From: Florida, US
Status: offline
|
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
_____________________________
Easy Web
“Stay committed to your decisions, but stay flexible in your approach.”
| |
|
|
|
truwebs
Posts: 80
Joined: 7/10/2006
Status: offline
|
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
Posts: 3297
Joined: 4/5/2002
From: Florida, US
Status: offline
|
RE: null values in Gridview - 3/29/2007 14:48:48
Did you ever get this sorted out?
Regards!
Rich
_____________________________
Easy Web
“Stay committed to your decisions, but stay flexible in your approach.”
| |
|
|
|
truwebs
Posts: 80
Joined: 7/10/2006
Status: offline
|
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
Posts: 80
Joined: 7/10/2006
Status: offline
|
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
Posts: 1
Joined: 6/15/2009
Status: offline
|
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
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 