getting error in sql query. for filtering data on the bases of price

Question

0.00/5 (No votes)

See more:

i am trying to filter the products on the base of price...

i have a link control on one page.. and i am redirctring the page to ProductCatalog.aspx to show the products in the grid

C#

<td align="center">
                               <asp:LinkButton ID="LinkButton4" PostBackUrl='<%# "~/ProductCatalog.aspx?PriceID="+Eval("UnitCost") %>' runat="server"><5000</asp:LinkButton>
                           </td>

on Products.Aspx page

C#

string query = "Select * from Products where '"+int.TryParse(Request.QueryString["PriceID"]<5000)+"'";

i am getting the error

C#

Error 1	Operator '<' cannot be applied to operands of type 'string' and 'int'

IMproved
On Product Catalog.aspx page

C#

private void LoadGridView() // just calling it on page load
   {

       string query = "Select * from Products where UnitCost= " + Request.QueryString["ID"] + "<5000"; ;
       //DataSet ds = new DataSet();
       DataSet ds=obj.fillgrid(query);
       GridView1.DataSource = ds.Tables[0];
       GridView1.DataBind(); ;
       //conn.Close();
   }

and on my master page i embedd

ASP.NET

<table class="style1" width="20%">
            <tr>
                <td bgcolor="#666" align="center" class="style2" >
                    Search Products By Price Range</td>
                        </tr>
                        <tr bgcolor="#F7F7DE" >
                            <td align="center">
                                <asp:LinkButton ID="LinkButton4" PostBackUrl='<%# "~/ProductCatalog.aspx?ID="+Eval("UnitCost") %>' runat="server"><5000</asp:LinkButton>
                            </td>
                        </tr>
                        <tr bgcolor="#F7F7DE">
                            <td align="center">
                                <asp:LinkButton ID="LinkButton5" runat="server">>=5000 and <=10000</asp:LinkButton>
                            </td>
                        </tr>
                        <tr bgcolor="#F7F7DE">
                            <td align="center">
                                <asp:LinkButton ID="LinkButton6" runat="server">>=10000 and <=20000</asp:LinkButton>
                            </td>
                        </tr >
                        <tr bgcolor="#F7F7DE">
                            <td align="center">
                                <asp:LinkButton ID="LinkButton7" runat="server">>20000</asp:LinkButton>
                            </td>
                        </tr>
                    </table>

Posted 24-Dec-11 4:39am

codegeekalpha

Updated 24-Dec-11 6:45am

v2

Add a Solution

1 solution

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)

thatraja · Answer 1 · 2011-12-24T04:47:00

Solution 2

C#

string query = "Select * from Products where " + Request.QueryString["PriceID"].ToString() + "<5000";

Use parametrized query
Or you can use filter in your DataSet or DataTable

EDIT

Actually whats the value of Eval("UnitCost")? Because the field name missing in your query(above code). You code should like below.

C#

string query = "Select * from Products where PriceID<5000";

Here you must send the value 5000 dynamically. Correct me if anything wrong

EDIT2

So you want to select products by range?
Your code should be like(There should be two columns in where condition ProductId & UnitCost)

C#

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

BTW again I suggest you to use parametrized query.

Posted 24-Dec-11 4:47am

thatraja

Updated 24-Dec-11 6:58am

v5

Comments

[no name] 24-Dec-11 11:33am

I think the main pb is the silly and useless “int.TryParse(...)“Regards.

thatraja 24-Dec-11 11:44am

Yes, BTW why did you delete your answer?

[no name] 24-Dec-11 11:48am

Because maybe not appreciated because of a low point member answer;) Not a problem. Regards.

thatraja 24-Dec-11 11:59am

Oh no, it doesn't matter. OP need answers, that's all. 2 years ago I was also a low point member. OK don't do that again. I'll restore your answer.

[no name] 24-Dec-11 12:01pm

I deleted all my "useless" answers/comments until now, in the meaning to keep the forum clean :)
You have to know I'm a noob here.
Regards

thatraja 24-Dec-11 12:01pm

Oops, I couldn't restore your answer :(

[no name] 24-Dec-11 12:02pm

Do not bother. Live goes on. Thanks for your help.
Regards.

codegeekalpha 24-Dec-11 11:48am

this query has a errors.. syntax error.. can u figure out them

codegeekalpha 24-Dec-11 11:54am

i am getting error object reference not set to instance of object

[no name] 24-Dec-11 11:56am

Simply try "Select Products.* from Products where Products.PriceID < '5000'" and forget about int.TryParse....
There is no need to convert something to string by int.TryParse(...)!

I think then you will be out of pb.
Regards

codegeekalpha 24-Dec-11 12:01pm

how can i do it.. i am getting the price in querystring

[no name] 24-Dec-11 12:06pm

Do you get any error (and if yes wahts exactly) if you execute "Select Products.* from Products where Products.PriceID < '5000'" ?
Regards

thatraja 24-Dec-11 12:17pm

check updated answer

[no name] 24-Dec-11 12:25pm

Checked. Uuups sorry I think I was on a wrong path. Willing to learn :)Anyway 5 from a noob because you are leading us.
Regards

thatraja 24-Dec-11 12:29pm

No, don't be sorry. I replied OP.

codegeekalpha 24-Dec-11 12:23pm

yeh can't not fine table 0

thatraja 24-Dec-11 12:30pm

That means there is no table in your dataset

codegeekalpha 24-Dec-11 12:35pm

i have a table in my data set...
i am not a very biggner...

thatraja 24-Dec-11 12:41pm

I think you must include more details so update your question with more details & let us know

codegeekalpha 24-Dec-11 12:46pm

improved.. check now.. its not more detailed...

[no name] 24-Dec-11 12:52pm

private void LoadGridView() // just calling it on page load {

string query = "Select * from Products where UnitCost= " + Request.QueryString["ID"] + "<5000"; ;

//DataSet ds = new DataSet(); DataSet ds=obj.fillgrid(query);

GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); ;

//conn.Close(); }

+Request.QueryString["ID"] what for?

I think I'm very safe in SQL but this makes no sense for me!Regards.

thatraja 24-Dec-11 12:58pm

check updated answer again

codegeekalpha 24-Dec-11 13:03pm

u mean i shoud use Eval("ProductId) ??? what about the Link page
<asp:LinkButton ID="LinkButton4" PostBackUrl='<%# "~/ProductCatalog.aspx?PriceID="+Eval("UnitCost") %>' runat="server"><5000

what i have to do in it