How to change Data type of Grid column at runtime..??

[Former Member]

Hi ,

I have taken a "Grid" control,and i have pass a query "Select itemcode Qunatity,linetotal From PDN1" in the ExecuteQuery

method of Grid it displaying the data,

but the problem is i want to change the Datatype of this column from "FLOAT" to "db_Quantity" according to the SAP standerd

of decimal places(like 2 or 3 decimal place which the customer maintain) after executing Query.

How can we achieve this please guide me what to do...

Thanks

Sandesh

[former_member209699 · Accepted solution]

Hi sandesh

try with

Select itemcode Qunatity,convert(decimal(19,2), linetotal) [linetotal] From PDN1

regards:

Sandy

[former_member263358 · Accepted solution]

Not Work!

[pedro_magueija · Accepted solution]

Hi Enrico,

Using queries to "define" the type is very tricky. There is no way to correctly identify the semantic difference between a price and a quantity (they are both "doubles").

One way you can do it is to create the DataTable bound to the Grid manually and define the columns correctly. You can then use the DataTable SetValue method to set the data in it.

---

Pedro Magueija

View Pedro Magueija's profile on LinkedIn
Follow @pedromagueija on Twitter

If this answer was helpful or correct consider marking it as such.