奇怪问题!!!
下面代码连接mySQL数据库
如果SQL语句查询出的结果多一点(比如一万左右)
运行到myRs.Fill(myDst, "d")这句这报错
查询结果是几十条的确正常
为什么???
如果把SQL语句改成"select count(*) as n from azjl;"
运行也正常
哪位高手说说为什么???
Dim myCn As New System.Data.Odbc.OdbcConnection(MyConString)
Dim myCmd As New System.Data.Odbc.OdbcCommand("select * from azjl;", myCn)
Dim myRs As New System.Data.Odbc.OdbcDataAdapter(myCmd)
Dim myDst As New System.Data.DataSet
myRs.SelectCommand = myCmd
myRs.Fill(myDst, "d")
DataGrid1.DataSource = myDst.Tables("d")
myCn.Close()
myCn = Nothing