String ConnStr = settings.ConnectionString().ToString(); String SQLIssues = "SELECT issueid, projid, summary FROM issues"; SqlDataAdapter IssuesAdpt = new SqlDataAdapter(SQLIssues, ConnStr); DataSet Issues = new DataSet(); IssuesAdpt.Fill(Issues); foreach (DataRow Issue in Issues.Tables[0].Rows) { comboBox2.Items.Add(Issue[2]); comboBox2.ValueMember = Issues.Tables[0].Columns[0].ToString(); }