Arjan's World: VB.NET: Issues With Changing The DataType Of A Column
You are now being redirected to the new housing of Arjan's World. Click here in case nothing happens

Wednesday, September 20, 2006

VB.NET: Issues With Changing The DataType Of A Column

I'm working with a DataGridView that gets its data from a server somewhere on the network in the form of an XML document. Therefore it's an unbound grid (*) for which some processing has to be done behind the scenes (XML >> DataTable >> Binding by code). Now I noticed an amount somewhere could be changed by the user ending up in decimals, instead of the required whole numbers. Thinking this could be changed easily I naively did


resulting in a nice

Cannot change DataType of a column once it has data.

The solution - of course - was to first build a DataColumn object with the right Type and bind that to the DataTable:

Dim dc1 As New DataColumn
dc1.DataType = GetType(Int32)
dc1.ColumnName = "Amount"

Learned something new, hopefully it wil help you too.

(*) Naturally, would the grid have been bound, the DataType would folow automatically from the underlying DataSource...


Post a Comment

<< Home