这样不行,占了同一个数据库连接,可以改为 if (!this.IsPostBack) { if (Request.QueryString["id"] != null) { string id = Request.QueryString["id"].ToString(); String strConnection = ConfigurationSettings.AppSettings["ConnectionString"]; SqlConnection myConnection = new SqlConnection(strConnection); myConnection.Open(); SqlConnection myConnection1 = new SqlConnection(strConnection); myConnection1.Open(); SqlCommand cmd = new SqlCommand("select id from classdata11 where id=+'" + id + "'", myConnection); this.Label1.Text = Convert.ToString(cmd.ExecuteScalar()); cmd.CommandText = "select * from classdata11 where id='" + id + "'"; SqlCommand cmd1 = new SqlCommand("select id from replya where id=+'" + id + "'", myConnection1); cmd.CommandText = "select * from classdata11 where id='" + id + "'"; cmd1.CommandText = "select * from replya where id='" + id + "'"; SqlDataReader sdr = cmd.ExecuteReader(); SqlDataReader sdr1 = cmd1.ExecuteReader();//这行这样写吗?? this.DataList1.DataSource = sdr; this.DataList1.DataBind(); this.DataList2.DataSource = sdr1; this.DataList2.DataBind();
if (!this.IsPostBack)
{
if (Request.QueryString["id"] != null)
{
string id = Request.QueryString["id"].ToString();
String strConnection = ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection myConnection = new SqlConnection(strConnection);
myConnection.Open();
SqlConnection myConnection1 = new SqlConnection(strConnection);
myConnection1.Open();
SqlCommand cmd = new SqlCommand("select id from classdata11 where id=+'" + id + "'", myConnection);
this.Label1.Text = Convert.ToString(cmd.ExecuteScalar());
cmd.CommandText = "select * from classdata11 where id='" + id + "'";
SqlCommand cmd1 = new SqlCommand("select id from replya where id=+'" + id + "'", myConnection1);
cmd.CommandText = "select * from classdata11 where id='" + id + "'";
cmd1.CommandText = "select * from replya where id='" + id + "'";
SqlDataReader sdr = cmd.ExecuteReader();
SqlDataReader sdr1 = cmd1.ExecuteReader();//这行这样写吗??
this.DataList1.DataSource = sdr;
this.DataList1.DataBind();
this.DataList2.DataSource = sdr1;
this.DataList2.DataBind();