VB.NET中把excel表导入到datagrid 时,我用了以下的代码 :
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
cn.CursorLocation = ADODB.CursorLocationEnum.adUseClient
cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=D:\TEMP.xls;" & "Persist Security Info=False;" & "Extended Properties=""Excel 8.0;""")
rs.Open("select * from [Sheet1$]", cn, ADODB.CursorTypeEnum.adOpenUnspecified, ADODB.LockTypeEnum.adLockUnspecified)
DataGrid1.DataSource = rs
(这是几个帖子里提到的方法,但我这出错了)
程序运行到DataGrid1.DataSource = rs时报错说:未处理的“System.Exception”类型的异常出现在 system.windows.forms.dll 中。其他信息: Complex DataBinding accepts as a data source either an IList or an IListSource。请问为什么我这是错的,帮帮忙吧,急呢!!
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
cn.CursorLocation = ADODB.CursorLocationEnum.adUseClient
cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=D:\TEMP.xls;" & "Persist Security Info=False;" & "Extended Properties=""Excel 8.0;""")
rs.Open("select * from [Sheet1$]", cn, ADODB.CursorTypeEnum.adOpenUnspecified, ADODB.LockTypeEnum.adLockUnspecified)
DataGrid1.DataSource = rs
(这是几个帖子里提到的方法,但我这出错了)
程序运行到DataGrid1.DataSource = rs时报错说:未处理的“System.Exception”类型的异常出现在 system.windows.forms.dll 中。其他信息: Complex DataBinding accepts as a data source either an IList or an IListSource。请问为什么我这是错的,帮帮忙吧,急呢!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货