This tutorial will teach you how to Populate DataGridView based on Combobox selected using C#.net and Microsoft SqlServer.
Import the Namespace
using System.Data.SqlClient;
Establish the database Connection
1 2 3 4 | SqlConnection con = new SqlConnection("server=.;database=ads;user id=sa;password=123;"); SqlCommand cmd; SqlDataAdapter dr; DataSet ds; |
ComboBox Selected Event
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 | if (comboBox1.SelectedItem.ToString() == "Students") { try { dataGridView1.Refresh(); con.Open(); DataTable dt = new DataTable(); dr = new SqlDataAdapter("select * from student", con); dr.Fill(dt); dataGridView1.DataSource = dt; con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else if (comboBox1.SelectedItem.ToString() == "Courses") { try { dataGridView1.Refresh(); con.Open(); DataTable dt = new DataTable(); dr = new SqlDataAdapter("select * from course", con); dr.Fill(dt); dataGridView1.DataSource = dt; con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } |
i have attached the video link below. which will do this tutorials step by step.
