Hi

I have a combo box that is populated by an ole db connection to a ms access
table (Valuewave). The column that is used in the table is called waves.

The combo box is populated with the correct values, but when I refer to the
selectedItem value using WaveItem = cboWaves.SelectedItem.ToString();
MessageBox.Show(WaveItem);
I get System.Data.DataRowView. I have checked the spelling of the database
in the connection string, the table, and the column and they are correct.
How can I resolve this?

Doug

Sorry I should have copied my code:

OleDbCommand strCommand = new OleDbCommand(strSelect, myConnection);

OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(strCommand);

myConnection.Open();

DataSet DS = new DataSet();

myDataAdapter.Fill(DS);

cboWaves.DataSource = DS.Tables[0];

cboWaves.DisplayMember = "Valuewave";

cboWaves.ValueMember = "waves";

WaveItem = ((DataRowView)cboWaves.SelectedItem)["waves"].ToString();



I am changed the assignment of waveItem from my first post.



Doug





"Jerry" <(E-Mail Removed)> wrote in message
news:463d3054$0$15199$(E-Mail Removed)...
> Hi
>
> I have a combo box that is populated by an ole db connection to a ms
> access table (Valuewave). The column that is used in the table is called
> waves.
>
> The combo box is populated with the correct values, but when I refer to
> the selectedItem value using WaveItem = cboWaves.SelectedItem.ToString();
> MessageBox.Show(WaveItem);
> I get System.Data.DataRowView. I have checked the spelling of the
> database in the connection string, the table, and the column and they are
> correct. How can I resolve this?
>
> Doug
>
>
>
>

Jerry,
the Items in a databound ComboBox actually *are* DataRowViews. This short
code snippet may help:

DataRowView recRowView = cboName.SelectedItem;
DataRow recName = recRowView.Row;
lblAccountNum.Text = recName.AccountNum;
lblCompanyName.Text = recName.CompanyName;
--Peter
--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net




"Jerry" wrote:

> Hi
>
> I have a combo box that is populated by an ole db connection to a ms access
> table (Valuewave). The column that is used in the table is called waves.
>
> The combo box is populated with the correct values, but when I refer to the
> selectedItem value using WaveItem = cboWaves.SelectedItem.ToString();
> MessageBox.Show(WaveItem);
> I get System.Data.DataRowView. I have checked the spelling of the database
> in the connection string, the table, and the column and they are correct.
> How can I resolve this?
>
> Doug
>
>
>
>
>

"Jerry" <(E-Mail Removed)> wrote in message
news:463d35fa$0$23513$(E-Mail Removed)...
> Sorry I should have copied my code:
>
> OleDbCommand strCommand = new OleDbCommand(strSelect, myConnection);
>
> OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(strCommand);
>
> myConnection.Open();
>
> DataSet DS = new DataSet();
>
> myDataAdapter.Fill(DS);
>
> cboWaves.DataSource = DS.Tables[0];
>
> cboWaves.DisplayMember = "Valuewave";
>
> cboWaves.ValueMember = "waves";
>
> WaveItem = ((DataRowView)cboWaves.SelectedItem)["waves"].ToString();
>
>
>
> I am changed the assignment of waveItem from my first post.
>
>

That cbobox is being loaded from the DS.Tables[0] like it's view/object
collection.

The simplest way to deal with this is you're going to have to walk/read the
record set and do cboWaves.additem (record set field), until you reach the
end of the record set.