使用 DataGridView 绑定Acess出项现IErrorInfo.GetDescription 因 E_FAIL(0x80004005) 而失败。

[yifan__]

感谢您浪费几分钟帮忙看一下这个问题，

在使用 DataGridView 绑定Acess，在程序运行时总是出现如下问题：

myCommand.Fill(myDataSet, "SGS")显示IErrorInfo.GetDescription 因 E_FAIL(0x80004005) 而失败。
以下为代码

Public Class SGSForm
Dim strCon As String = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source =db1.mdb"

Dim strCom1 As String = "SELECT id, pn as SINBON料号, name as 名称 ,start as SGS起始日期 ,end as SGS到期日期　,product as 成品料号 From SGS order by id "


Public Sub bind_data()
'绑定数据到gridview
SGSData.ReadOnly = True
Dim myDataSet As DataSet

Dim myConn As OleDbConnection = New OleDbConnection()
myConn.ConnectionString = strCon

'创建一个 DataSe
myDataSet = New DataSet()

myConn.Open()
'通过OleDbDataAdapter对象得到一个数据集
Dim myCommand As OleDbDataAdapter = New OleDbDataAdapter(strCom1, myConn)
'把Dataset绑定books数据表

myCommand.Fill(myDataSet, "SGS")

SGSData.DataSource = myDataSet.Tables(0)
SGSData.Columns(0).Visible = False

myConn.Close()
'创建BindingManagerBase对象
End Sub
END sub

[ACMAIN_CHM]

 Dim strCom1 As String = "SELECT id, pn as SINBON料号, [name] as 名称 ,[start] as SGS起始日期 ,[end] as SGS到期日期　,product as 成品料号 From SGS order by id "

注意保留字。

[yifan__]

问题已解决，原来使用了Access的关键字，字段要用“[]”括起来。
刚接触这一块，感谢ACMAIN_CHM回复。