Getting all column names / column values from datarow when debugging

Question

I'm creating a mock instance of one of my datarows for testing.

The row I'm trying to duplicate from our database contains 37 columns with different variables.

Is there any chance when debugging to get the information out in clean text for simple editing of my mock objects?

http://stackoverflow.com/questions/12823371/datacolumn-name-from-datarow-not-datatable Best Answer — Ajit, Sep 28 '16 at 09:35

score 9 · Answer 1 · answered Jun 18 '15 at 08:49

9

I had to adjust Nikhil's Cast:

var colNames = dr.Table.Columns.Cast<DataColumn>().Select(x => x.ColumnName).ToList();

answered Jun 18 '15 at 08:49

Mårten Sörliden

101
1
5

score 7 · Accepted Answer · answered Nov 16 '12 at 08:41

7

How about

var colNames = dr.Table.Columns.Cast(Of DataColumn)
                               .Select(x => x.ColumnName).ToList()

answered Nov 16 '12 at 08:41

Nikhil Agrawal

47,018
22
121
208

score 1 · Answer 3 · answered Nov 16 '12 at 09:14

1

Solved it like this since I couldnt get Nikhils code to work.

        int i = 0;
        while(i<looprow.Table.Columns.Count)
        {
            Debug.WriteLine(looprow.Table.Columns[i].ColumnName);
            i++;
        }

answered Nov 16 '12 at 09:14

Andreas

1,421
3
16
32

Getting all column names / column values from datarow when debugging

3 Answers3

Linked