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);
}
{
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);
}