msflexgrid shows strange numbers when column contains decimal number
Posted on 2005-05-03
hi all...I need help with msflexgrid....I am a newbie on visual basic...I was trying to use msflexgrid to show data from sql server 2000. I don't use ADODC but I use ADODB.
basically I use dsn for the connection ( cn.open "myconn"), set the cursortype to aduseclient,
then use cmd to set activeconnection, and create rs for it. I successfully display the data, but weird number showed on the table. I have 110.25 , 220.85, 325.97 on the column. The result is like this
stockname | weight
gold | 110.25
silver | 00000003
copper | 00000002
the number is formatted as float in the database. can anyone help me? thanks........