public void sem2() { st = @"SELECT distinct prd1.student_id, prd1.date, prd1.sub, prd1.status, prd2.sub AS Period2, prd2.status AS Status, prd3.sub AS Period3, prd3.status AS Status FROM prd1 INNER JOIN prd2 ON prd1.sl_num = prd2.sl_num INNER JOIN prd3 ON prd1.sl_num = prd3.sl_num WHERE prd1.student_id = '" + Session["session_std"].GetHashCode() + "'"; db.fill_grid_ret_sqlda(st, GridView1); }
protected void check_Click(object sender, EventArgs e) { st = @"SELECT distinct prd1.student_id, prd1.date, prd1.sub, prd1.status, prd2.sub AS Period2, prd2.status AS Status, prd3.sub AS Period3, prd3.status AS Status FROM prd1 INNER JOIN prd2 ON prd1.sl_num = prd2.sl_num INNER JOIN prd3 ON prd1.sl_num = prd3.sl_num WHERE prd1.student_id = " + TextBox1.Text + " and prd1.sem=" + DropDownList1.Text + ""; db.fill_grid_ret_sqlda(st, GridView1); }
protected void Page_Load(object sender, EventArgs e) { if (Session["student"] == null) { Response.Redirect("../Default.aspx"); } else { string st = "select Reg_number,sub as Subjects,Total_Maximum,Assignment_Maximum,assign as Assignment,Minor1,Minor2,Total from MarksCard where Reg_number=" + Session["student"] + ""; db.fill_grid_ret_sqlda(st, GridView1); string str = "select sum(Total) from MarksCard where Reg_number=" + Session["student"] + ""; SqlDataReader dr = db.sqldr(str); while (dr.Read()) { Label1.Text = dr.GetValue(0).ToString(); } dr.Close(); } }