problem in showing data in gridview on the base of request.querystring

Question

0.00/5 (No votes)

See more:

First i have a problem of getting the ProductIds from main page to Product Catalog.aspx Page through querystring.
Now when i make some Changes in the coding as below. i am getting the ProductsIDs form main page to ProductCatalog.aspx page thorugh querystring.I Used debugger to check that. On main page i made the fallowing changes. now ids are going to productcatalog.aspx page.

C#

string 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);

I used Debugger to check that whats going on on ProductCatalog.aspx Page..

I saw that i am getting the fallowing thing in my query on product catalog.aspx page..

I put the query in productcatalog.aspx page as

C#

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

and on dubbugger i saw that the query runs as below.

C#

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

the products with ids have 63 and 64 have price(UnitCost) <5000 but nothing is shown in gridview. can anyone help on that where is the problem

on ProductCatalog.aspx page i have the code as below

C#

private void LoadGridView()
   {


       if (Request.QueryString["ID"] != null && Request.QueryString["ID"].ToString() != "")
       {

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

           DataSet dss = obj.fillgrid(query);
           GridView1.DataSource = dss.Tables[0];
           GridView1.DataBind();
       }

   }

i put loadgridview on page load

Posted 27-Dec-11 18:09pm

codegeekalpha

Add a Solution

4 solutions

Solution 1

Use split() in sql and split prodID and make query :

string Query = "Select * from Products where ProductID in (Select * from dbo.split( '" + Request.QueryString["ID"].ToString() +"', ',')) AND UnitCost < 5000";

Use above query, it will give your result.

Posted 27-Dec-11 18:15pm

Sarvesh Kumar Gupta

Comments

codegeekalpha 28-Dec-11 0:57am

still i am getting nothing in grid :(.

Solution 2

Hi,

Your query generated is wrong

Query should be generated like this

query	"Select * from Products where ProductID in ('63,64,65') AND UnitCost < 5000"

Hope this will help :)

Thanks
Vinod

Posted 27-Dec-11 18:16pm

Vinod Satapara

Updated 27-Dec-11 18:17pm

v2

Comments

codegeekalpha 28-Dec-11 0:29am

???? how??

karthi18988 28-Dec-11 8:18am

You cant pass all the condition in where=(63,64,65) for that you must use where IN (63,64,65)

Solution 3

Change your code like this

private void LoadGridView()
   {


       if (Request.QueryString["ID"] != null && Request.QueryString["ID"].ToString() != "")
       {

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

           DataSet dss = obj.fillgrid(query);
           GridView1.DataSource = dss.Tables[0];
           GridView1.DataBind();
       }

   }

Posted 27-Dec-11 18:33pm

Vinod Satapara

Comments

codegeekalpha 28-Dec-11 0:58am

grid still remain empty.. still having the same problem

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RagSuchi · Accepted Answer · 2011-12-28T02:02:00

Solution 4

Hi,

Query should be like this.i hope it will work..

query = "Select * from Products where ProductID in (63,64,65) AND UnitCost < 5000"

Posted 28-Dec-11 2:02am

RagSuchi

Updated 28-Dec-11 2:03am

v2