Home C#.net How to Populate DataGridView Combobox C#.net

How to Populate DataGridView Combobox C#.net

1 min read
0
0
521

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

SqlConnection con = new SqlConnection("server=.;database=ads;user id=sa;password=123;");
SqlCommand cmd;
SqlDataAdapter dr;
DataSet ds;

ComboBox Selected Event

        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.

 

 

Load More Related Articles
Load More By admin
Load More In C#.net

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

Build a Full-Stack Node.js MongoDB CRUD App with JWT Authentication

In this tutorial, we will teach the process of building a full-stack application using Nod…