protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { db.fillgrid("select * from leave inner join teacher on leave.lid=teacher.lid where status =" + 0, GridView1); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string hdid = Session["login_id"].ToString(); db.fillgrid("select * from leave inner join student on leave.lid=student.lid inner join teacher on teacher.did=student.did where status =0", GridView1); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string lid = Session["Login_id"].ToString(); string sql = "select * from assignment inner join assignment_submitted on assignment_submitted.aid=assignment.aid inner join student on student.lid=assignment_submitted.lid"; db.fillgrid(sql, GridView1); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { db.fillgrid("select * from student inner join department on student.did=department.did inner join teacher on student.did=teacher.did order by sem", GridView1); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { db.fillgrid("select student.name as Name,test.ab_count as Absent_hour from student left join (select count('semid') as ab_count,absent.sid from attendance inner join absent on attendance.atid=absent.atid group by absent.sid) test on student.sid=test.sid ", GridView1); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // db.fillgrid("select student.name as Name,test.ab_count as Absent_hour from student left join (select count('semid') as ab_count,absent.sid from attendance inner join absent on attendance.atid=absent.atid group by absent.sid) test on student.sid=test.sid where batch=1", GridView1); string str; str = Session["login_id"].ToString(); DataTable dt = db.exetable("select sid from student where lid=" + str); db.fillgrid("select count('semid') as HOUR,attendance.date as DATE from attendance inner join absent on attendance.atid=absent.atid where absent.sid=" + dt.Rows[0][0].ToString() + " group by attendance.date ", GridView1); object dt2 = db.execalar("select sum(k.p) as cnt from (select count(semid) as p,attendance.date from attendance inner join absent on attendance.atid=absent.atid where absent.sid=" + dt.Rows[0][0].ToString() + " group by attendance.date ) k"); Label1.Text = dt2.ToString(); object dt3 = db.execalar("select count('date') as p from (select distinct date from attendance) dt"); Label2.Text = (Convert.ToInt32(dt3) * 5).ToString(); Label3.Text = dt3.ToString(); double totp = 0; if (Label1.Text != "") { int qu = Convert.ToInt32(Label1.Text) / 5; int re = Convert.ToInt32(Label1.Text) % 5; totp = Convert.ToInt32(dt3); if (qu > 0) { totp = totp - qu; } if (re >= 3) { totp = totp - .5; } } Label4.Text = totp.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { string lid = Session["Login_id"].ToString(); string sql = "select * from subject inner join university_mark on subject.sid=university_mark.subjectid inner join semester on semester.semid=subject.semid "; db.fillgrid(sql, GridView1); }
protected void DropDownList_subject_SelectedIndexChanged(object sender, EventArgs e) { string sem = DropDownList_sem.SelectedItem.Text; string dep = DropDownList_dep.SelectedItem.Value; string sub = DropDownList_subject.SelectedItem.Value; db.fillgrid("select * from student where sem= '" + sem + "'and did=" + dep, GridView_attendance); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string lid = Session["Login_id"].ToString(); string sql = "select * from callender"; db.fillgrid(sql, GridView1); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string lid = Session["Login_id"].ToString(); string sql = "select * from notes inner join semester on notes.semid=semester.semid inner join subject on subject.sid = notes.sid inner join teacher on teacher.lid=notes.tid"; db.fillgrid(sql, GridView1); } }
protected void DropDownList3_SelectedIndexChanged1(object sender, EventArgs e) { string a = DropDownList1.SelectedItem.Value; string b = DropDownList2.SelectedItem.Value; string c = DropDownList3.SelectedItem.Value; string sql = "select * from absent inner join attendance on absent.atid=attendance.atid inner join department on department.did=attendance.did inner join student on student.sid=absent.sid where attendance.did=" + a + " and attendance.date='" + c + " and attendance.semid='" + b; db.fillgrid(sql, GridView1); }
protected void Button1_Click(object sender, EventArgs e) { string batch = RadioButtonList1.SelectedItem.Value; string sem = DropDownList_sem.SelectedItem.Value; string dep = DropDownList_dep.SelectedItem.Value; string sql = " select * from examtimetable inner join subject on examtimetable.subject=subject.sid where examtimetable.did=" + dep + " and examtimetable.sem=" + sem; db.fillgrid(sql, GridView1); }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { string lid = DropDownList1.SelectedItem.Value; DataTable dt = db.exetable("select * from student where lid=" + lid); Label5.Text = dt.Rows[0]["name"].ToString(); Label6.Text = dt.Rows[0]["email"].ToString(); Label7.Text = dt.Rows[0]["admn"].ToString(); Label9.Text = dt.Rows[0]["sem"].ToString(); Label10.Text = dt.Rows[0]["gender"].ToString(); Image1.ImageUrl = "~/UplodedContents/images/" + dt.Rows[0]["photo"].ToString(); Label11.Text = dt.Rows[0]["dob"].ToString(); Label12.Text = dt.Rows[0]["cstudent"].ToString(); Label13.Text = dt.Rows[0]["cparent"].ToString(); Label14.Text = dt.Rows[0]["address"].ToString(); DataTable dt2 = db.exetable("select * from logintable where lid=" + lid); Label15.Text = dt2.Rows[0]["uname"].ToString(); Label16.Text = dt2.Rows[0]["password"].ToString(); DataTable dt1 = db.exetable("select * from internalmarks inner join subject on internalmarks.subjectid=subject.sid inner join semester on semester.semid=internalmarks.semester where internalmarks.studentid=" + dt.Rows[0][0].ToString()); if (dt1.Rows.Count > 0) { db.fillgrid("select * from internalmarks inner join subject on internalmarks.subjectid=subject.sid inner join semester on semester.semid=internalmarks.semester where internalmarks.studentid=" + dt.Rows[0][0].ToString(), GridView1); } else { Label2.Text = "No Internal Mark Added"; } DataTable dt3 = db.exetable("select * from internal_mark inner join subject on subject.sid=internal_mark.subjectid inner join internal_exam_name on internal_exam_name.intexmid=internal_mark.intextype inner join max_mark on max_mark.intextype=internal_mark.intexmid where internal_mark.studentid=" + dt.Rows[0][0].ToString() + " and internal_mark.intextype=1"); if (dt3.Rows.Count > 0) { db.fillgrid("select * from internal_mark inner join subject on subject.sid=internal_mark.subjectid inner join internal_exam_name on internal_exam_name.intexmid=internal_mark.intextype inner join max_mark on max_mark.intextype=internal_mark.intexmid where internal_mark.studentid=" + dt.Rows[0][0].ToString() + " and internal_mark.intextype=1", GridView2); } else { Label3.Text = "No Fist Internal Mark Added"; } DataTable dt4 = db.exetable("select * from internal_mark inner join subject on subject.sid=internal_mark.subjectid inner join internal_exam_name on internal_exam_name.intexmid=internal_mark.intextype inner join max_mark on max_mark.intextype=internal_mark.intexmid where internal_mark.studentid=" + dt.Rows[0][0].ToString() + " and internal_mark.intextype=2"); if (dt4.Rows.Count > 0) { db.fillgrid("select * from internal_mark inner join subject on subject.sid=internal_mark.subjectid inner join internal_exam_name on internal_exam_name.intexmid=internal_mark.intextype inner join max_mark on max_mark.intextype=internal_mark.intexmid where internal_mark.studentid=" + dt.Rows[0][0].ToString() + " and internal_mark.intextype=2", GridView3); } else { Label4.Text = "No Second Internal Mark Added"; } //string str; //str = Session["login_id"].ToString(); DataTable dtq = db.exetable("select sid from student where lid=" + lid); db.fillgrid("select count('semid') as HOUR,attendance.date as DATE from attendance inner join absent on attendance.atid=absent.atid where absent.sid=" + dtq.Rows[0][0].ToString() + " group by attendance.date ", GridView4); object dt2q = db.execalar("select sum(k.p) as cnt from (select count(semid) as p,attendance.date from attendance inner join absent on attendance.atid=absent.atid where absent.sid=" + dtq.Rows[0][0].ToString() + " group by attendance.date ) k"); Label17.Text = dt2.ToString(); object dt3q = db.execalar("select count('date') as p from (select distinct date from attendance) dt"); Label18.Text = (Convert.ToInt32(dt3q) * 5).ToString(); Label19.Text = dt3q.ToString(); double totp = 0; if (Label17.Text != "") { int qu = Convert.ToInt32(Label17.Text) / 5; int re = Convert.ToInt32(Label17.Text) % 5; totp = Convert.ToInt32(dt3q); if (qu > 0) { totp = totp - qu; } if (re >= 3) { totp = totp - .5; } } Label20.Text = totp.ToString(); }
protected void Page_Load(object sender, EventArgs e) { string sql = "select * from subject inner join internal_mark on subject.sid=internal_mark.subjectid inner join max_mark on max_mark.intextype=internal_mark.intextype inner join internal_exam_name on internal_exam_name.intexmid=internal_mark.intexmid inner join semester on semester.semid=subject.semid"; db.fillgrid(sql, GridView1); }
protected void Page_Load(object sender, EventArgs e) { string sql = "select * from subject inner join internalmarks on subject.sid=internalmarks.subjectid inner join semester on semester.semid=subject.semid "; db.fillgrid(sql, GridView1); }