Here in this post, I will show you how to fill / populate data to ListBox control from Sql database records in C# Windows Form Application.
The listbox will populated from database table using sqlDataReader.
Step 1: We will use the Customers table in Northwind database.
Step 2:
Step3: Write a Namespace for connectivity as in the following code snippet.
1 2 3 | using System.Data.SqlClient; |
Step 4: Define global variables.
1 2 3 4 5 | SqlConnection con; SqlCommand cmd; SqlDataReader dr; |
Step 5: Create source code for Button1.
We will list CompanyNames.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | private void button1_Click(object sender, EventArgs e) { con = new SqlConnection("server=.; Initial Catalog=Northwind;Integrated Security=SSPI"); cmd = new SqlCommand(); con.Open(); cmd.Connection = con; cmd.CommandText = "SELECT * FROM Customers"; dr = cmd.ExecuteReader(); while (dr.Read()) { listBox1.Items.Add(dr["CompanyName"]); } con.Close(); } |
Finally, finished the project.
Here are the all codes:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace fill_listbox { public partial class Form1 : Form { SqlConnection con; SqlCommand cmd; SqlDataReader dr; public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { con = new SqlConnection("server=.; Initial Catalog=Northwind;Integrated Security=SSPI"); cmd = new SqlCommand(); con.Open(); cmd.Connection = con; cmd.CommandText = "SELECT * FROM Customers"; dr = cmd.ExecuteReader(); while (dr.Read()) { listBox1.Items.Add(dr["CompanyName"]); } con.Close(); } } } |
Output:
