protected void bind()
{
OleDbConnection conn = getconnection();
string uname = Convert.ToString(HttpContext.Current.Session["uname"]);
string sid = Convert.ToString(HttpContext.Current.Session["roleid"]);
string roletype = Convert.ToString(HttpContext.Current.Session["role_type"]);
string sql = "SELECT COURSE.CID, COURSE.CNAME, COURSE.CCREDIT, COURSE.CTID, COURSE.CSNUM, COURSE.CSTART, \n" +
" COURSE.CPERFECT, COURSE.CFULL, b.total, iif(c.SID, '已选', '可选') AS CSTATE\n" +
"FROM ((COURSE LEFT OUTER JOIN\n" +
" (SELECT COUNT(SID) AS total, CID\n" +
" FROM SC\n" +
" GROUP BY CID) b ON b.CID = COURSE.CID) LEFT OUTER JOIN\n" +
" (SELECT CID, SID\n" +
" FROM SC SC_1\n" +
" WHERE (SID = " + sid + ")) c ON c.CID = COURSE.CID)";
OleDbCommand cmd = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataReader dr;
dr = cmd.ExecuteReader();
CourceView.DataSource = dr;
CourceView.DataKeyNames = new string[] { "CID" };
CourceView.DataBind();
dr.Dispose();
cmd.Dispose();
conn.Close();
}
protected void bind()
{
string cid = Request.QueryString["cid"];
OleDbConnection conn = getconnection();
string uname = Convert.ToString(HttpContext.Current.Session["uname"]);
string sid = Convert.ToString(HttpContext.Current.Session["roleid"]);
string roletype = Convert.ToString(HttpContext.Current.Session["role_type"]);
string sql = "SELECT SC.SCID, SC.CID, SC.GRADE, SC.SID, COURSE.CNAME, STUDENT.SNAME\n" +
"FROM ((SC INNER JOIN\n" +
" COURSE ON SC.CID = COURSE.CID) INNER JOIN\n" +
" STUDENT ON SC.SID = STUDENT.SID)\n" +
"WHERE (SC.CID = " + cid + ")";
OleDbCommand cmd = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataReader dr;
dr = cmd.ExecuteReader();
CourceView.DataSource = dr;
CourceView.DataKeyNames = new string[] { "SCID" };
CourceView.DataBind();
dr.Dispose();
cmd.Dispose();
conn.Close();
}
protected void bind()
{
OleDbConnection conn = getconnection();
string sql = "SELECT CID, CNAME, CCREDIT, CTID, CSNUM, CSTART FROM COURSE";
OleDbCommand cmd = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataReader dr;
dr = cmd.ExecuteReader();
CourceView.DataSource = dr;
CourceView.DataKeyNames = new string[] { "CID" };
CourceView.DataBind();
dr.Dispose();
cmd.Dispose();
conn.Close();
}
protected void bind()
{
OleDbConnection conn = getconnection();
string uname = Convert.ToString(HttpContext.Current.Session["uname"]);
string tid = Convert.ToString(HttpContext.Current.Session["roleid"]);
string roletype = Convert.ToString(HttpContext.Current.Session["role_type"]);
string sql = "SELECT CID, CNAME, CCREDIT, CTID, CSNUM, CSTART,CPERFECT FROM COURSE where CTID =" + tid;
OleDbCommand cmd = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataReader dr;
dr = cmd.ExecuteReader();
CourceView.DataSource = dr;
CourceView.DataKeyNames = new string[] { "CID" };
CourceView.DataBind();
dr.Dispose();
cmd.Dispose();
conn.Close();
}