Show Blank value in Combo Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CarlT - 03 Sep 2004 04:19 GMT

I need to display a blank value as well as other values. I do not want to
alter any current records but just be able to display this blank value
amongst the list.
I have not been able to figure out how to do this in a combo box. Any help
will be greatly appreciated.

carlt@gicw.org

Reply to this Message

Lateralus [MCAD] - 03 Sep 2004 05:01 GMT

Carl, usually what I do is I'll add a new row to the view.

//assume ds is a dataset

DataRow myRow = ds.Tables[0].NewRow();
myRow[valueMember] = DBNull.Value;
myRow[displayMember] = "";
ds.Tables[0].Rows.InsertAt(myRow,0);

control.DataSource = ds.Tables[0].DefaultView;
control.DisplayMember = "DISPLAY_COLUMN_NAME";
control.ValueMember = "VALUE_COLUMN_NAME";

Signature

Lateralus [MCAD]

>I need to display a blank value as well as other values. I do not want to
> alter any current records but just be able to display this blank value
[quoted text clipped - 3 lines]
>
> carlt@gicw.org

Reply to this Message

Lateralus [MCAD] - 03 Sep 2004 05:06 GMT

Carl,
I think it's getting too late at night to be doing this. I'm making too
many typos....Anyway, here is the code from my previous post. It should be
OK now.

DataRow myRow = ds.Tables[0].NewRow();
myRow["VALUE_COLUMN_NAME"] = DBNull.Value;
myRow["DISPLAY_COLUMN_NAME"] = "";
ds.Tables[0].Rows.InsertAt(myRow,0);

control.DataSource = ds.Tables[0].DefaultView;
control.DisplayMember = "DISPLAY_COLUMN_NAME";
control.ValueMember = "VALUE_COLUMN_NAME";

Signature

Lateralus [MCAD]

>I need to display a blank value as well as other values. I do not want to
> alter any current records but just be able to display this blank value
[quoted text clipped - 3 lines]
>
> carlt@gicw.org

Reply to this Message

Joey Callisay - 03 Sep 2004 07:40 GMT

Follow up question:

I believe adding an empty row to the datatable to be bound to a combobox is
an ideal thing to do since without it, one need to add additional handling
on clearing a selection, etc. However until now, I haven't encountered any
tips about this issue, can you lighten me up.

> Carl,
> I think it's getting too late at night to be doing this. I'm making too
[quoted text clipped - 17 lines]
> >
> > carlt@gicw.org

Reply to this Message

Rate this thread:

Show Blank value in Combo Box

Free Magazines