Search method using textbox

Question

2.00/5 (1 vote)

See more:

Hi All
I'm Creating Simple Search Page Using Textbox and Button
When I try Searching , The results Show only when I type Numbers in textbox

This is my Sql

C#

Select Name from Users Where Name Like '%{0}%'

Note : {0} is the Field Number in Method (Class)
I call it's Function in code behind and pass textbox.text

it is not the problem
The method Working Correctly
But the problem :
I have The following users in table :
Maria 56 - Barak - Rano30
But When I try To type in textbox Maria --> the result is nothing
When I try to type Maria 56 --> the result is nothing
But when I type in textbox 56 the result show in gridview

anyone can help me ???

What I have tried:

I tried changing in Select SQL But nothing changed

Posted 15-Aug-16 14:29pm

shms_rony

Updated 15-Aug-16 15:04pm

Add a Solution

Comments

Karthik_Mahalingam 16-Aug-16 2:08am

select * from table where name like '%maria%'
this is working..

shms_rony 16-Aug-16 7:04am

Not working , only numbers or space in textbox show results of execution
may be there is something error in textbox , could you help me

shms_rony 16-Aug-16 7:11am

but also when I write Maria in label text and " select where name like '%'+label1.text+'%' , the same problem :/

Karthik_Mahalingam 16-Aug-16 7:45am

try running the query in sql server studio and check

Karthik_Mahalingam 16-Aug-16 7:44am

sure, but you will to provide the info clearly.

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)

RossMW · Answer 1 · 2016-08-15T15:04:00

Solution 1

You haven't given us must code to look at so I can only conclude its your SQL statement with the {0} field number.

We cant see what this class is or what it does, but you should check the returned SQL statement to see if its a valid sql statement before running it against the database. The statement above is not unless you are searching for {0} in the name field.

Maybe what you are after is

SQL

Select Name from Users Where Name like '%[0-9]%' and name like '%' + textbox.text + '%'

Posted 15-Aug-16 15:04pm

RossMW

Updated 15-Aug-16 15:36pm

v3

Comments

shms_rony 15-Aug-16 21:12pm

class method
==================
public DataTable searchname(string value)
{
string query = String.Format("Select Name from Users Where Name Like '%{0}%'", value);

return search(query);
}

in code behind
=====================

protected void ButSrch_Click(object sender, EventArgs e)
{

GridView5.DataSource = classobject.searchname(Textsrch.Text);

GridView5.DataBind();

}

RossMW 15-Aug-16 21:23pm

See modified answer above. Depending on what search conditions you are trying to achieve, you can have various combinations of above. But essentially you need to ensure the SQL is valid and run it manually across the database and correct until you get the desired result.

shms_rony 15-Aug-16 21:29pm

how can I use your modified answer in my sql ?

RossMW 15-Aug-16 21:37pm

Answer has changed with full sql statement. Your DAtaTable code will need to be changed.