why it doesn't work for me??? 1

[rahmanjan]

Hi all,

I have bound my combobox to database using Dataset. as:

DataSet ds=new DataSet();
ds=data.ReturnAll(sqlstr);
cboCategory.DataSource=ds.Tables[0];
cboCategory.ValueMember="CategoryID";
cboCategory.DisplayMember="Category";

It is filling the combox Okay.

When i am trying to get an item i do as follow:

Object selectedItem = cboCategory.SelectedItem;
MessageBox.Show(selectedItem.ToString());

It returns System.Data.RowView ??? I don't know why? My questions:

1-How can i get the text of the combox?
2-How can i get the index of the item bound in the combox?

regards

 

[Korach]

I saw a code like this in the help, but there the combo box was bounded to strings, so the function ToString knows what to do, but in your case, the system doesn't know how to make this Object a string.
For example:

namespace ns
{
struct st
{
int a;
}
}

if you call st.ToString() which was inherited from class Object, you will see "ns.st" which is the object type.
solution - override the ToString:

struct st
{
int a;
string Tostring()
{
return Convert.ToString(a);
}
}

you can inherit the System.Data.RowView class to your defined class abd override ToString.

 

[rahmanjan]

sorry,

I don't have a class or somehting here. I have the code

Object selectedItem = cboCategory.SelectedItem;
MessageBox.Show(selectedItem.ToString());

under the click event of the combobox.

The question here is that the combox shows a list of 'stirngs' and i select one. Why it should be different in VB.net and ASP.net and C#.net???

regards

 

[Craig0201]

The selected item is an object, not the string displayed. The .ToString is returning correctly as it doesn't know what particular item to return and thus is returning the type. Try casting a textbox to object and seeing what that returns in the ToString method.


You are after the string contained within the bound column within that object. What you need to do is extract it. As you are using a bound datatable, you can use something along the lines of the following

System.Data.Datarow selectedItem = cboCategory.SelectedItem;
MessageBox.Show(selectedItem.Item("NameOfBoundColumn));

Craig

PS Like the irony of you using my post having been told it was VB......apologies accepted on a postcard.

 

[rahmanjan]

Hi craig,

Thanks very much mate. Though ur code raises the error but u deserve the *star*

should have been:

System.Data.Datarow selectedItem = (System.Data.Datarow) cboCategory.SelectedItem;

regards