Newbie Datagridview/Combo Box problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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?


.

Relevant Pages

  • Re: Newbie Datagridview/Combo Box problem
    ... Main Table - includes StatusID, Status which ... StatusID is a primary key in Status table, ... unless I set the DisplayMember to StatusID ... How can I accomplish this? ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: Drop down list box colour
    ... StatusID, ... you would use a combobox similar to the following to choose from ... Access Basics ... Lookup Table of Statuses to keep the structure more simplistic. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Is there an easy way?
    ... A combobox for each word is a bad idea! ... StatusID. ... Each pupil has to both spell and read (pronounce) 200 words. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Drop down list box colour
    ... StatusID, ... Access Basics ... As I have several other lookup tables, I decided not to go with a seperate Lookup Table of Statuses to keep the structure more simplistic. ... As far as the form is concerned, I would use a combobox to choose the current Status from, and store the Status ID in my table...am I doing this right? ...
    (microsoft.public.access.tablesdbdesign)