Unable to cast object of type 'System.String' to type 'System.Data.DataRowView'.

Question

2.00/5 (1 vote)

See more:

C#

I have ComboBox, populate with Database.. with Read Method..
string sql = "Select miscCode,miscDesc from miscMaster ";
              // sql = sql + "WHERE miscCategory='Hundai' ";
               sql = sql + "ORDER BY miscDesc";
               //cn.Open();
               cmd = new SqlCommand(sql, cn);
               dr = cmd.ExecuteReader();
               cmb_makeCode.Items.Clear();
               cmb_makeCode.Items.Add("-- Select --");
               while (dr.Read() != false)
               {
                   cmb_makeCode.ValueMember = dr[0].ToString();
                   cmb_makeCode.Items.Add(dr[1].ToString());
                   cmb_makeCode.DisplayMember = dr[0].ToString();
               }
               cn.Close();

But when I want to store the value of 'miscCode' into a string varibale in below code give an error: "Unable to cast object of type 'System.String' to type 'System.Data.DataRowView'."

C#

private void cmb_makeCode_SelectedIndexChanged(object sender, EventArgs e)
       {
          DataRow selectedDataRow = ((DataRowView)cmb_makeCode.SelectedItem).Row;
          string mkcd = selectedDataRow["miscCode"].ToString();

           MessageBox.Show(mkcd);
}

plz help me ...

Posted 7-Jul-12 8:43am

2pai

Add a Solution

Comments

Jim Jos 9-Jul-12 6:10am

When you are assigning to the combobox value you should assign the datarow rather than string.. then only you could cast it back to data row

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Santhosh Kumar Jayaraman · Answer 1 · 2012-07-07T08:51:00

Solution 1

The selecteditem of combobox will always be a string. Why do you want to make it as datarow. Make it as simple as below.

C#

private void cmb_makeCode_SelectedIndexChanged(object sender, EventArgs e)
       {
         
          string mkcd = cmb_makeCode.SelectedItem.ToString();

           MessageBox.Show(mkcd);
}

Posted 7-Jul-12 8:51am

Santhosh Kumar Jayaraman

Comments

2pai 8-Jul-12 12:41pm

Thanks But I want the DisplayMember value from combobox that i populate in previous code...
while (dr.Read() != false)
{
cmb_makeCode.ValueMember = dr[0].ToString();
cmb_makeCode.Items.Add(dr[1].ToString());
cmb_makeCode.DisplayMember = dr[0].ToString();
}

Santhosh Kumar Jayaraman · Answer 2 · 2012-07-08T23:00:00

Solution 2

Then try this.

C#

private void cmb_makeCode_SelectedIndexChanged(object sender, EventArgs e)
       {

          string mkcd = cmb_makeCode.Text.ToString();

           MessageBox.Show(mkcd);
}

Posted 8-Jul-12 23:00pm

Santhosh Kumar Jayaraman

Unable to cast object of type 'System.String' to type 'System.Data.DataRowView'.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Unable to cast object of type 'System.String' to type 'System.Data.DataRowView'.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us