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