程式搜集分享精靈

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;

public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server=localhost; uid=test; pwd=test; database=test;MultipleActiveResultSets=true");
SqlDataReader dr1 = null;
try
{
conn.Open();
SqlCommand cmd1 = new SqlCommand("select id,title,test_time from test", conn);

dr1 = cmd1.ExecuteReader();
if (dr1.HasRows)
{
while (dr1.Read())
{
Panel p1 = new Panel();
Label l1 = new Label();
l1.Text = "<p>" + dr1["id"] + "." + "<b>" + dr1["title"] + "</b></p>";
p1.Controls.Add(l1);
Page.Form.Controls.Add(p1);

SqlCommand cmd2 = new SqlCommand("select id,author,article from test_talk where test_id="+dr1["id"],conn);
SqlDataReader dr2 = cmd2.ExecuteReader();
if (dr2.HasRows)
{
Panel p2 = new Panel();
GridView gv = new GridView();
gv.DataSource = dr2;
gv.DataBind();
p2.Controls.Add(gv);
Page.Form.Controls.Add(p2);

}
cmd2.Cancel();
dr2.Close();

}
}
cmd1.Cancel();
dr1.Close();
dr1.Dispose();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
throw;
}

conn.Close();
conn.Dispose();

}
}