How to populate listbox dynamically with SQL values

I am a C# beginner. What I am trying to do is pull data from a column in a SQL database and write it to a listbox. Basically, I want the data in the part_num column of my table to be displayed dynamically in the listbox.

I have seen:

this.listParts.Items.AddRange(new object[] {"Part1", "Part2"});

But how would I go about replacing “Part1” and “Part2” with dynamically generated values from SQL?

public mainForm()
{ InitializeComponent(); SqlConnection conn = new SqlConnection( "Data Source=DBELL;Initial Catalog=part_table;Integrated Security=True"); conn.Open(); DataSet ds = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter( "SELECT part_num from customParts", conn); adapter.Fill(ds); foreach (DataRow row in ds.Tables[0].Rows) { for (int i = 0; i < ds.Tables[0].Columns.Count; i++) this.listParts.Items.AddRange(new object[] {"Part1", "Part2"}); }
}

Any help is appreciated!

1 Answer

Why not use the DataTable as DataSource:

public mainForm() { InitializeComponent(); SqlConnection conn = new SqlConnection("Data Source=DBELL;Initial Catalog=part_table;Integrated Security=True"); conn.Open(); DataSet ds = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter( "SELECT part_num from customParts", conn); adapter.Fill(ds); this.listParts.DataSource = ds.Tables[0]; this.listParts.DisplayMember = "part_num"; }

You should read up on DataSets or even better yet EntityFramework and data-binding.