ASP.NET中操作SQL数据库

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

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

然后在Webform_1.aspx.cs里面获取连接字符串，要添加如下引用；

using System.Configuration;
using System.Data;
using System.Data.SqlClient;

代码：

SqlConnection con;

        protected void Page_Load(object sender, EventArgs e)
        {
            ConnectDB();
        }

private void ConnectDB()
        {
            string ConString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            con = new SqlConnection(ConString);
            con.Open();
            SqlCommand com = new SqlCommand();
            SqlDataReader sdr;
            string sqlstr = "select * from item";
            com.CommandText = sqlstr;
            com.Connection = con;
            sdr = com.ExecuteReader();
            while (sdr.Read())
            {
                Response.Write(sdr["字段名"].ToString()+"</br>");
            }
            sdr.Close();
            sdr = null;
           
        }

补充：Web开发 , ASP.Net ,

上一个：asp.net c#在updatepanel中支持滚动条记忆功能
下一个：isapi_rewrite运行在.net framework 4.0+iis 6.0环境下404错误解决方案