Using WildCard Character

Question

0.00/5 (No votes)

See more:

Hi,
In my application i have a search criteria field in which one document name field is there.
I have a document in my database with name $#%#$. Now, I want to search for document by entering only %.
How i do that?
I tried differnt things but its not working. If i entered % in the document name field it gives me all the document.But, I want only that document.
Thanks,
Umesh Tayade

Posted 17-May-11 1:41am

Member 4550493

Add a Solution

Comments

[no name] 17-May-11 7:43am

What have you tried for this, put your code we will guide you where you went wrong.

Member 4550493 17-May-11 8:07am

queryBindValues.Add(CONST_VarDocName, %+ docName + %);

where if i entered the docname=% then it gives all record but i want only that record

Member 4550493 17-May-11 8:12am

I tried following thing but it don't give any record return inputSQL.Replace("%", "''"); return inputSQL.Replace("%", "[%]"); return inputSQL.Replace("%", "%");

Member 4550493 17-May-11 8:26am

orderSearchDetailViewModelConnector.ViewState.GetOrderSearchDetail( (txtDocName.Text != string.Empty) ? SafeSqlLiteral(txtDocName.Text.ToUpper().Trim()) : string.Empty);

private string SafeSqlLiteral(string inputSQL)
{
return inputSQL.Replace("\"", "''").Replace("&", "''").Replace("<", "''").Replace("%", "''");
}

if (!string.IsNullOrEmpty(docName))
{
query.ApplyPredicate(CONST_byDocName, CONST_target2);
queryBindValues.Add(CONST_VarDocName, CONST_PERCENTILE + docName + CONST_PERCENTILE);
}
This is my code
Please Reply Soon

Debojyoti Majumder 17-May-11 7:54am

Please share your code.

Member 4550493 17-May-11 8:26am

orderSearchDetailViewModelConnector.ViewState.GetOrderSearchDetail( (txtDocName.Text != string.Empty) ? SafeSqlLiteral(txtDocName.Text.ToUpper().Trim()) : string.Empty);

private string SafeSqlLiteral(string inputSQL)
{
return inputSQL.Replace("\"", "''").Replace("&", "''").Replace("<", "''").Replace("%", "''");
}

if (!string.IsNullOrEmpty(docName))
{
query.ApplyPredicate(CONST_byDocName, CONST_target2);
queryBindValues.Add(CONST_VarDocName, CONST_PERCENTILE + docName + CONST_PERCENTILE);
}
This is my code
Please Reply Soon

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)

fjdiewornncalwe · Answer 1 · 2011-05-17T02:33:00

Solution 1

You may gain some better understanding from this page. In order to use a character defined as a wildcard in SQL, you would have to escape that character for it to be used as a literal in the query. The article I linked to explains how to do this.

Posted 17-May-11 2:33am

fjdiewornncalwe