Interview Question in sql server 2008
Interview Question :: Format integer in ms sql server 2005 to vb.net forms. such as 23545.2398 will be written as 23,545.24 |
im connecting ms sql server 2005 with vb.net 2008. so i have a table in the database called fee_table with columns fee_code, fee_name, fee_amount. fee_amount has a data type varchar(50), so when i view the data in a datagridview in vb.net, they will show as it is. how do i make fee_amount display in the datagridview such as if in the database it is written as 123456789.345 it will show in the datagridview as 123,456,789.35
oh yah i know theres a datatype in sql, money, so i used that but what happens is there's no comma and it has 4 decimal places fixed. >__< im formatting it for money by the way.
i kept researching online and applying the codes in vb but it wont work. no luck >__<
thanks in advance |
|
|
|
Loading ...