See The Whole Data in DataGridView With Selecting A Value From ComboBox in ADO.NET

*Write this code on the Button*
private void
button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection();
            con.ConnectionString = 'Data Source=home-1117080bc2;Initial Catalog=Hotel_Booking;User ID=sa;Password=sqlforarijit';
            con.Open();
            SqlCommand cmd = new SqlCommand('select * from new_reservation where customer_id = @a', con);
            cmd.Parameters.Add('@a', SqlDbType.VarChar, 50);
            cmd.Parameters['@a'].Value = comboBox1.Text;
            SqlDataAdapter ada = new SqlDataAdapter(cmd);
            SqlCommandBuilder build = new SqlCommandBuilder(ada);
            DataSet ds = new DataSet();
            ada.Fill(ds, 'new_reservation');
            dataGridView1.DataSource = ds.Tables[0];
        }

Last updated:9/18/2014 1:23:59 PM

5 Comments

Anonymous User
Anonymous User

Hi Arijit Bhadra,

If you can explain your code then it is much better for readers.

Please do not show your contact information on Blogs, Articles and Forum.

Thanks.

Leave Comment