How do I find the datatype of a datatable?

#1

Hello:

I defined a datatable to have two columns:

' Add three column objects to the table.
idColumn = New DataColumn()
idColumn.DataType = System.Type.GetType("System.String")
idColumn.ColumnName = "CaseId"
dtTable.Columns.Add(idColumn)

idColumn = New DataColumn()
idColumn.DataType = System.Type.GetType("System.Int64")
idColumn.ColumnName = "CaseVersion"
dtTable.Columns.Add(idColumn)

I would like to get the datatype of the column during run time so that I can
cast the data into the right data type.

If I use Row(columnindex).GetType.FullName, it always returns System.DBNull,
irregardless of the columnindex is.

Can somebody guide me?

Thanks.

venki

#2

Perhaps by checking DataColumn's DataType?
dtTable.Columns(0).DataType

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"vvenk" <vvenk (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hello:

I defined a datatable to have two columns:

' Add three column objects to the table.
idColumn = New DataColumn()
idColumn.DataType = System.Type.GetType("System.String")
idColumn.ColumnName = "CaseId"
dtTable.Columns.Add(idColumn)

idColumn = New DataColumn()
idColumn.DataType = System.Type.GetType("System.Int64")
idColumn.ColumnName = "CaseVersion"
dtTable.Columns.Add(idColumn)

I would like to get the datatype of the column during run time so that I
can
cast the data into the right data type.

If I use Row(columnindex).GetType.FullName, it always returns
System.DBNull,
irregardless of the columnindex is.

Can somebody guide me?

Thanks.

venki

#3

Try this

dtTable.Columns(ColumnIndex).DataType.Name
--
Thanks Shyam

"vvenk" wrote:

Quote:

Hello:

I defined a datatable to have two columns:

' Add three column objects to the table.
idColumn = New DataColumn()
idColumn.DataType = System.Type.GetType("System.String")
idColumn.ColumnName = "CaseId"
dtTable.Columns.Add(idColumn)

idColumn = New DataColumn()
idColumn.DataType = System.Type.GetType("System.Int64")
idColumn.ColumnName = "CaseVersion"
dtTable.Columns.Add(idColumn)

I would like to get the datatype of the column during run time so that I can
cast the data into the right data type.

If I use Row(columnindex).GetType.FullName, it always returns System.DBNull,
irregardless of the columnindex is.

Can somebody guide me?

Thanks.

venki

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How do I find the datatype of a datatable?

Dotnet Data Tools microsoft.public.dotnet.datatools

How do I find the datatype of a datatable? - 10-08-2006 , 09:27 AM

Re: How do I find the datatype of a datatable? - 10-09-2006 , 05:58 AM

RE: How do I find the datatype of a datatable? - 12-02-2007 , 11:45 PM