ASP.NET中操作SQL数据库

 在WebConfig中配置数据库连接字符串,代码如下:  
  服务器名称" />
  
  然后在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()+"
");
  }
  sdr.Close();
  sdr = null;
  }

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注

Grow your business fast with

Suku