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