protected void ddlrpt_change(object sender, EventArgs e) { DataSet ds = Reportgenrator.Getrpt("select * from tbl_rpt_details where rptid=" + ddlrpt.SelectedValue); if (ds.Tables[0].Rows.Count > 0) { hfdquery.Value = ds.Tables[0].Rows[0]["query"].ToString(); hfdfltrs.Value = ds.Tables[0].Rows[0]["fltrs"].ToString(); hfdcols.Value = ds.Tables[0].Rows[0]["ordby"].ToString(); } ScriptManager.RegisterStartupScript(Page, GetType(), "js", "afterbind()", true); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ddlrpt.DataSource = Reportgenrator.Getrpt("select rptname,rptid from tbl_rpt_details where rpttype like 'L' order by rptname"); ddlrpt.DataTextField = "rptname"; ddlrpt.DataValueField = "rptid"; ddlrpt.DataBind(); if (ddlrpt.SelectedIndex != -1) { ddlrpt_change(null, null); } } }
protected void Page_Load(object sender, EventArgs e) { var count = Request.QueryString.Count; if (!IsPostBack) { string pid = "0"; if (Request.QueryString["pid"] != null) { pid = Request.QueryString["pid"].ToString(); } if (Request.QueryString.Count == 3 || (Request.QueryString.Count == 4 && pid == "0")) { tbl_print obj = Reportgenrator.Get_printbyid(Request.QueryString[1].ToString()); string query = "select * from [" + obj.Vwname + "] where [" + obj.fltrcol + "]='" + Request.QueryString[2].ToString() + "'"; DataSet ds = Reportgenrator.Getrpt(query); if (ds.Tables[0].Rows.Count > 0) { dr = ds.Tables[0].Rows[0]; } } else if (pid != "0") { tbl_print obj = Reportgenrator.Get_printbyid(Request.QueryString[1].ToString()); string query = "select * from [" + obj.Vwname + "] where [" + obj.fltrcol + "]='" + Request.QueryString[2].ToString() + "' and perid=" + Request.QueryString["pid"].ToString(); DataSet ds = Reportgenrator.Getrpt(query); if (ds.Tables[0].Rows.Count > 0) { dr = ds.Tables[0].Rows[0]; } } else if (Request.QueryString.Count == 4) { tbl_print obj = Reportgenrator.Get_printbyid(Request.QueryString[1].ToString()); string query = "select * from [" + obj.Vwname + "] where [" + obj.fltrcol + "]='" + Request.QueryString[2].ToString() + "'"; DataSet ds = Reportgenrator.Getrpt(query); if (ds.Tables[0].Rows.Count > 0) { dr = ds.Tables[0].Rows[0]; } DataList dtl = (DataList)this.Page.FindControl("dtlstresp"); dtl.DataSource = Getrespondents(); dtl.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ddlrpt.DataSource = Reportgenrator.Getrpt("select rptname,rptid from tbl_rpt_details where rpttype like 'C' order by rptname"); ddlrpt.DataTextField = "rptname"; ddlrpt.DataValueField = "rptid"; ddlrpt.DataBind(); if (ddlrpt.SelectedIndex != -1) { ddlrpt_change(null, null); } chk_lictypes.DataSource = Reportgenrator.GetLicensetype(); chk_lictypes.DataTextField = "License_Type"; chk_lictypes.DataValueField = "LicenseType_ID"; chk_lictypes.DataBind(); CheckBoxList_SelectedIndexChanged1(null, null); } }