in my design part i m having a drop down list by selecting one item from that and clicking on the search it should search for the related things in the databse table and should generate the data...

string strsql=string.empty;
strsql="select * from table2 where id1=@dropdownvalue1";
//write code for executing a query
cmd.parameter.addwithvalue(@dropdownvalue1,dropdownlistvalue1);
//write code for filling dataset here
if(ds.Tables[0].rows.count>0)
{
//bound gridview here
}