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...
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.
Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.
