Dynamically populate a list with SQL values

Question

I'm starting c #. I am trying to extract data from an SQL database column and write it to a list. Basically, I want the data in the part_num column of my table to be displayed dynamically in the list.

I have seen:

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

But how do 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!

Answer 1

Why not use a DataTable as a 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 DataSets or better yet EntityFramework and data binding.