62,243
社区成员
发帖
与我相关
我的任务
分享数据库连接问题求教。
我在Global.asax文件中添加了sqlConnection以及sqlDataAdapter组件后，如何在其它页面中使用这两个组件啊？？
...全文
请发表友善的回复…
发表回复
mvb2211 2002-07-10
- 打赏
- 举报
动态实现
Dim cnn As New OleDb.OleDbConnection()
Dim cnstr As String = "Provider = SQLOLEDB.1;Password=mvb1234;Persist Security Info=True;User ID=sa;Initial Catalog=tfmsdb;Data Source=mvb"
Dim dc As OleDb.OleDbDataAdapter
Dim ds As New DataSet()
Dim dr As DataRow
Dim mytable As DataTable
cnn.ConnectionString = cnstr
cnn.Open()
dc = New OleDb.OleDbDataAdapter("select top 20 * from person", cnstr)
dc.Fill(ds, "person")
mytable = ds.Tables("person")
DataGrid1.DataSource = ds.Tables("person")
DataGrid1.DataBind()
DataGrid1.DataMember = mytable.TableName
Dim cnn As New OleDb.OleDbConnection()
Dim cnstr As String = "Provider = SQLOLEDB.1;Password=mvb1234;Persist Security Info=True;User ID=sa;Initial Catalog=tfmsdb;Data Source=mvb"
Dim dc As OleDb.OleDbDataAdapter
Dim ds As New DataSet()
Dim dr As DataRow
Dim mytable As DataTable
cnn.ConnectionString = cnstr
cnn.Open()
dc = New OleDb.OleDbDataAdapter("select top 20 * from person", cnstr)
dc.Fill(ds, "person")
mytable = ds.Tables("person")
DataGrid1.DataSource = ds.Tables("person")
DataGrid1.DataBind()
DataGrid1.DataMember = mytable.TableName
bluefish922 2002-07-10
- 打赏
- 举报
另外再做个数据库连接组件了
icyer 2002-07-10
- 打赏
- 举报
可以把这两个组件放在Application里面，在其他页面里读取这个Application。
但是把Connection放在Application里面并不能节省资源。
但是把Connection放在Application里面并不能节省资源。
