奇怪的问题,将vchar转化为float 时出错

[dd922]

dim sqlcon as new oledb.oledbconnection(连接穿）
sqlcon.open
dim sqladp as new oledb.oledbdataadapter(new oledb.oledbcommand("select * from t_yw",sqlcon))
dim ds as new dataset()
sqladp.fill(ds,"t_yw")就是这里出错了将vchar转化为float 时出错
能告诉我为什么吗，高手帮忙？

[panyee]

写成这种形式,不用conn.open(),adapter里写sql语句
dim sqlcon as new oledb.oledbconnection(连接穿）
dim sqladp as new oledb.oledbdataadapter("select * from t_yw",sqlcon)
dim ds as new dataset()
sqladp.fill(ds,"t_yw")