VS2005中微软企业库的使用
1.添加三个应用
Microsoft.Practices.ObjectBuilder.dll
Microsoft.Practices.EnterpriseLibrary.Common.dll
Microsoft.Practices.EnterpriseLibrary.Data.dll
2.添加四个命名空间
using System.Data.Common;
using Microsoft.Practices.EnterpriseLibrary.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Common.Configuration;
3.VS2005中使用企业库提供的功能连接数据库操作如下:
先在WEB.CONFIG文件中定义一个连接字符串如下:
<connectionStrings>
<add name="schoolDb" connectionString="server=.;database=school;uid=sa;pwd=;" providerName="System.Data.SqlClient"/>
</connectionStrings>
然后编写后台C#代码如下:
protected void btnProc_Click(object sender, EventArgs e)
{
Database db = DatabaseFactory.CreateDatabase("schoolDb");
DbCommand dbc = db.GetSqlStringCommand("select * from student");
this.stuGrid.DataSource = db.ExecuteDataSet(dbc);
this.stuGrid.DataBind();
}