add following code to your application.
Markup Code
<asp:dropdownlist id="ddlProducts" runat="server" xmlns:asp="#unknown" />
<asp:button id="btnBindValue" onclick="btnBindValue_Click" runat="server" xmlns:asp="#unknown" />
Code behind (c#)
void btnBindValue_Click(Object sender,EventArgs e)
{
string strSelectedValue = ddlProducts.SelectedItem.toStrng();
DataSet ds = GetCalueFromDB(strSelectedValue);
gridview1.dataSource = ds;
gridview1.databind();
}