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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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-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

Santhosh Kumar Jayaraman · Answer 2 · 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();
}