[求助]这段代码哪里错了??
private int rowNum = 2;
protected void Page_Load(object sender, EventArgs e)
{
string str=ConfigurationManager.ConnectionStrings["pet"].ConnectionString;
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand("select top 4 petID from pet order by petID",con);
con.Open();
int i = 0;
SqlDataReader sdr = cmd.ExecuteReader();
System.Web.UI.WebControls.TableRow tr = new TableRow();
while (sdr.Read())
{
i = i + 1;
System.Web.UI.WebControls.TableCell tc = new TableCell();
hotPetControl hpc = (hotPetControl)this.LoadControl("hotPetControl.aspx");
hpc.PetID = sdr.GetString(0);
tc.Controls.Add(hpc);
tr.Controls.Add(tc);
if (i % this.rowNum == 0)
{
this.Table1.Rows.Add(tr);
tr = new TableRow();
}
}
if (i % this.rowNum != 0)
{
this.Table1.Rows.Add(tr);
}
sdr.Close();
con.Close();
}
------------------------------
运行时显示con.Open()有问题,为什么啊??