How to convert boolean to int in itemarray using datatable?

Question

How I convert boolean value to int (1 for True and 2 for false) inside ItemArray. Below is function for converting DataTable to csv.

public  string ToCSV(DataTable tbl, Boolean ColumnHeader)
    {
        string FinalResult = string.Empty;
        StringBuilder strb = new StringBuilder();

        if (ColumnHeader == true)
        {
            //column headers
            strb.AppendLine(string.Join(",", tbl.Columns.Cast<DataColumn>()
                .Select(s => "\"" + s.ColumnName + "\"")));
        }
        //rows
        tbl.AsEnumerable().Select(s => strb.AppendLine(
           string.Join(",", s.ItemArray.Select(
               i => "\"" + i.ToString() + "\"")))).ToList();
        FinalResult = strb.ToString();
        strb= null;
        return FinalResult; 
        //return strb.ToString();
    }

You could write an extendion method for bool called e.g. ToInt() and retruning an int — Philippe
– Philippe, Commented Aug 17, 2016 at 13:32
The boolean column containing True /false value in datatable. — Musakkhir Sayyed
– Musakkhir Sayyed, Commented Aug 17, 2016 at 13:34
The strb= null; line is a holdover from how things used to work in the vb6/vbscript era. It's no longer useful or helpful, and in rare cases can actually be harmful to your code. — Joel Coehoorn
– Joel Coehoorn, Commented Aug 17, 2016 at 13:58
@MusakkhirSayyed Are you going to accept the answer i gave? if not exlpain why my answer does not solve the problem so we can think of a different solution for you — Neil
– Neil, Commented Aug 18, 2016 at 6:38

Neil · Accepted Answer · 2016-08-17 13:54:55Z

2

List<bool> data = new List<bool>() { true, false, false, true };
List<int> intdata = data.Select(x => x ? 1 : 2).ToList();

if you are receiving the true or false as string you can simple change the if statement
from x ? 1: 2 to x == "true" ? 1 : 2

edited Aug 17, 2016 at 13:54

answered Aug 17, 2016 at 13:47

Neil

6661 gold badge8 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert boolean to int in itemarray using datatable?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related