select query to combine LIKE operator and ORDER BY keyword

Question

0.00/5 (No votes)

See more:

SQL

SELECT [dwords] FROM [meaning] WHERE (([dwords] ='" & TextBox1.Text & "') AND ([dcat] = '" & RadioButtonList1.Text & "' ))

In this query, I want to add the like operator for 3 character of a textbox value and order by in alphabetical order.
somebody rewrite this and help me..

Posted 30-Sep-11 4:48am

kwhiterosek

Updated 30-Sep-11 4:50am

v2

Add a Solution

2 solutions

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)

Kschuler · Answer 1 · 2011-09-30T05:07:00

It sounds like you already have what you need...just put it together.

If you want just the first three characters of a textbox you could use padright and substring like this:

VB

TextBox1.Text.PadRight(3, " ").Substring(0, 3).Trim

This way even if the user only typed in single character your code will work.

Also, when you use the Like keyword you use % inside the string as a wildcard character. So you'd want to also add that to your string.

TextBox1.Text.PadRight(3, " ").Substring(0, 3).Trim & "%"

or to both the end and the start if you want any [dword] that contains the text instead of just starts with it.

If you want to order by something you just need to add the Order By clause at the end. Order By [dwords]

See this article[^] for more info about Order By.

I'd also like to point out that your code is vulnerable to SQL injection attacks. You should be using parameters instead of text right from the textbox. You could start researching that with google[^].

Hope this helps.

RaisKazi · Answer 2 · 2011-09-30T05:07:00

Solution 2

Here are steps to follow.

1) This link will give you idea of Substring, to get "3 character of a textbox".
http://msdn.microsoft.com/en-us/library/aka44szs.aspx

2) This link will give you idea of, How to use "Like" Operator of SQL.
http://msdn.microsoft.com/en-us/library/ms179859.aspx

3) This link will give you idea of, "Order By" Clause.
http://www.w3schools.com/sql/sql_orderby.asp

Posted 30-Sep-11 5:07am

RaisKazi

Comments

kwhiterosek 30-Sep-11 13:14pm

ok. now i have a confusion of where to place that like keyword. i have placed textbox and radiobutton in where clause. so i need to know where andhow to use that Like-Limit and order by keywords.