Click here to Skip to main content
15,916,030 members
Home / Discussions / C#
   

C#

 
GeneralUpdating propertygrid control Pin
netJP12L15-Jan-08 16:35
netJP12L15-Jan-08 16:35 
QuestionNeed some help using Membership and user authentication Pin
Shimmy Weitzhandler15-Jan-08 15:22
Shimmy Weitzhandler15-Jan-08 15:22 
QuestionGetting the maximum file size for a particular location Pin
Skippums15-Jan-08 12:31
Skippums15-Jan-08 12:31 
GeneralRe: Getting the maximum file size for a particular location Pin
Luc Pattyn15-Jan-08 13:20
sitebuilderLuc Pattyn15-Jan-08 13:20 
GeneralRe: Getting the maximum file size for a particular location Pin
Skippums15-Jan-08 13:40
Skippums15-Jan-08 13:40 
GeneralConverting Mapped Drive string to Server Name (UNC path) Pin
Leo Smith15-Jan-08 12:06
Leo Smith15-Jan-08 12:06 
GeneralRe: Converting Mapped Drive string to Server Name (UNC path) Pin
PIEBALDconsult15-Jan-08 14:16
mvePIEBALDconsult15-Jan-08 14:16 
Generalnull value needed in datacolumn expression Pin
yann bertaud15-Jan-08 11:14
yann bertaud15-Jan-08 11:14 
Hello

I have a datacolumn that uses an expression to sum other columns, for example i have 3 datacolumns: count1, count2 and count3.
A 4th column "total" uses the expression:
"IsNull([count1],0) + IsNull([count2],0) + IsNull([count3],0)"

Which works fine if any one column value in the row is null. However if all 3 columns have null values, the 4th column will be 0. I want it to be null. See example below.
|count1|count2|count3|total|
| 3| 2| 5| 10|
| 12| | 3| 15|
| | | | 0|

for that last row i would like the total value to be blank rather than 0. How can I achieve that in the expression?

thanks

Yann
GeneralRe: null value needed in datacolumn expression Pin
yann bertaud15-Jan-08 12:51
yann bertaud15-Jan-08 12:51 
GeneralRe: null value needed in datacolumn expression Pin
Justin Perez16-Jan-08 3:39
Justin Perez16-Jan-08 3:39 
GeneralProcess.Start and return value Pin
Giorgi Dalakishvili15-Jan-08 9:55
mentorGiorgi Dalakishvili15-Jan-08 9:55 
GeneralRe: Process.Start and return value Pin
Dave Kreskowiak15-Jan-08 11:07
mveDave Kreskowiak15-Jan-08 11:07 
GeneralHelp a beginner.. Pin
Dio2215-Jan-08 9:03
Dio2215-Jan-08 9:03 
GeneralRe: Help a beginner.. Pin
led mike15-Jan-08 10:45
led mike15-Jan-08 10:45 
GeneralMS Access Pin
waheed awan15-Jan-08 8:11
waheed awan15-Jan-08 8:11 
GeneralRe: MS Access Pin
Dave Kreskowiak15-Jan-08 9:25
mveDave Kreskowiak15-Jan-08 9:25 
GeneralRe: MS Access Pin
Dan Neely15-Jan-08 10:48
Dan Neely15-Jan-08 10:48 
Questionxmlns validate with regex problem Pin
two_man_only15-Jan-08 8:05
two_man_only15-Jan-08 8:05 
AnswerRe: xmlns validate with regex problem Pin
Shimmy Weitzhandler17-Jan-08 8:02
Shimmy Weitzhandler17-Jan-08 8:02 
GeneralRe: xmlns validate with regex problem Pin
two_man_only17-Jan-08 8:21
two_man_only17-Jan-08 8:21 
GeneralGet Current User From Windows Service Pin
Lash2015-Jan-08 5:53
Lash2015-Jan-08 5:53 
GeneralRe: Get Current User From Windows Service Pin
Justin Perez16-Jan-08 3:48
Justin Perez16-Jan-08 3:48 
GeneralDataTable Suggestion Please [modified] Pin
doubleas238015-Jan-08 5:09
doubleas238015-Jan-08 5:09 
GeneralRe: DataTable Suggestion Please Pin
Not Active15-Jan-08 5:37
mentorNot Active15-Jan-08 5:37 
Generalremoting and window service Pin
poqeqw15-Jan-08 4:41
poqeqw15-Jan-08 4:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.