ASP.NET中操作SQL数据库(连接字符串的配置及获取)

在WebConfig中配置数据库连接字符串代码如下

复制代码 代码如下:
<connectionStrings>
<add name="ConnectionString" connectionString="user id=用户名;password=密码;initial catalog=数据库名称;data source=服务器名称"/>
</connectionStrings>

然后在Webform_aspxcs里面获取连接字符串要添加如下引用

复制代码 代码如下:
using SystemConfiguration;
using SystemData;
using SystemDataSqlClient;

代码

复制代码 代码如下:
SqlConnection con;
protected void Page_Load(object sender EventArgs e)
{
ConnectDB();
}
private void ConnectDB()
{
string ConString = ConfigurationManagerConnectionStrings["ConnectionString"]ConnectionString;
con = new SqlConnection(ConString);
conOpen();
SqlCommand com = new SqlCommand();
SqlDataReader sdr;
string sqlstr = "select * from item";
comCommandText = sqlstr;
comConnection = con;
sdr = comExecuteReader();
while (sdrRead())
{
ResponseWrite(sdr["字段名"]ToString()+"</br>");
}
sdrClose();
sdr = null;
}