How to display data in datagridview according to filter by combobox selected item in windows application?

See more:

C#

.NET

SQL-Server

.NET4

Hello,

I want to filter datagridview data on combobox selected index changed event, I have written code but when we select Item so my datagridview is blanked.
My Code is:-

private void cmbSearchTileCategory_SelectedIndexChanged(object sender, EventArgs e)
{
var obj = new ConnectionClass();
var con = obj.GetConnection();
SqlCommand cmd = new SqlCommand("select * from FloorTile where FloorCatName='" + cmbSearchTileCategory.SelectedItem + "'", con);
SqlDataReader sdr = cmd.ExecuteReader();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds, "FloorTile");
dgvDisplayTiles.DataSource = ds;
}

This process only for C# .Net Windows Application.

Please help me for this problem.

Thanks in Advance.

Ankit Agarwal
Software Engineer