partial text search for Entity Framework

Question

4.00/5 (1 vote)

See more:

Hi all,

i have 4 columns of different types ,like int,date,string,decimal
i want to search by all these data types and based on the search i will display result to grid view

example of my code which will take the int value ,the problem is its only working when exact value is entered
i want partial text search ,how can i do?

C#

Int32 sid = Convert.ToInt32(id.Text);
        testingModel.testingEntities te = new testingModel.testingEntities();
        if (id.Text != "")
        {
            var disp = from i in te.alltypes
                       where i.@int.Equals(sid)
                       select i;
            GridView1.DataSource = disp;
            GridView1.DataBind();
        }

Posted 24-May-12 4:06am

pradeep manne

Updated 24-May-12 4:07am

v2

Add a Solution

2 solutions

Solution 1

If you want to search for a partial numeric match you will need to obviously convert the int to a string and use Contains for the comparison.

I don't have a model setup to test but it should be something like

SQL

var disp = from i in te.alltypes
            where i.ToString().Contains(sid)
            select i;

Posted 24-May-12 4:15am

Not Active

Comments

pradeep manne 24-May-12 10:43am

Hi,
Thanks for the reply
ur code is working good for strings
but when i try for int type its giving the following error:

LINQ to Entities does not recognize the method 'System.String ToString()' method, and this method cannot be translated into a store expression.

any solution for this error?

[no name] 24-May-12 11:55am

Without seeing the model you are using or the fields you are trying to compare I can't answer. However, all .NET object have the ToString method.

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)

pradeep manne · Accepted Answer · 2012-05-25T00:00:00

Solution 2

hi all,

in where condition use the below code

String sid = id.Text;//textbox name

where SqlFunctions.StringConvert((Decimal)i.columnname).Contains(sid)

Posted 25-May-12 0:00am

pradeep manne

Updated 25-May-12 0:03am

v2