navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
FrontPage Alternative
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Free FrontPage Templates

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

null values in Gridview

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> Expression Web Help >> null values in Gridview
Page: [1]
 
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: 3221
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.”


(in reply to truwebs)
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

(in reply to mar0364)
mar0364

 

Posts: 3221
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.”


(in reply to truwebs)
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.

(in reply to mar0364)
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

(in reply to truwebs)
Page:   [1]

All Forums >> Web Development >> Expression Web Help >> null values in Gridview
Page: [1]
Jump to: 1





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