DataReader and ComboBox BlankLine

[Tim Ford]

People,

I trying to write a lookup combobox that gets it's data via a sql table.

I can populate the combobox with the information and have handled all
the filtering, how ever i can't seem to add a blank row to the combobox,
i have tried adding via the datatable and i can't seem to get that to
work. However is there a way via the datareader to populate the combobox
with a text value and id without assigning a object to the combobox.

Thanks Tim.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[One Handed Man [ OHM# ]]

If your ComboBox is bound to the DataTable, adding a new row to the
DataTable should present a new entry in the ComboBox. Are you saying that
this is not the case ?

Regards - OHM

Tim Ford wrote:

People,

I trying to write a lookup combobox that gets it's data via a sql
table.

I can populate the combobox with the information and have handled all
the filtering, how ever i can't seem to add a blank row to the
combobox, i have tried adding via the datatable and i can't seem to
get that to work. However is there a way via the datareader to
populate the combobox with a text value and id without assigning a
object to the combobox.

Thanks Tim.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Regards - OHM# OneHandedMan{at}BTInternet{dot}com

[Tim Ford]

Yep this sure is the case, i keep on getting a dbull=readonly error. any
idea??

Thanks Tim.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[One Handed Man [ OHM# ]]

I created a similar scenario to you., albiet using a dataAdapter rather than
a DataReader,and was able to add something to the table with no problems.

Suggest that the first thing is to debug this and prove that you are adding
a row to your DataTable. You will not be able to add items directly to the
list while the control is bound I dont think.

Regards - OHM

Dim tr As DataRow = Ds1.Tables(0).NewRow()

tr(9) = "Crap"

Ds1.Tables(0).Rows.Add(tr)

Tim Ford wrote:

Yep this sure is the case, i keep on getting a dbull=readonly error.
any idea??

Thanks Tim.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Regards - OHM# OneHandedMan{at}BTInternet{dot}com