Link to home
Start Free TrialLog in
Avatar of dotnet0824
dotnet0824

asked on

Winform comboBox returns dataRowView

Hi,
I have a dataset bound to comboBox1  with records.
In a certain scenario I have to reload the dataset with some other data if combo2 is selected.

So When combo2 is selected I set the bindings off for the comboBox1 and reload a fresh dataset again.
In the selected change event I try to get the student_id when a name is selected. but it returns system.data.RowView


Its bound for the first time like this
this.combobox1.DataSource = _ds.Tables[0];
this.combobox1.DisplayMember = "Student_name";
this.combobox1.ValueMember = "student_id";
this.combobox1.SelectedIndex = -1;
this.combobox1.SelectedIndexChanged += new System.EventHandlerthis.combobox1_SelectedIndexChanged);
this.combobox1.SelectedIndex = 0;

Now when Combo2 is selected and combobox1 is clicked IN CLICK EVENT OF  of comboBox1

I set the bindings off and bind again in the above way to another dataset as It has to be done on fly (ie when combo2 is selected Combo1 has to load some other data)
 

In the selected change event I try to get the student_ID but it returns data.row.dataviewrow

 
        private void Combobo1_SelectedIndexChanged(object sender, EventArgs e)
        {

         if ( combobox1.SelectedIndex > 0 || combobox1.selectedindex !=-1)    
            {    

                 // this.txtStudentID.Text = combobox1.SelectedItem.ToString();
                MessageBox.Show(combobox1.SelectedItem.ToString());
Avatar of mac-will
mac-will
Flag of Canada image

Because you are binding to a DataTable each selection is in fact a DataRow.

This is not a problem you can just get what you are looking for like this:



DataRow mRow = (DataRow)combobox1.SelectedItem;
this.txtStudentID.Text = (String)   mRow["student_ID"];


Hope this helps.

MAC
can you please do the following and try
the reason is that before you supply the data source to databind you need to tell that from the data source which column will be the display member and which one will be the value member

this.combobox1.isplayMember = "Student_name";
this.combobox1.ValueMember = "student_id";
this.combobox1.DataSource = _ds.Tables[0];
Avatar of dotnet0824
dotnet0824

ASKER

i have already done that in my posting above.
DataRow mRow = (DataRow)combobox1.SelectedItem;
this.txtStudentID.Text = (String)   mRow["student_ID"];

It says unable to cast DataRowView to DataRow
ASKER CERTIFIED SOLUTION
Avatar of Snarf0001
Snarf0001
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ragi007, though agree on the .SelectedValue as i already posted above, .SelectedText is misleading, and returns any text that the user has highlighted.

.Text will return the actual displayed text of the selected item.