protected void Page_Load(object sender, EventArgs e) { DivDT = DivAdapter.SelectDiv(); GridView1.DataSource = DivDT; GridView1.DataBind(); lblstd.Text = GridView1.Rows.Count.ToString(); }
protected void drpstd_SelectedIndexChanged(object sender, EventArgs e) { DivDT = DivAdapter.Select_By_STD(drpstd.SelectedItem.Text); drpdiv.DataSource = DivDT; drpdiv.DataTextField = "DivName"; drpdiv.DataValueField = "DID"; drpdiv.DataBind(); drpdiv.Items.Insert(0, "SELECT"); }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { StaffDT = StaffAdapter.Select_UNAME(Session["uname"].ToString()); lblstd.Text = StaffDT.Rows[0]["StdName"].ToString(); DivDT = DivAdapter.Select_By_STD(StaffDT.Rows[0]["StdName"].ToString()); drpdiv.DataSource = DivDT; drpdiv.DataTextField = "DivName"; drpdiv.DataValueField = "DID"; drpdiv.DataBind(); drpdiv.Items.Insert(0, "SELECT"); drpstudent.Items.Insert(0, "SELECT"); } }
protected void btnstuadd_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { FileUpload1.SaveAs(Server.MapPath("~/Studentimg/" + FileUpload1.FileName)); DateTime bdate = Convert.ToDateTime(drpdd.SelectedItem.Text + " " + drpmm.SelectedItem.Text + " " + drpyyyy.SelectedItem.Text); StuAdapter.Insert(txtroll.Text, txtname.Text, lblstd.Text, drpdiv.SelectedItem.Text, txtemail.Text, txtmobi.Text, bdate.GetDateTimeFormats()[8].ToString(), "~/Studentimg/" + FileUpload1.FileName, txtadd.Text, txtcity.Text, txtpin.Text, txtuname.Text, txtpass.Text); lblmsg.Text = "Student Added."; txtname.Text = ""; txtadd.Text = ""; txtcity.Text = ""; txtemail.Text = ""; txtmobi.Text = ""; txtpass.Text = ""; txtpin.Text = ""; txtuname.Text = ""; txtcpass.Text = ""; drpdd.SelectedIndex = 0; drpmm.SelectedIndex = 0; drpyyyy.SelectedIndex = 0; DivDT = DivAdapter.SELECT_BY_ID(Convert.ToInt32(drpdiv.SelectedValue)); lblcnt.Text = "Total Seat = " + DivDT.Rows[0]["Seat"].ToString(); MultiView1.ActiveViewIndex = 0; StuDT = StuAdapter.Select_By_STD_DIV(lblstd.Text, drpdiv.SelectedItem.Text); int rstu = Convert.ToInt32(DivDT.Rows[0]["Seat"].ToString()) - Convert.ToInt32(StuDT.Rows.Count.ToString()); lblstudent.Text = "Total Admitted =" + StuDT.Rows.Count.ToString() + " , Remaining Student = " + rstu; string stddd = lblstd.Text.Substring(0, 1); int rno = Convert.ToInt32(StuDT.Rows.Count.ToString()) + 1; if (rno.ToString().Length < 2) { string newrno = "0" + rno.ToString(); txtroll.Text = stddd + drpdiv.SelectedItem.Text + newrno; } else { txtroll.Text = stddd + drpdiv.SelectedItem.Text + rno; } } }
protected void Button7_Click(object sender, EventArgs e) { DivDT = DivAdapter.SELECT_BY_ID(Convert.ToInt32(drpdiv.SelectedValue)); lblcnt.Text = "Total Seat = " + DivDT.Rows[0]["Seat"].ToString(); MultiView1.ActiveViewIndex = 0; StuDT = StuAdapter.Select_By_STD_DIV(lblstd.Text, drpdiv.SelectedItem.Text); int rstu = Convert.ToInt32(DivDT.Rows[0]["Seat"].ToString()) - Convert.ToInt32(StuDT.Rows.Count.ToString()); lblstudent.Text = "Total Admitted =" + StuDT.Rows.Count.ToString() + " , Remaining Student = " + rstu; string stddd = lblstd.Text.Substring(0, 1); int rno = Convert.ToInt32(StuDT.Rows.Count.ToString()) + 1; if (rno.ToString().Length < 2) { string newrno = "0" + rno.ToString(); txtroll.Text = stddd + drpdiv.SelectedItem.Text + newrno; } else { txtroll.Text = stddd + drpdiv.SelectedItem.Text + rno; } }
private void BindGridiv() { DivDT = DivAdapter.SelectDiv(); GvDiv.DataSource = DivDT; GvDiv.DataBind(); }