private void LoadUsers(String type) { String query = "SELECT DISTINCT id, name FROM tblUsers WHERE usertype = " + type + " and Active = 1"; DataSet dsStatus = dh.GetData(query, null, out status); if (dsStatus != null && dsStatus.Tables.Count > 0 && dsStatus.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsStatus.Tables[0].Rows) { SelectionValues sv = new SelectionValues { text = dr["name"].ToString(), value = dr["id"].ToString() }; try { cmbVals.Add(sv); } catch { } } } }
private void LoadStatus() { String query = "SELECT DISTINCT status FROM tblPMJob ORDER BY status"; DataSet dsStatus = dh.GetData(query, null, out status); if (dsStatus != null && dsStatus.Tables.Count > 0 && dsStatus.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsStatus.Tables[0].Rows) { SelectionValues sv = new SelectionValues { text = dr["status"].ToString(), value = dr["status"].ToString() }; try { cmbVals.Add(sv); } catch { } } } }
private void cmbSelector_SelectedIndexChanged(object sender, EventArgs e) { bs.Clear(); cmbVals.Clear(); cmbCriteria.SelectedIndexChanged -= cmbCriteria_SelectedIndexChanged; SelectionValues svTemp = new SelectionValues() { text = "Please select", value = "0" }; cmbVals.Add(svTemp); try { switch (cmbSelector.SelectedItem.ToString()) { case "Status": LoadStatus(); selectionType = 1; break; case "PM": LoadUsers("2"); selectionType = 2; break; case "PA": LoadUsers("4"); selectionType = 3; break; } cmbCriteria.DataSource = cmbVals; cmbCriteria.DisplayMember = "text"; cmbCriteria.ValueMember = "value"; cmbCriteria.Refresh(); } catch { } cmbCriteria.SelectedIndexChanged += cmbCriteria_SelectedIndexChanged; }