Setting the datatype of a new column in a dataset

[Geraldine Hobley]

Hello,
I have added a new row to a dataset as follows:

MyMasterTable.Columns.Add("Total")

Even though I convert it's value to decimal using ctype, it is not displayed using the £ symbol in my bound grid.
I have the format of the specified column set to "c2" in the grid also.

Even when I look at the value that is in the dataset for this column it says 1.00 string.
How can I set the datatype of this column to decimal??

Regards

Geri

[Ken Tucker [MVP]]

Hi,

I would make the column the decimal type to begin with.

Dim dc As New DataColumn("Total", GetType(Decimal))

MyMasterTable.Columns.Add(dc)
Ken
------------------------------------------
"Geraldine Hobley" <Ge*************@discussions.microsoft.com> wrote in
message news:2C**********************************@microsof t.com...

Hello,
I have added a new row to a dataset as follows:

MyMasterTable.Columns.Add("Total")

Even though I convert it's value to decimal using ctype, it is not
displayed using the £ symbol in my bound grid.
I have the format of the specified column set to "c2" in the grid also.

Even when I look at the value that is in the dataset for this column it
says 1.00 string.
How can I set the datatype of this column to decimal??

Regards

Geri