---
title: "See The Whole Data in DataGridView With Selecting A Value From ComboBox:"  
description: "See The Whole Data in DataGridView With Selecting A Value From ComboBox:In this article I will give an example that how to display the data in the dat"  
author: "Arijit Bhadra"  
published: 2011-10-08  
updated: 2020-03-04  
canonical: https://www.mindstick.com/articles/750/see-the-whole-data-in-datagridview-with-selecting-a-value-from-combobox  
category: "c#"  
tags: ["c#"]  
reading_time: 2 minutes  

---

# See The Whole Data in DataGridView With Selecting A Value From ComboBox:

See The Whole Data in DataGridView With Selecting A Value From ComboBox:

In this article I will give an example that how to display the data in the datagridview on the basis of combobox value.

##### *Write this code on the click event of Button*

```
private void button1_Click(object sender, EventArgs e) {            SqlConnection con = new SqlConnection();  //create a SqlConnection class object            con.ConnectionString = "Data Source=home-1117080bc2;Initial Catalog=Hotel_Booking;User              ID=sa;Password=sqlforarijit";  //create a connecting string            con.Open();  //open the connection            SqlCommand cmd = new SqlCommand("select * from new_reservation where customer_id =            @a", con);  //retrieve record(s) of customer from the database on the basis of id            cmd.Parameters.Add("@a", SqlDbType.VarChar, 50);  //add a parameter            cmd.Parameters["@a"].Value = comboBox1.Text;  //pass the parameter value from combobox            SqlDataAdapter ada = new SqlDataAdapter(cmd);  //create a SqlDataAdapter object and pass                                                                                                                                                                                                                     SqlCommand object as a parameter            SqlCommandBuilder build = new SqlCommandBuilder(ada);  // create a SqlCommandBuilder                                                                                                                                                                     object and pass SqlDataAdapter object as a parameter            DataSet ds = new DataSet();  //create a dataset            ada.Fill(ds, "new_reservation");  //fill the data in a dataset, pass dataset object and virtual                                                            table name                                                         table name            dataGridView1.DataSource = ds.Tables[0];  // set dataset table as a datasource of datagridview   }
```

After performing the above task build and run your project. Now when you click on the button it display the data in datagridview on the basis of combobox value. The select query fetches the record of that customer which customer id has been selected in the combobox.

Thanks.

---

Original Source: https://www.mindstick.com/articles/750/see-the-whole-data-in-datagridview-with-selecting-a-value-from-combobox

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.