filter datagridview from combo box selection.. I Am Tiring To Make A Form In Which I Want To Show My Table"S Data By Category In Datagridview With Help Of Combobox.

Sorry for delaying..

SqlCommand cmd;
string str;
SqlDataReader dr,dr1;

ON ddl_category Click event and set it to Autopost Back True

str = "select itemname,price from items where category=@category";
cmd = new SqlCommand();
cmd.CommandText = str;
cmd.Parameters.AddWithValue("@category",ddlcate.Text.Trim());
cmd.Connection = con;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
dr1 = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if (dr1.HasRows)
{
GridView1.DataSource=dr1;
GridView1.DataBind();
}