Newbie Datagridview/Combo Box problem

S

SimpleMan75

Consider these tables:
Main Table - includes StatusID (showing StatusID, integer), Status which is
based on
Status Table - has StatusID, and Status (varchar)

StatusID is a primary key in Status table, while StatusID in the Main Table
is the Foreign key of the Status ID

How can I add a combobox, using a sProc to get a list of whatever is in the
Status Table
And then, SHOW the status (text), based on the StatusID?
(in asp.net, we have a value and a text property in the Dropdownlist to
accomplish this)

in the combobox - I set the DataPropertyName to StatusID (which is what the
DGV would bring back) and the DisplayMember to Status, but it errors out,
unless I set the DisplayMember to StatusID

I need it to show the text - Status - -
How can I accomplish this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with query... 2
Sync Combo ? am I do wrong 3
VBA Compile Error: Variable not defined 10
Dropdown in Formview not updating as expected 1
Using IIf + default value for a combo box 4
Update Statement with SubSelects 3
Relationship, combo box, parameter query 2
Can't edit record - Form is read-only 1

Top