예제 #1
0
 protected void DropDownupdatecourse_SelectedIndexChanged(object sender, EventArgs e)
 {
     hfcount.Value = "Changed";
     if (DropDownSubject.SelectedValue != "--Select--")
     {
         panelsubject.Visible = true;
         string         co2        = "Select Sname from Subjects where Cid =(Select Cid from Course where Cname='" + DropDownupdatecourse.SelectedValue + "')";
         SqlDataAdapter d2         = new SqlDataAdapter(co2, con);
         DataSet        myDataSet2 = new DataSet();
         d2.Fill(myDataSet2, "Subjects");
         DropDownupdateSubject.DataSource = myDataSet2;
         DropDownupdateSubject.DataBind();
         DropDownupdateSubject.DataTextField  = "Sname";
         DropDownupdateSubject.DataValueField = "Sname";
         DropDownupdateSubject.DataBind();
     }
 }
예제 #2
0
 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     if (e.CommandName == "upd")
     {
         ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "showModal();", true);
         int            id         = Convert.ToInt16(e.CommandArgument.ToString());
         string         co2        = "Select Sname from Subjects where Cid =(Select Cid from Course where Cname='" + DropDownupdatecourse.SelectedValue + "')";
         SqlDataAdapter d2         = new SqlDataAdapter(co2, con);
         DataSet        myDataSet2 = new DataSet();
         d2.Fill(myDataSet2, "Subjects");
         DropDownupdateSubject.DataSource = myDataSet2;
         DropDownupdateSubject.DataBind();
         DropDownupdateSubject.DataTextField  = "Sname";
         DropDownupdateSubject.DataValueField = "Sname";
         DropDownupdateSubject.DataBind();
     }
 }