protected void Page_Load(object sender, EventArgs e) { tMember mb = Session[CDKey.LOGINUSER] as tMember; if (Session[CDKey.LOGINUSER] == null) { Response.Redirect("Login.aspx"); } else { tMember member = (tMember)Session[CDKey.LOGINUSER]; id = mb.fIdMember; } if (!IsPostBack) { var table = from m in db.tMember where m.fIdMember == id select m; foreach (tMember o in table) { lblUserName.Text = o.fName; imgPic.ImageUrl = o.fPhoto; } var tb1 = from s1 in db.tServicesClass select new { fname = s1.fName, fser = s1.fIdServicesClass }; foreach (var o in tb1) { Dw1.DataTextField = "fname"; Dw1.DataValueField = "fser"; } Dw1.DataSource = tb1; Dw1.DataBind(); var tb2 = from s2 in db.tServicesSubClass where s2.fIdServicesClass == Convert.ToInt32(Dw1.SelectedItem.Value) select new { fname = s2.fName, fser = s2.fIdServicesSubClass }; foreach (var o in tb2) { Dw2.DataTextField = "fname"; Dw2.DataValueField = "fser"; } Dw2.DataSource = tb2; Dw2.DataBind(); } }
protected void Dw1_SelectedIndexChanged(object sender, EventArgs e) { var tb2 = from s2 in db.tServicesSubClass where s2.fIdServicesClass == Convert.ToInt32(Dw1.SelectedItem.Value) select new { fname = s2.fName, fser = s2.fIdServicesSubClass }; foreach (var o in tb2) { Dw2.DataTextField = "fname"; Dw2.DataValueField = "fser"; } Dw2.DataSource = tb2; Dw2.DataBind(); }