欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

firebird Embedded模式(.net 3.5)

程序员文章站 2023-11-17 14:57:22
复制代码 代码如下:dim connectionstring = new fbconnectionstringbuilder() connectionstring.clie...
复制代码 代码如下:

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()