Skip to Content
0
Former Member
Dec 11, 2009 at 11:54 AM

using oDBDataSource.SetValue for date, price and percentage type

510 Views

Hi experts,

I need to set value to db datasource for date, price and percentage type, below my code:

oDBDataSource.SetValue("U_ItemPrc", offset, oDataTable.GetValue("U_ItemPrc", i))

oDBDataSource.SetValue("U_Discount", offset, oDataTable.GetValue("U_Discount", i))

oDBDataSource.SetValue("U_Data", offset, oDataTable.GetValue("U_Data", i))

...

mt.Columns.Item("ItemPrc").DataBind.SetBound(True, "@TC_LIS1", "U_ItemPrc")

mt.Columns.Item("Discount").DataBind.SetBound(True, "@TC_LIS1", "U_Discount")

mt.Columns.Item("Data").DataBind.SetBound(True, "@TC_LIS1", "U_Data")

...

mt.LoadFromDataSource()

the column "U_ItemPrc" is a price with 5 decimals

the column "U_Discount" is a percentage with 2 decimals

the column "U_Data" is a date

I get the three matrix column blank!

How can I set value for these data type?

please help me.

Thanks

Best regards

Andrea