protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // load number of persons involved from DB and bind to gridview DataTable dt = bi.GetNoOfPersonsInvolved(); this.ddlNoOfPersons.DataSource = dt; this.ddlNoOfPersons.DataTextField = "FieldName"; this.ddlNoOfPersons.DataValueField = "FieldValue"; this.ddlNoOfPersons.DataBind(); this.ddlNoOfPersons.SelectedIndex = 0; dt.Clear(); // load lab kits from db and bind to gridview dt = bi.GetLabKits(); this.ddLabKit.DataSource = dt; this.ddLabKit.DataBind(); string firstLabKitID = dt.Rows[0]["FieldValue"].ToString(); dt.Clear(); // load loci for the lab kit from DB and bind to gridview dt = bi.GetLocus(Guid.Parse(firstLabKitID)); this.ddlLocus.DataSource = dt; DataRow row = dt.NewRow(); row["FieldName"] = DBNull.Value; row["FieldValue"] = DBNull.Value; dt.Rows.Add(row); this.ddlLocus.DataTextField = "FieldName"; this.ddlLocus.DataValueField = "FieldValue"; this.ddlLocus.DataBind(); this.ddlLocus.Text = ""; dt.Clear(); // set some defaults this.ddlDropOutType.Text = ""; this.ddlDeducible.Text = Convert.ToString("Yes", CultureInfo.CurrentCulture); this.txtDropOutOption.Text = Convert.ToString("6.25 pg", CultureInfo.CurrentCulture); // get dropout rates for page defaults from DB and databind to gridview dt = ReadDropoutRate(this.txtDropOutOption.Text, Convert.ToInt16(this.ddlNoOfPersons.Text, CultureInfo.CurrentCulture), this.ddlDeducible.Text, firstLabKitID); this.gvDropOut.DataSource = dt; this.gvDropOut.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // get options for number of persons involved from the database and bind to our dropdown DataTable dt = bi.GetNoOfPersonsInvolved(); this.ddlNoOfPersons.DataSource = dt; DataRow row = dt.NewRow(); row["FieldName"] = DBNull.Value; row["FieldValue"] = DBNull.Value; dt.Rows.Add(row); this.ddlNoOfPersons.DataTextField = "FieldName"; this.ddlNoOfPersons.DataValueField = "FieldValue"; this.ddlNoOfPersons.DataBind(); this.ddlNoOfPersons.Text = ""; dt.Clear(); // get dropout rate types from the database and bind to our dropdown (PHET1, PHET2, PHOM) dt = bi.GetDropOutTypes(); this.ddlDropOutType.DataSource = dt; row = dt.NewRow(); row["FieldName"] = DBNull.Value; row["FieldValue"] = DBNull.Value; dt.Rows.Add(row); this.ddlDropOutType.DataTextField = "FieldName"; this.ddlDropOutType.DataValueField = "FieldValue"; this.ddlDropOutType.DataBind(); this.ddlDropOutType.Text = ""; dt.Clear(); // get drop out options from the database and bind to our dropdown // these are the rate points, so 6.25pg, 12.5pg, 25pg, etc. and also refered to as DNA template amount in the UI dt = bi.getDropOutOptions(); this.ddlDropOutOption.DataSource = dt; row = dt.NewRow(); row["FieldName"] = DBNull.Value; row["FieldValue"] = DBNull.Value; dt.Rows.Add(row); this.ddlDropOutOption.DataTextField = "FieldName"; this.ddlDropOutOption.DataValueField = "FieldValue"; this.ddlDropOutOption.DataBind(); this.ddlDropOutOption.Text = ""; dt.Clear(); // get the labk kits from the database and bind to our dropdown dt = bi.GetLabKits(); this.gvLabKits.DataSource = dt; this.gvLabKits.DataBind(); dt.Clear(); // get the list of loci from the database and bind to our dropdown dt = bi.GetLocus(Guid.Empty); this.ddlLocus.DataSource = dt; row = dt.NewRow(); row["FieldName"] = DBNull.Value; row["FieldValue"] = DBNull.Value; dt.Rows.Add(row); this.ddlLocus.DataTextField = "FieldName"; this.ddlLocus.DataValueField = "FieldValue"; this.ddlLocus.DataBind(); this.ddlLocus.Text = ""; this.ddlDeducible.Text = ""; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = bi.GetNoOfPersonsInvolved(); this.ddlNoOfPersons.DataSource = dt; DataRow row = dt.NewRow(); row["FieldName"] = DBNull.Value; row["FieldValue"] = DBNull.Value; dt.Rows.Add(row); this.ddlNoOfPersons.DataTextField = "FieldName"; this.ddlNoOfPersons.DataValueField = "FieldValue"; this.ddlNoOfPersons.DataBind(); this.ddlNoOfPersons.Text = ""; dt.Clear(); dt = bi.GetDropOutTypes(); this.ddlDropOutType.DataSource = dt; row = dt.NewRow(); row["FieldName"] = DBNull.Value; row["FieldValue"] = DBNull.Value; dt.Rows.Add(row); this.ddlDropOutType.DataTextField = "FieldName"; this.ddlDropOutType.DataValueField = "FieldValue"; this.ddlDropOutType.DataBind(); this.ddlDropOutType.Text = ""; dt.Clear(); dt = bi.getDropOutOptions(); this.ddlDropOutOption.DataSource = dt; row = dt.NewRow(); row["FieldName"] = DBNull.Value; row["FieldValue"] = DBNull.Value; dt.Rows.Add(row); this.ddlDropOutOption.DataTextField = "FieldName"; this.ddlDropOutOption.DataValueField = "FieldValue"; this.ddlDropOutOption.DataBind(); this.ddlDropOutOption.Text = ""; dt.Clear(); dt = bi.GetLocus(Guid.Empty); this.ddlLocus.DataSource = dt; row = dt.NewRow(); row["FieldName"] = DBNull.Value; row["FieldValue"] = DBNull.Value; dt.Rows.Add(row); this.ddlLocus.DataTextField = "FieldName"; this.ddlLocus.DataValueField = "FieldValue"; this.ddlLocus.DataBind(); this.ddlLocus.Text = ""; this.ddlDeducible.Text = ""; this.ddlDegradationType.Text = ""; dt.Clear(); dt = bi.GetDegradedDropOutData(); this.gvDropOut.DataSource = dt; this.gvDropOut.DataBind(); } }