Combox selected value is showing system.Data row cannot convert error

Question

I fetched all the username in Combobox1 displaymember as username and Id as value member.

Now I enabled a groupbox having a textbox,3 combobox and update button when i select an item in Combobox1.considering the valuemember of combobox1 fetching particular user and trying to display those details in groupbox(textbox contains the username,3 combo boxes having department designation role details) .My Database table having foreign keys(deparment,designation and role).It returns only 3 combobox value members not the display memeber(Text).How can i link these tow so that upon selecteing username in Combobox1 the corresponding values should appear in textbox as well as 3 comboboxes.

here is my code:

     private void cmbBoxUpdateEmployee_SelectedIndexChanged_1(object sender, EventArgs e)
    {
          changecmbBoxValue();

    }     panelupdateEmployee.Visible = true;


    public void changecmbBoxValue()
    {

        try
        {
            textBoxUpdateEmployee.Enabled = true;
            cmbBoxUpdateEmpRoleID.Enabled = true;
            cmbBoxUpdateEmpDepartment.Enabled = true;
            cmbBoxUpdateEmpDesignation.Enabled = true;
            dbobj.Open();
            DataSet ds = new DataSet();
            if (!string.IsNullOrEmpty(cmbBoxUpdateEmployee.SelectedValue.ToString()))
            {
                string cmd = "select Name,RoleId,DepartmentId,DesignationId from tblEmployee where Name='" + cmbBoxUpdateEmployee.SelectedValue+ "'";

      //I get system.Datarow conversion not done error.
                ds = dbobj.ExecuteDataset(cmd);
                if ((ds.Tables[0].Rows.Count) > 0)
                {
                    textBoxUpdateEmployee.Text = Convert.ToString(ds.Tables[0].Rows[0][0].ToString());
                    cmbBoxUpdateEmpRoleID.SelectedIndex = Convert.ToInt32(ds.Tables[0].Rows[0][1].ToString());
                    cmbBoxUpdateEmpDepartment.SelectedIndex = Convert.ToInt32(ds.Tables[0].Rows[0][2].ToString());
                    cmbBoxUpdateEmpDesignation.SelectedIndex = Convert.ToInt32(ds.Tables[0].Rows[0][3].ToString());
                    lblupdatedelete.Text = " Update Successfully";
                    EmployeeUpdateInfo();
                    textBoxUpdateEmployee.Clear();
                }
            }              

        }
        catch (Exception ex)
        {
            MessageBox.Show("Error!!" + ex.Message);
        }
        finally
        {
            dbobj.Close();
        }


    }
  public void RoleData()
    {
        DataSet ds = new DataSet();
        string query = "select [Id],[Name] from tbl where IsDeleted=0";
        ds = dbobj.ExecuteDataset(query);
        cmbBoxUpdateRole.DataSource = ds.Tables["tablename"];
        cmbBoxUpdateRole.DisplayMember = "Name";
        cmbBoxUpdateRole.ValueMember = "Id";
        cmbBoxDeleteRole.DataSource = ds.Tables["tablename"];
        cmbBoxDeleteRole.DisplayMember = "Name";
        cmbBoxDeleteRole.ValueMember = "Id";

     }//role combobox..for department,designation also i did the same way to display in 3 comboboxes

How can i achieve this? any idea

You need to step thru the code it appears that on the line like this cmbBoxUpdateEmpRoleID.SelectedIndex what is the Value of that row when you step thru the code..? — MethodMan
Also if you have a GroupBox` how are you Iterating thru to get the Selected Items Index? I don't see any code for that — MethodMan

kida kida · Accepted Answer · 2013-04-05T18:16:20

I solved my own problem. I changed selectedIndex to selectedValue

cmbBoxUpdateEmpRoleID.SelectedValue = 
                             Convert.ToInt32(ds.Tables[0].Rows[0][1].ToString());
cmbBoxUpdateEmpDepartment.SelectedValue = 
                             Convert.ToInt32(ds.Tables[0].Rows[0][2].ToString());
cmbBoxUpdateEmpDesignation.SelectedValue = 
                             Convert.ToInt32(ds.Tables[0].Rows[o][3].Tostring());

I jut need to call the method changecmbvalue() in selectedValuechanged event. It works as expected.

Combox selected value is showing system.Data row cannot convert error

1 Answers