C#

aajignesh wrote:

In That the Data Will come is proper but Sir that Are Duplicate in to the combobox

public void FillCombo()
{
   <code>this.cmbParentLevel.DataSource = null;</code>
   DataTable dt;
   strinf sql = "select Level_Id, Level_Name from UserLevel"
              + " where Level_Name = 'Sales'";
   dt = qry.FillDataSet(sql).Tables[0];
   if (dt.Rows.Count > 1)
   {
      MessageBox.Show("Problem: More than one row");
   }
   AddChildCombo((int)dt.Rows[0]["Level_Id"], ref dt);
   <code>this.cmbParentLevel.Items.Clear(); </code>
   this.cmbParentLevel.DataSource = dt;
   this.cmbParentLevel.DisplayMember = "Level_Name";
   this.cmbParentLevel.ValueMember = "Level_Id";
}

aajignesh wrote:

My one Friend Sid that that's to fillcombo with use Recursion is not give Proper Result and also say that that it is not proper way.

aajignesh wrote:

So if U know to the Other Way to Fill Combo so Please Tell Me That's Request Please

aajignesh wrote:

If Sir U Have Any Other Idea to FillCombo so Plese Tell Me Please

private void Form2_Load(object sender, EventArgs e) {
   FillCombo();
}

private DataTable GetDataTable() {
   DataTable data = new DataTable();

   data.Columns.Add("Id", typeof(int));
   data.Columns.Add("ParentId", typeof(int));
   data.Columns.Add("LevelName", typeof(string));

   data.Rows.Add(2, null, "Account");
   data.Rows.Add(3, 2, "Perment");
   data.Rows.Add(4, 2, "Tempray");
   data.Rows.Add(11, null, "Sales");
   data.Rows.Add(12, 11, "tttttt");
   data.Rows.Add(13, 11, "pppp");
   data.Rows.Add(14, 12, "qqqqq");
   data.Rows.Add(15, 13, "jjjjj");
   data.Rows.Add(16, 15, "asd");
   data.Rows.Add(17, 16, "sasda");
   data.Rows.Add(20, 17, "fffff");
   data.Rows.Add(23, null, "Purchase");
   data.Rows.Add(28, 23, "Pur1");
   data.Rows.Add(30, 20, "qqqqqqq");
   data.Rows.Add(31, 14, "aaaa");
   data.Rows.Add(32, 15, "bbbbbbbb");
   data.Rows.Add(33, 32, "iiiiiii");
   data.Rows.Add(34, 3, "Company Employees");
   data.Rows.Add(35, 4, "Contract Base Employee");

   return data;
}

public void FillCombo() {
   DataTable dt = GetDataTable().Clone();
   DataRow startRow = GetDataTable().Select("LevelName = 'Sales'")[0];
   AddChildren((int)startRow["Id"], ref dt);
   this.cmbTest.DisplayMember = "LevelName";
   this.cmbTest.ValueMember = "Id";
   this.cmbTest.DataSource = dt;
}

private void AddChildren(int parentId, ref DataTable TableToFill) {
   DataRow[] children = GetDataTable().Select("ParentId = " + parentId.ToString());
   for ( int i = 0; i <= children.Length- 1; i++) {
      TableToFill.ImportRow(children[i]);
      AddChildren((int)children[i]["Id"], ref TableToFill);
   }
}

switch (checkBox1.CheckState)
{
    case CheckState.Checked:
        // do your thing
        break;
    case CheckState.Indeterminate:
        // do some other thing
        break;
    default: // Unchecked
        // do the Hokey Cokey
        break;
}

if (checkBox1.CheckState == CheckState.Checked)
{
    //
}
else if (checkBox1.CheckState == CheckState.Indeterminate)
{
    //
}
else
{
    //
}

Lodeclaw wrote:

Thank you for your help

khaled_0b wrote:

i have problem in this control
please help me