protected void Page_Load(object sender, EventArgs e) { SqlDataReader sdr; using ( DataAccess da = new DataAccess()) { if (User.Identity.IsAuthenticated) sdr =(SqlDataReader) da.ExecuteSPForDataReader("Sel_VKLs", new SqlParameter[] {Parameters.Int("@userId", Member.CurrentUser)}); else sdr = (SqlDataReader) da.ExecuteSPForDataReader("Sel_VKLs", null); this.dsVkl.Text = "<script>\n" + JS.CreateObject(sdr, "vkls", true) + "</script>"; sdr.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Member.SessionBegun) Response.Redirect("~/signin.aspx"); SqlDataReader sdr; using (DataAccess da = new DataAccess()) { sdr = (SqlDataReader)da.ExecuteSPForDataReader("Sel_VKLs", new SqlParameter[] { Parameters.Int("@userId", Member.CurrentUser) }); this.ClientScript.RegisterClientScriptBlock(GetType(), "VKLs", "<script>\n" + JS.CreateObject(sdr, "vkls", true) + "</script>", false); sdr.Close(); } if (!IsPostBack) { int vid = 0; if (Request.QueryString["vid"] != null && int.TryParse(Request.QueryString["vid"], out vid)) { EditVKL(vid); } else { DataAccess da = new DataAccess(); vklLang.DataSource = da.ExecuteSelectForDataTable("SELECT * FROM [Languages] ORDER BY [Language]").DefaultView; vklLang.DataBind(); vklLang.Items.Insert(0, new ListItem {Value=string.Empty,Text="--Select--"}); PopulateInscripts(); Wizard.SetActiveView(step1); Act = Activities.Creating; } } }