DAAB实现了跨数据库的操作,只需要更改配置即可。
例如在web.config中使用access:
<connectionStrings>
<clear/>
<add name="ConnectionString" connectionString="Provider=Microsoft.Jet.OleDb.4.0 ;Data Source=|DataDirectory|/db.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>
程序中:
Dim x As Database = DatabaseFactory.CreateDatabase("ConnectionString")
Me.GridView1.DataSource = x.ExecuteDataSet(System.Data.CommandType.Text, "select * from UserInfo")
Me.GridView1.DataBind()
要改成Sql server数据库的话,只要修改web.config中
<connectionStrings>
<clear/>
<add name="ConnectionString" connectionString="server=localhost;database=MS;uid=sa;pwd=sa"
providerName="System.Data.SqlClient" />
</connectionStrings>