Problem in Displaying data in grid thorungh querystring.

See more:

C#

ASP.NET

i am redirecting the ids from main page to productcatalog.aspx page.. on productcatalog.aspx page.

On productcatalog.aspx page . i have written a query

tring query = "Select * from Products where ProductID= '" + Request.QueryString["ID"].ToString() +"' AND UnitCost < 5000";

Can i pas Request.querystring["id"].tostring as string or i should pas it in as numaric...

and in debugger i am getting the ids from the main page as..

query	"Select * from Products where ProductID= ',63,64,65' AND UnitCost < 5000"	string

but data is not shown in grid.. what is the problem how to sort out that one.

is their something wrong in generated query..

on the main page i have made a logic as below..

tring querydr = "select * from Products";
           SqlDataReader dr = obj.fillcomb(querydr);
            
            while (dr.Read())
            {
                 
                if(proid == String.Empty)
                  {
                 proid =  dr["ProductID"].ToString(); 
                 }
              else
                 {
                     proid += "," + dr["ProductID"].ToString();
                }
 
 
                }
            
          
 
       Response.Redirect("ProductCatalog.aspx?ID="+proid);