firebird Embedded模式(.net 3.5)

复制代码 代码如下:

  Dim connectionString = New FbConnectionStringBuilder()

  connectionString.ClientLibrary = "fbembed.dll"

  connectionString.ServerType = FbServerType.Embedded

  connectionString.Database = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Test.Fdb")

  connectionString.Pooling = True

  connectionString.Dialect = 3

  Dim conn As New FbConnection(connectionString.ToString)

  Dim comm As New FbCommand("select first 10 * from test", conn)

  conn.Open()

  Dim fp As New FbDataAdapter(comm)

  Dim ds As New DataSet

  fp.Fill(ds)

  fp.Dispose()

  comm.Dispose()

  conn.Close()

  Repeater1.DataSource = ds.Tables(0)

  Repeater1.DataBind()

  ds.Dispose()

  文件下载