protected void Page_Load(object sender, EventArgs e)
{
string Course = "人機互動設計";
SqlConnection con = new SqlConnection(
WebConfigurationManager.ConnectionStrings["myDB"].ConnectionString);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter("Select UserName, CourseID, DisplayName From Courses Where DisplayName='" + Course + "'", con);
DataTable dt = new DataTable();
adapter.Fill(dt);
SqlDataAdapter adapter3 = new SqlDataAdapter();
DataTable table = new DataTable();
//---------------課程資訊Table---------------//
adapter3 = new SqlDataAdapter(
"Select term From StudentFile Where UserName='******'", con);
DataTable dt3 = new DataTable();
adapter3.Fill(dt3);
table.Columns.Add(new DataColumn("學期"));
table.Columns.Add(new DataColumn("課號"));
table.Columns.Add(new DataColumn("課程名稱"));
table.Columns.Add(new DataColumn("教師姓名"));
DataRow row = table.NewRow();
row["學期"] = Convert.ToString(Session["term"]);
row["課號"] = Convert.ToString(Session["CourseID"]);
row["課程名稱"] = Course;
row["教師姓名"] = "周志岳";
table.Rows.Add(row);
CourseInformationGridView.DataSource = table;
CourseInformationGridView.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//string Course = "人機互動設計";
string Course = Convert.ToString(Session["CourseName"]).Trim();
//學號UserName
string UserName = "";
coursename.Text = Course;
SqlConnection con = new SqlConnection(
WebConfigurationManager.ConnectionStrings["myDB"].ConnectionString);
con.Open();
//----Select 人機互動設計學生的學號----//
SqlDataAdapter adapter = new SqlDataAdapter("Select UserName, CourseID, DisplayName From StudentCoursesList Where Type=1 and DisplayName='" + Course + "'", con);
SqlDataAdapter adapter2 = new SqlDataAdapter();
SqlDataAdapter adapter3 = new SqlDataAdapter();
DataTable dt = new DataTable();
DataTable dt2 = new DataTable();
adapter.Fill(dt);
//---------------修課人數---------------//
RowCount = dt.Rows.Count;
DataTable table = new DataTable();
//------用學號select StudentFile資料------//
for (int i = 0; i < RowCount; i++)
{
UserName = Convert.ToString(dt.Rows[i]["UserName"]);
adapter2 = new SqlDataAdapter(
"Select Department, Class, UserName,"
+ "FullName From Accounts Where type=1 And UserName='******'", con);
adapter2.Fill(dt2);
}
//---------------課程資訊Table---------------//
adapter3 = new SqlDataAdapter(
"Select Year, Semester, CourseID, DisplayName, Belong From Courses Where DisplayName='"
+ Course + "'", con);
DataTable dt3 = new DataTable();
adapter3.Fill(dt3);
dt3.Columns["Year"].ColumnName = "學年";
dt3.Columns["Semester"].ColumnName = "學期";
dt3.Columns["CourseID"].ColumnName = "課號";
dt3.Columns["DisplayName"].ColumnName = "課程名稱";
dt3.Columns["Belong"].ColumnName = "教師姓名";
//table.Columns.Add(new DataColumn("學期"));
//table.Columns.Add(new DataColumn("課號"));
//table.Columns.Add(new DataColumn("課程名稱"));
//table.Columns.Add(new DataColumn("教師姓名"));
//DataRow row = table.NewRow();
//Session["term"] = Convert.ToString(dt3.Rows[0]["Year"]) + Convert.ToString(dt3.Rows[0]["Semester"]);
//Session["CourseID"] = Convert.ToString(dt3.Rows[0]["CourseID"]);
//row["學期"] = Convert.ToString(Session["term"]);
//row["課號"] = Convert.ToString(Session["CourseID"]);
//row["課程名稱"] = Convert.ToString(dt3.Rows[0]["DisplayName"]);
//row["教師姓名"] = Convert.ToString(dt3.Rows[0]["Belong"]);
//table.Rows.Add(row);
CourseInformationGridView.DataSource = dt3;
CourseInformationGridView.DataBind();
//--------------修改欄位名--------------//
dt2.Columns["Department"].ColumnName = "系名";
dt2.Columns["Class"].ColumnName = "班級";
dt2.Columns["UserName"].ColumnName = "學號";
dt2.Columns["FullName"].ColumnName = "姓名";
StudentListGridView.DataSource = dt2;
StudentListGridView.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string Course = Convert.ToString(Session["CourseName"]).Trim();
SqlConnection con = new SqlConnection(
WebConfigurationManager.ConnectionStrings["myDB"].ConnectionString);
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter();
//---------------課程資訊Table---------------//
adapter = new SqlDataAdapter(
"Select Year, Semester, CourseID, DisplayName, Belong From Courses Where DisplayName='"
+ Course + "'", con);
DataTable dt = new DataTable();
adapter.Fill(dt);
dt.Columns["Year"].ColumnName = "學年";
dt.Columns["Semester"].ColumnName = "學期";
dt.Columns["CourseID"].ColumnName = "課號";
dt.Columns["DisplayName"].ColumnName = "課程名稱";
dt.Columns["Belong"].ColumnName = "教師姓名";
//尋找這堂課的助教
SqlDataAdapter adapter2 = new SqlDataAdapter("Select Type, UserName, DisplayName From StudentCoursesList Where Type=2 and DisplayName='" + Course + "'", con);
DataTable dt2 = new DataTable();
adapter2.Fill(dt2);
//助教的學號
string username = "";
//如果資料表裡有助教資料
if (dt2.Rows.Count != 0)
{
username = Convert.ToString(dt2.Rows[0]["UserName"]).Trim();
}
//用學號去Accounts資料表找這名學生的資料
DataTable dt3 = new DataTable();
//如果資料表裡有助教資料
if (username != "")
{
SqlDataAdapter adapter3 = new SqlDataAdapter("Select Department, Class, UserName,FullName From Accounts Where UserName='******'", con);
adapter3.Fill(dt3);
dt3.Columns["Department"].ColumnName = "系名";
dt3.Columns["Class"].ColumnName = "班級";
dt3.Columns["UserName"].ColumnName = "學號";
dt3.Columns["FullName"].ColumnName = "姓名";
GridView1.DataSource = dt3;
GridView1.DataBind();
}
//沒有助教資料只顯示欄位
else
{
dt3.Columns.Add(new DataColumn("系名"));
dt3.Columns.Add(new DataColumn("班級"));
dt3.Columns.Add(new DataColumn("學號"));
dt3.Columns.Add(new DataColumn("姓名"));
DataRow row = dt3.NewRow();
row["系名"] = "";
row["班級"] = "";
row["學號"] = "";
row["姓名"] = "";
dt3.Rows.Add(row);
GridView1.DataSource = dt3;
GridView1.DataBind();
GridView1.Rows[0].Visible = false;
}
CourseInformationGridView.DataSource = dt;
CourseInformationGridView.DataBind();
con.Close();
}
