VB.NET连接 FireBrid 数据库出错
我在系统内安装了FireBrid、及其ADO方式的驱动FirebirdSql.Data.FirebirdClient-4.5.1.0.msi
isql.exe中查看增删数据库表内数据一切正常。在VB.NET2010中写如下代码连接FireBrid数据库希望将表数据显示到DataGridView中来:
Imports FirebirdSql.Data
Imports FirebirdSql.Data.FirebirdClient
Public Class Form1
Public Cn As New FbConnection("DataSource=localhost;Database=c:\Database01.fdb;user=sysdba;password=masterkey;dialect=1")
Public DataAdapter1 As New FbDataAdapter
Public DataTable1 As New DataTable
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Cn.Open() '执行到打开连接时提示:未处理TypeInitializationException
'“FirebirdSql.Data.Common.TimeoutHelper”的类型初始值设定项引发异常
DataAdapter1.SelectCommand.CommandText = "select * from Table01 "
DataAdapter1.SelectCommand.Connection = cn
DataAdapter1.Fill(datatable1)
DataGridView1.DataSource = DataTable1
End Sub
End Class
执行到打开连接时提示:未处理TypeInitializationException
“FirebirdSql.Data.Common.TimeoutHelper”的类型初始值设定项引发异常
还有一个问题顺带问一下:如何在DataGridView单元格内编辑时回车进入右边的单元格呢?
请大侠赐教,谢谢!