Database

CREATE TABLE [dbo].[tblTitles] (<br />
	[TitleID] [int] IDENTITY (1, 1) NOT NULL ,<br />
	[TitleDisplayText] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,<br />
	[TitleHidden] [bit] NULL CONSTRAINT [DF_tblTitles_TitleHidden] DEFAULT (0),<br />
	CONSTRAINT [PK_Titles] PRIMARY KEY  CLUSTERED <br />
	(<br />
		[TitleID]<br />
	)  ON [PRIMARY] <br />
) ON [PRIMARY]

CREATE  SEQUENCE  tblTitles_TitleID_SEQ<br />
	START WITH 1<br />
	INCREMENT BY 1<br />
/<br />
<br />
CREATE TABLE tblTitles <br />
(<br />
	TitleID int  NOT NULL , <br />
	TitleDisplayText VARCHAR2 (50)  NULL , <br />
	TitleHidden NUMBER(1)  DEFAULT 0  NULL , <br />
	CONSTRAINT PK_Titles PRIMARY KEY (TitleID) <br />
)

// Create the dataset<br />
DataSet dsTitles = new DataSet("Titles");<br />
OpenConnection(); // creates and opens a new connection or returns existing connection.<br />
OracleCommand tableCommand = null;<br />
tableCommand = dbConnection.CreateCommand();<br />
tableCommand.CommandText = "select TitleID, TitleDisplayText FROM tblTitles WHERE TitleHidden <> 1 ORDER BY TitleDisplayText";<br />
<br />
OracleDataAdapter adapter = new OracleDataAdapter();<br />
adapter.SelectCommand = tableCommand;<br />
adapter.Fill(dsTitles, "Titles"); <br />
<br />
// Bind to ComboBox<br />
comboBoxTitle.BeginUpdate();<br />
comboBoxTitle.DataSource = dsTitles.Tables["Titles"];<br />
comboBoxTitle.DisplayMember = "TitleDisplayText";<br />
comboBoxTitle.ValueMember = "TitleID";<br />
comboBoxTitle.EndUpdate();