动态表格读取课程表

    protected void btn_scan_Click(object sender, EventArgs e)
    {
        Table table = new Table();
        TableTitle(table);
        using (SqlConnection sqlCnn = new SqlConnection(Student.cnnstring))
        {
            using (SqlCommand sqlCmm = sqlCnn.CreateCommand())
            {
                sqlCmm.CommandText = "select L.Time,L1.LessonName from Lessontable L inner join Lessonlist L1 on L.Lessonid=L1.Lessonid where L.classid=(select Classid from Classlist where classname='"+this.txb_class.Text+"')";     
                sqlCnn.Open();
                SqlDataReader reader = sqlCmm.ExecuteReader();
                if (reader!= null)
                {
                    while (reader.Read())
                    {
                        FillData(table, reader);
                    }
                }
            }
        }
     
        this.classtable.Controls.Add(table);
    }
    private void FillData(Table table,SqlDataReader reader)
    {
        TableRow row = new TableRow();
        TableCell cel = new TableCell();
        cel.Text=reader["Time"].ToString();
        row.Cells.Add(cel);
        cel = new TableCell();
        cel.Text=reader["LessonName"].ToString();
        row.Cells.Add(cel);
        table.Rows.Add(row);
    }
    private void TableTitle(Table table)
    {
        TableRow row = new TableRow();
        TableCell cell = new TableCell();
        cell.Text = "时间";
        row.Cells.Add(cell);
        cell = new TableCell();
        cell.Text = "课程";
        row.Cells.Add(cell);
        table.Rows.Add(row);
    }