protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
int selectedid = Convert.ToInt32(ListBox1.SelectedValue);
//var st = from s in db.Students
// where s.Id == selectedid
// select s;
catg st = db.catgs.First(s => s.cat_id == selectedid);
StudName.Text = st.cat_name;
StudAttend.Text = st.s_attend.ToString();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
int selectedid = Convert.ToInt32(ListBox1.SelectedValue);
catg st = db.catgs.First(s => s.cat_id == selectedid);
st.cat_name = StudName.Text;
st.s_attend = Convert.ToInt32(StudAttend.Text);
db.SubmitChanges();
}
StudName.Text = StudAttend.Text = "";
UpdateGrid();
}
protected void btnDel_Click(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
int selectedid = Convert.ToInt32(ListBox1.SelectedValue);
catg st = db.catgs.First(s => s.cat_id == selectedid);
db.catgs.DeleteOnSubmit(st);
db.SubmitChanges();
}
StudName.Text = StudEmail.Text = StudDOB.Text = StudAddress.Text = StudGender.Text = StudSem.Text = "";
UpdateGrid();
btnAdd.Visible = true;
btnUp.Visible = false;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
catg cg = new catg()
{
cat_name = StudName.Text,
s_address = StudAddress.Text,
s_dob = StudDOB.Text,
s_gender = StudGender.Text,
s_email = StudEmail.Text,
s_sem = Convert.ToInt32(StudSem.Text)
};
db.catgs.InsertOnSubmit(cg);
db.SubmitChanges();
}
StudEmail.Text = StudAddress.Text = StudName.Text = StudGender.Text = StudSem.Text = StudDOB.Text = "";
UpdateGrid();
}
protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
{
using (var db = new LogUserDataContext())
{
int selectedid = Convert.ToInt32(ListBox1.SelectedValue);
//var st = from s in db.Students
// where s.Id == selectedid
// select s;
catg st = db.catgs.First(s => s.cat_id == selectedid);
StudName.Text = st.cat_name;
StudAddress.Text = st.s_address;
StudDOB.Text = st.s_dob;
StudEmail.Text = st.s_email;
StudGender.Text = st.s_gender;
StudSem.Text = st.s_sem.ToString();
btnAdd.Visible = false;
btnUp.Visible = true;
}
}
