plz anyone help to show my data in datagridview using c# and mysql

on selected event changed of combo box bind the DataGrid

using System.Data;
using MySql.Data.MySqlClient;
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox cmb = (ComboBox)sender;
int selectedValue = (int)cmb.SelectedValue;
string conString = @"Data Source=localhost;port=3306;Initial Catalog=MyDB;User Id=sachin;password=pass@123";
using (MySqlConnection con = new MySqlConnection(conString))
{
using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM Products where CatId=@CatId", con))
{
cmd.Parameters.AddWithValue("@CatId",selectedValue );
using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
dataGridView1.DataSource = dt;
}
}
}
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
on selected event changed of combo box bind the DataGrid
using System.Data;
using MySql.Data.MySqlClient;

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    ComboBox cmb = (ComboBox)sender;

    int selectedValue = (int)cmb.SelectedValue;


    string conString = @"Data Source=localhost;port=3306;Initial Catalog=MyDB;User Id=sachin;password=pass@123";
    using (MySqlConnection con = new MySqlConnection(conString))
    {
        using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM Products where CatId=@CatId", con))
        {
            cmd.Parameters.AddWithValue("@CatId",selectedValue );
            using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))
            {
                using (DataTable dt = new DataTable())
                {
                    sda.Fill(dt);
                    dataGridView1.DataSource = dt;
                }
            }
        }
    }
}
Innocent Qadir5y ago
yes bro.....
i want to show data in data gridview from data base according to the combobox selected value
Rajanikant Hawaldar5y ago
could you elaborate more