Get a DataTable Columns DataType

Question

DataTable dt = new DataTable();  
dt.Columns.Add(new DataColumn(gridColumn1, typeof(bool)));

I was expecting the result of the below line to include info about the DataColumns Type (bool):

?dt.Columns[0].GetType()

score 96 · Accepted Answer · answered Mar 12 '12 at 02:24

96

What you want to use is this property:

dt.Columns[0].DataType

The DataType property will set to one of the following:

Boolean
Byte
Char
DateTime
Decimal
Double
Int16
Int32
Int64
SByte
Single
String
TimeSpan
UInt16
UInt32
UInt64

answered Mar 12 '12 at 02:24

1

And any other type name, eg System.Collections.Specialized.StringDictionary – philw Jan 28 '15 at 10:27

score 15 · Answer 2 · edited Aug 05 '22 at 06:54

15

You could always use typeof in the if statement. It is better than working with string values like the answer of Natarajan.

using System.Data;

if (dt.Columns[0].DataType == typeof(DateTime))
{
    //...
}

or using column name :

if (dt.Columns["yourColumnName"].DataType == typeof(DateTime))
{
    //...
}

edited Aug 05 '22 at 06:54

Diego Montania

answered Apr 28 '19 at 15:22

VDWWD

score 10 · Answer 3 · edited Oct 24 '17 at 06:20

10

dt.Columns[0].DataType.Name.ToString()

edited Oct 24 '17 at 06:20

FelixSFD

answered Oct 08 '14 at 06:22

7

Please add more details about your answer e.g. explain why your code works etc. – Mehraban Oct 08 '14 at 06:28

score 0 · Answer 4 · edited Oct 12 '21 at 08:36

0

You can get column type of DataTable with DataType attribute of datatable column like below:

var type = dt.Columns[0].DataType

dt: DataTable object.

0: DataTable column index.

edited Oct 12 '21 at 08:36

Wai Ha Lee

answered Mar 28 '17 at 11:34

Arpit Trivedi

score -2 · Answer 5 · edited Oct 12 '21 at 12:22

-2

if (dr[dc.ColumnName].GetType().ToString() == "System.DateTime")

edited Oct 12 '21 at 12:22

General Grievance

answered Mar 16 '20 at 06:27

Vinod Parmar

Getting the type, then converting to a string to compare to seems a little redundant. – General Grievance Oct 12 '21 at 12:21

5 Answers5