Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Format an ADO.NET boolean as "0" or "1"

Posted on 2006-12-01
9
Medium Priority
?
1,432 Views
Last Modified: 2008-01-09
I am converting answers for a survey to a specified format. I need to handle boolean questions, which can be skipped. Here is the rubric

ADO.NET Value     Output
DBNull                  ""
true                     "1"
false                    "0"

Can someone come up with something simpler than this:

[code]
        const string missing = "";
        private static string GetBoolOutputFromDataRowView(DataRowView drv, string columnName)
        {
            object obj = drv[columnName];
            if (obj == System.DBNull.Value)
                return missing;
            else
                return ((bool)obj == true) ? "1" : "0";
        }
[/code]
0
Comment
Question by:anyoneis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 3
9 Comments
 
LVL 29

Accepted Solution

by:
Nightman earned 2000 total points
ID: 18057911
That looks good enough to me. Do you have any specific concerns about this approach?
0
 
LVL 29

Assisted Solution

by:Nightman
Nightman earned 2000 total points
ID: 18057924
A simpler approach could be to do this in SQL, and not have to handle it in ADO at all.

e.g.
SELECT CASE  WHEN MyColumn IS NULL THEN 'Missing' WHEN MyColumn=1 THEN '1' ELSE '0' END result FROM MyTable
0
 
LVL 11

Author Comment

by:anyoneis
ID: 18062561
Thanks, Nightman. I have the feeling I am overlooking some formatting idiom or apparatus, so I thought I would ask.

Also, I don't have any control over the SQL, I am getting a dataset and datatable from the vendors library, so changing the SQL is out of the question.

David
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 29

Expert Comment

by:Nightman
ID: 18062586
The only thing that I would do would be to place curly braces around the if else statements ( if {} else {}). This doesn't change the execution path of your code, but it makes it 100% clear to anyone that is reading your code where the scope is.

There are plenty here that will disagree with me, but from experience working in large teams with shared source, having everything clearly defined makes integration, maintenance and debugging easier.
0
 
LVL 1

Expert Comment

by:jagadeeshbandlamudi
ID: 18069998
You want to return either true or False right, then why do you want to use  'string missing = "" '. If anything other than 1 just return False
0
 
LVL 11

Author Comment

by:anyoneis
ID: 18074666
No, I need "missing". if the column is null, I want to return an indication that the field was missing. This might be a "." for a SAS data file, or a blank for a pipe-delimited file.

What I was looking for was some revelation on formatting nullable types, or an approach with a custom format provider.
0
 
LVL 1

Expert Comment

by:jagadeeshbandlamudi
ID: 18074851
Then I guess whatever you are doing is right.. This might be of some help to you
  \
            public type format(DbType dbType)
              {
                     switch(dbType)
                         case DbType.Boolean: return typeof(bool);
                          break;
0
 
LVL 1

Expert Comment

by:jagadeeshbandlamudi
ID: 18074853
public type format(DbType dbType)
              {
                     switch(dbType)
                         case DbType.Boolean: return typeof(bool);
                          break;
                       default:
                             return typeof(string);      
}
0
 
LVL 11

Author Comment

by:anyoneis
ID: 18128457
I guess we are done with this. Thanks for your input, everyone!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
This article describes a simple method to resize a control at runtime.  It includes ready-to-use source code and a complete sample demonstration application.  We'll also talk about C# Extension Methods. Introduction In one of my applications…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question