Could not bind to the new display member error

[Dica]

i've got a table in my dataSet that looks like this:

<tblTasks>

<taskID>0</taskID>

<projectID>0</projectID>

<summary>-- Select A Task --</summary>

</tblTasks>

<tblTasks>

<taskID>662</taskID>

<projectID>19</projectID>

<summary>Addition - Add Update to MeetComp</summary>

</tblTasks>

when trying to bind to my comboBox as follows:

cboTasks.DataSource = oDataSet.Tables["tblTasks"].Select(null, "taskID",
DataViewRowState.CurrentRows);

cboTasks.DisplayMember = "summary";

cboTasks.ValueMember = "taskID";

i get the "Could not bind ot the new display member" error. any ideas why?

tks

[Nicholas Paldino [.NET/C# MVP]]

Dica,

In this, you are binding to an array of data rows. I don't think that
this is a good idea.

Try creating a new DataView and binding to it, like this:

// The data view.
DataView view = new DataView(oDataSet.Tables["tblTasks"], null, "taskID",
DataViewRowState.CurrentRows);

// Set the display member before setting the data source.
cboTasks.DisplayMember = "summary";

// Set the data source to the data view.
cboTasks.DataSource = view;

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Dica" <ge*****@hotmail.com> wrote in message
news:IY******************************@rogers.com.. .

i've got a table in my dataSet that looks like this:

<tblTasks>

<taskID>0</taskID>

<projectID>0</projectID>

<summary>-- Select A Task --</summary>

</tblTasks>

<tblTasks>

<taskID>662</taskID>

<projectID>19</projectID>

<summary>Addition - Add Update to MeetComp</summary>

</tblTasks>

when trying to bind to my comboBox as follows:

cboTasks.DataSource = oDataSet.Tables["tblTasks"].Select(null, "taskID",
DataViewRowState.CurrentRows);

cboTasks.DisplayMember = "summary";

cboTasks.ValueMember = "taskID";

i get the "Could not bind ot the new display member" error. any ideas why?

tks

[Dica]

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:u1**************@TK2MSFTNGP12.phx.gbl...

Dica,

In this, you are binding to an array of data rows. I don't think that
this is a good idea.

Try creating a new DataView and binding to it, like this:

// The data view.
DataView view = new DataView(oDataSet.Tables["tblTasks"], null, "taskID",
DataViewRowState.CurrentRows);

// Set the display member before setting the data source.
cboTasks.DisplayMember = "summary";

// Set the data source to the data view.
cboTasks.DataSource = view;
works perfect. tks.

however, i'm curious, why set the display member prior to setting the
dataSource?

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Dica" <ge*****@hotmail.com> wrote in message
news:IY******************************@rogers.com.. .

i've got a table in my dataSet that looks like this:

<tblTasks>

<taskID>0</taskID>

<projectID>0</projectID>

<summary>-- Select A Task --</summary>

</tblTasks>

<tblTasks>

<taskID>662</taskID>

<projectID>19</projectID>

<summary>Addition - Add Update to MeetComp</summary>

</tblTasks>

when trying to bind to my comboBox as follows:

cboTasks.DataSource = oDataSet.Tables["tblTasks"].Select(null, "taskID",
DataViewRowState.CurrentRows);

cboTasks.DisplayMember = "summary";

cboTasks.ValueMember = "taskID";

i get the "Could not bind ot the new display member" error. any ideas why?
tks