数据网格问题 - 运行时错误'6' - 溢出 [英] Datagrid Problem- Run time error'6'- overflow

问题描述

亲爱的所有人，


我将我的sql数据与数据网格连接起来，但并非所有列都只是特定的列。有某些条件，但它显示错误为运行时错误''6-溢出...


请帮助我....


问候

Lucky13

解决方案

dataadapter = New MySqlDataAdapter（" SELECT column1，column2，column3 FROM tablename"，connection）


dataadapter.Fill（datatable）


datagridview.datasource = datatable


或


dataadapter = New MySqlDataAdapter（" SELECT * FROM tablename"，connection）

dataadapter.Fill（datatable）


datatable.column（column）.clomnmapping = columnmapping.hidden


datagridview.datasource = datatable


或


dataadapter = New MySqlDataAdapter（" SELECT * FROM tablename"，connection）


dataadapter.Fill（datatable）


datagridview.datasource = datatable


if lcase（datagridview.col umn（column）.name.tostring）=" column"然后

datagridview.column（column）.visible = false

end if if

Hello Nev，

感谢您的即时回复，但是对不起，我输错了数据库为mysql，实际上是sql server 2000.

dataadapter = New MySqlDataAdapter（" SELECT column1，column2，column3 FROM tablename"，connection）


dataadapter.Fill（datatable）


datagridview.datasource = datatable

或


dataadapter = New MySqlDataAdapter（" SELECT * FROM tablename"，连接）


dataadapter.Fill（datatable）

datatable.column（column）.clomnmapping = columnmapping.hidden


datagridview.datasource = datatable

或


dataadapter = New MySqlDataAdapter（" SELECT * FROM tablename"，connection） ）


dataadapter.Fill（datatable）


datagridview.datasource = datatable


if lcase（datagridview.column（column）.name.tostring）=" column"然后

datagridview.column（column）.visible = false

结束如果

您用于数据适配器的SQL语句是什么..？


问候

Veena

Dear All,

I m connecting my sql data with the data grid, but not all columns only particular columns. having certain conditions, but it is showing the error as Runtime Error ''6- overflow...

please help me....

Regards
Lucky13

解决方案

dataadapter = New MySqlDataAdapter("SELECT column1,column2,column3 FROM tablename", connection)

dataadapter.Fill(datatable)

datagridview.datasource = datatable

or

dataadapter = New MySqlDataAdapter("SELECT * FROM tablename", connection)

dataadapter.Fill(datatable)

datatable.column(column).clomnmapping = columnmapping.hidden

datagridview.datasource = datatable

or

dataadapter = New MySqlDataAdapter("SELECT * FROM tablename", connection)

dataadapter.Fill(datatable)

datagridview.datasource = datatable

if lcase(datagridview.column(column).name.tostring) = "column" then
datagridview.column(column).visible = false
end if

Hello Nev,

thanks for the immediate reply, but i m sorry , i typed the wrong database as mysql, actually it is sql server 2000.

dataadapter = New MySqlDataAdapter("SELECT column1,column2,column3 FROM tablename", connection)

dataadapter.Fill(datatable)

datagridview.datasource = datatable

or

dataadapter = New MySqlDataAdapter("SELECT * FROM tablename", connection)

dataadapter.Fill(datatable)

datatable.column(column).clomnmapping = columnmapping.hidden

datagridview.datasource = datatable

or

dataadapter = New MySqlDataAdapter("SELECT * FROM tablename", connection)

dataadapter.Fill(datatable)

datagridview.datasource = datatable

if lcase(datagridview.column(column).name.tostring) = "column" then
datagridview.column(column).visible = false
end if

Hi,

What SQL Statement you have used for the data adapter..?

Regards
Veena

这篇关于数据网格问题 - 运行时错误'6' - 溢出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！