comboBox displays bound data out of order

[Dica]

i've got a dataSet that looks like the following:

<tblTasks>

<id>0</id>

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

</tblTasks>

<tblTasks>

<id>713</id>

<summary>resear ch</summary>

</tblTasks>

<tblTasks>

<id>717</id>

<summary>Othe r - time estimation</summary>

</tblTasks>

i've bound the dataSet to my comboBox as follows:

cboTasks.DataSo urce = null;

cboTasks.Items. Clear();

cboTasks.DataSo urce = oDataSet;

cboTasks.Displa yMember = "tblTasks.summa ry";

cboTasks.ValueM ember = "tblTasks.i d";

but the "-- Select Task --" option is showin up last. any idea why or how to
fix?

[Lars Behrmann]

Hi Dica,

you can set the DefaultView of your DataTable
as DataSource and set the Sort property of the
DefaultView to ascending. You should also set
your id column as primary key. Otherwise it could
be that the sorting won't work.

.....DataSource = oDataSet.Tables["tblTasks"].DefaultView.So rt =
"ascending" ;

Cheers
Lars Behrmann

_______________ __
Nothing is impossible. UML is the key for all your problems.
AODL - Make your .net apps OpenOffice ready
http://aodl.sourceforge.net/

Dica schrieb:

i've got a dataSet that looks like the following:

<tblTasks>

<id>0</id>

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

</tblTasks>

<tblTasks>

<id>713</id>

<summary>resear ch</summary>

</tblTasks>

<tblTasks>

<id>717</id>

<summary>Othe r - time estimation</summary>

</tblTasks>

i've bound the dataSet to my comboBox as follows:

cboTasks.DataSo urce = null;

cboTasks.Items. Clear();

cboTasks.DataSo urce = oDataSet;

cboTasks.Displa yMember = "tblTasks.summa ry";

cboTasks.ValueM ember = "tblTasks.i d";

but the "-- Select Task --" option is showin up last. any idea why or how to
fix?

[Dica]

"Lars Behrmann" <la***********@ web.de> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

Hi Dica,

you can set the DefaultView of your DataTable
as DataSource and set the Sort property of the
DefaultView to ascending. You should also set
your id column as primary key. Otherwise it could
be that the sorting won't work.

....DataSource = oDataSet.Tables["tblTasks"].DefaultView.So rt =
"ascending" ;
thanks lars.
i've revised the code as per your instrucitons:
cboTasks.DataSo urce = oDataSet.Tables["tblTasks"].DefaultView.So rt = "id";
cboTasks.Displa yMember = "summary";

cboTasks.ValueM ember = "id";

but i'm getting an error:
Complex DataBinding accepts as a data source either an IList or an
IListSource

the other option i've found is to use a select statement againts the dataSet
table:

DataRow[] drarray;

drarray = oDataSet.Tables["tblTasks"].Select(null, "id",
System.Data.Dat aViewRowState.C urrentRows);

for (int i=0; i < drarray.Length; i++)

{

cboTasks.Items. Add(drarray[i]["summary"].ToString());

}

this option seems to work fine, but i can't find any way to add the
valueMember (the ID column from my dataSet) to the comboBox this way.

any other ideas?

tks


Cheers
Lars Behrmann

_______________ __
Nothing is impossible. UML is the key for all your problems.
AODL - Make your .net apps OpenOffice ready
http://aodl.sourceforge.net/

Dica schrieb:

i've got a dataSet that looks like the following:

<tblTasks>

<id>0</id>

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

</tblTasks>

<tblTasks>

<id>713</id>

<summary>resear ch</summary>

</tblTasks>

<tblTasks>

<id>717</id>

<summary>Othe r - time estimation</summary>

</tblTasks>

i've bound the dataSet to my comboBox as follows:

cboTasks.DataSo urce = null;

cboTasks.Items. Clear();

cboTasks.DataSo urce = oDataSet;

cboTasks.Displa yMember = "tblTasks.summa ry";

cboTasks.ValueM ember = "tblTasks.i d";

but the "-- Select Task --" option is showin up last. any idea why or how to fix?