protected void Load_coderpair_list(int measureID) { if (print_jminfo) { jminfo.Text += " ==>Load_coderpair_list..<br/>"; } int mode = 1; if (chk_ShowNA.Checked) { mode = 0; } //DropDownList ddl = (DropDownList)UpdatePanel1.FindControl("ddlMeasure"); //string sqlcode = "exec spRELv2_GET_RelTracking_by_measure " + _content_studyID.ToString() + ", " + ddl.SelectedValue.ToString(); string sqlcode = "exec spRELv2_GET_RelTracking_CoderPairs_by_measure " + _content_studyID.ToString() + ", " + measureID.ToString() + ", " + mode.ToString(); //Coder pairs SqlCommand cmd = new SqlCommand(); cmd.Connection = oConnData; cmd.CommandType = CommandType.Text; cmd.CommandText = sqlcode; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); //Persist the table in the Session object. Session["dt_coder_pairs_list"] = dt; //Bind the GridView control to the data source. GridView gv_coderpairs_list = (GridView)UpdatePanel_coderpairs_list.FindControl("gv_coderpairs_list"); gv_coderpairs_list.DataSource = Session["dt_coder_pairs_list"]; //gv_coderpairs_list.DataSource = dt_coder_pairs_list; gv_coderpairs_list.DataBind(); UpdatePanel_coderpairs_list.Visible = true; UpdatePanel_coderpairs_list.Update(); }
protected void btnShowAll_Click(object sender, EventArgs e) { if (print_jminfo) { jminfo.Text += "btnShowAll_Click..<br/>"; } ////////////////////////////////////////////////// //Show all rows in the main gridview foreach (GridViewRow row in gv_coderpairs_list.Rows) { row.Visible = true; } UpdatePanel_coderpairs_list.Update(); UpdatePanel_coderpair_single.Visible = false; UpdatePanel_coderpair_single.Update(); }
protected void Load_coderpair_list(int measureID) { if (print_jminfo) { jminfo.Text += " ==>Load_coderpair_list..<br/>"; } //Show the Measure Name SQL_utils sql1 = new SQL_utils("backend"); string sqlcode_measname = "select measname from uwautism_research_backend..tblMeasure where measureID = " + measureID.ToString(); string measname = sql1.StringScalar_from_SQLstring(sqlcode_measname); sql1.Close(); //lblPctCoded.Text = ddl.SelectedItem + "<br/>" + x; lblMeasName.Text = measname; int mode = 1; if (chk_ShowNA.Checked) { mode = 0; } string grps_csv = utilSelect2.getselected_CSVval(selGroups); //DropDownList ddl = (DropDownList)UpdatePanel1.FindControl("ddlMeasure"); //string sqlcode = "exec spRELv2_GET_RelTracking_by_measure " + _content_studyID.ToString() + ", " + ddl.SelectedValue.ToString(); string sqlcode = ""; if (Request.QueryString["coderpair"] != null) { sqlcode = "exec spRELv2_GET_RelTracking_CoderPairs_by_measure " + Master.Master_studyID.ToString() + ", " + measureID.ToString() + ", " + mode.ToString() + "," + Request.QueryString["coderpair"] + ",'" + grps_csv + "'"; } else { sqlcode = "exec spRELv2_GET_RelTracking_CoderPairs_by_measure " + Master.Master_studyID.ToString() + ", " + measureID.ToString() + ", " + mode.ToString() + ",0,0,0,'" + grps_csv + "'"; } //Coder pairs //SqlCommand cmd = new SqlCommand(); //cmd.Connection = oConnData; //cmd.CommandType = CommandType.Text; //cmd.CommandText = sqlcode; //SqlDataAdapter da = new SqlDataAdapter(cmd); //DataTable dt = new DataTable(); //da.Fill(dt); SQL_utils sql = new SQL_utils("data"); DataTable dt = sql.DataTable_from_SQLstring(sqlcode); //Persist the table in the Session object. Session["dt_coder_pairs_list"] = dt; //Bind the GridView control to the data source. GridView gv_coderpairs_list = (GridView)UpdatePanel_coderpairs_list.FindControl("gv_coderpairs_list"); gv_coderpairs_list.DataSource = Session["dt_coder_pairs_list"]; //gv_coderpairs_list.DataSource = dt_coder_pairs_list; gv_coderpairs_list.DataBind(); UpdatePanel_coderpairs_list.Visible = true; UpdatePanel_coderpairs_list.Update(); sql.Close(); }