hi frnd
you can write you logic as per below code
string proid;
string querydr = "select * from Products";
SqlDataReader dr = obj.fillcomb(querydr);
while (dr.Read())
{
if(proid == String.empty)
{
proid = Convert.ToInt16(dr["ProductID"]);
}
else
{
proid +=","+Convert.ToInt16(dr["ProductID"])
}
}
Response.Redirect("your page name"?ID=proid);
and into another page:
if(Request.QueryString["ID"] !=null &&
Request.QueryString["ID"].toString() != "")
{
string query = "Select * from Products where ProductID= '" + Request.QueryString["ID"].ToString() + "' AND UnitCost < 5000";
}
let me know is this solution is help.