Adding a column to a datatable

[Tina]

I'm doing this...

Dim dt As New DataTable

dt.Columns.Add("AreaGroup", Type.GetType("System.String"))

dt.Columns.Add("Col1", Type.GetType("System.String"))

dt.Columns.Add("Col2", Type.GetType("System.decimal"))

it works ok when I specify System.String but when I specify System.decimal I
get an exception saying...

'dataType' argument cannot be null. Parameter name: dataType

Why?
T

 

[Teemu Keiski]

Hi,

not sure if it is case-sensitive but type name is "System.Decimal" (Decimal
with the first character in uppercase)

 

[siid]

Answer

"Tina" <[email protected]> wrote in message
news:[email protected]...
> I'm doing this...
>
> Dim dt As New DataTable
>
> dt.Columns.Add("AreaGroup", Type.GetType("System.String"))
>
> dt.Columns.Add("Col1", Type.GetType("System.String"))
>
> dt.Columns.Add("Col2", Type.GetType("System.Decimal"))
>
> it works ok when I specify System.String but when I specify System.decimal
I
> get an exception saying...
>
> 'dataType' argument cannot be null. Parameter name: dataType
>
> Why?
> T
>Answer []:
Keep first letter capital
eg: System.Decimal
System.Double

This will make your code work:congrats:

Thanks
Siid.