It may look funny but try executing following way
{
String store = Request.QueryString["id"];
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select spec from computer where prod_name is '"+store+"' ";
DataSet ds = new DataSet();
SqlDataAdapter dap = new SqlDataAdapter(cmd.CommandText,con);
dap.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
con.Close();
}
Hope it helps you...