62,074
社区成员
发帖
与我相关
我的任务
分享
protected void Button2_Click(object sender, EventArgs e)
{
string strconn = ConfigurationManager.ConnectionStrings["GA_OnlineExamConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(strconn); conn.Open();
string sql = "select * from Problem where title='Telnet指的是'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
reader.Close(); conn.Close();
GridView gv = new GridView();
gv.AutoGenerateColumns = false;
foreach(DataColumn dc in dt.Columns)
{
BoundField bc = new BoundField();
bc.HeaderText = dc.Caption;
bc.DataField = dc.ColumnName;
gv.Columns.Add(bc);
}
gv.DataSource = dt;
gv.DataBind();
Label3.Text = gv.Columns.Count.ToString();
Label4.Text = gv.Rows.Count.ToString();
Panel2.Controls.Add(gv);
}