How to select more colums with LIke

I triied this:

[code]
var selectTrip = from t in context.TripElements
                             where SqlMethods.Like(textBox1.Text.Trim(), t.TripElementCode) &&
                                   SqlMethods.Like(textBox1.Text.Trim(), t.TripElementName)
[/code]

But then there no results returning back

if I tty this:

[code]
 var selectTrip = from t in context.TripElements
                             where (textBox1.Text.Trim() == "" || t.TripElementCode.Contains(textBox1.Text))
                             && (textBox1.Text.Trim() == "" || t.TripElementName.Contains(textBox1.Text))
                             && (textBox1.Text.Trim() == "" || t.SegmentTypeCode.Contains(textBox1.Text))

                             select new
                             {
                                 TripElementID = t.TripElementID,
                                 SegmentTypeCode = t.SegmentTypeCode,
                                 TripElementCode = t.TripElementCode,
                                 tripElementName = t.TripElementName
                             };
[/code]

Then only SegementTypeCOde is working - it returns results, but not TripElementCOde - it doens retun anything.

Hi,

THX,

yes, I try it like this:

[code]
 var selectTrip = from t in context.TripElements
                             where (textBox1.Text.Trim() == "" || t.TripElementCode.Contains(textBox1.Text))
                             && (textBox1.Text.Trim() == "" || t.TripElementName.Contains(textBox1.Text))
                             &&(textBox1.Text.Trim() == ""   || t.SegmentTypeCode.Contains(textBox1.Text))                  
                                                       
                             select new
                             {
                                 TripElementID = t.TripElementID,
                                 SegmentTypeCode = t.SegmentTypeCode,
                                 TripElementCode = t.TripElementCode,
                                 tripElementName = t.TripElementName
                             };
[/code]

But then I can search on AC(SegmentTypeCode) it returns the values, but if I try nok(TripElementCode) then It doesn returns a value. But the DB has values:

try this:

var selectTrip = from t in context.TripElements
                             where SqlMethods.Like(textBox1.Text.Trim(), t.TripElementCode) &&  SqlMethods.Like(textBox1.Text.Trim(),t.TripElementName )
                           
                             select new
                             {
                                 Trip_ID = t.TripElementID,
                                 Trip_Code = t.TripElementCode,
                                 trip_ElementName = t.TripElementName
                             };

I also try this:

public void rep_bind()
        {

            DataClasses1DataContext context = new DataClasses1DataContext(_connectionString);
            var selectTrip = from t in context.TripElements
                             where SqlMethods.Like(textBox1.Text.Trim(), "%" + t.TripElementCode + "%" ) &&
                             SqlMethods.Like(textBox1.Text.Trim(), "%" + t.TripElementName + "%")
                             // where SqlMethods.Like(textBox1.Text.Trim(), "%" + t.EMP_ID)
                             select new
                             {
                                 Trip_ID = t.TripElementID,
                                 Trip_Code = t.TripElementCode,
                                 trip_ElementName = t.TripElementName
                             };

            dataGridView1.DataSource = selectTrip;
            textBox1.Text = "";
        }

but then also there are now returning results

THX for your replay.

Bur for example if I try this:

 public void rep_bind()
        {
DataClasses1DataContext context = new DataClasses1DataContext(_connectionString);
            var selectTrip = from t in context.TripElements
                             where SqlMethods.Like(textBox1.Text.Trim(), "%"+t.TripElementCode+"%" /*+ "%"+t.TripElementName + "%" +*/ + t.TripElementName.Contains(t.TripElementName))
                            // where SqlMethods.Like(textBox1.Text.Trim(), "%" + t.EMP_ID)
                             select new
                             {
                                 Trip_ID = t.TripElementID,
                                 Trip_Code = t.TripElementCode,
                                 trip_ElementName = t.TripElementName
                             };

            dataGridView1.DataSource = selectTrip;
            textBox1.Text = "";
}

I get this error:

Only arguments that can be evaluated on the client are supported for the String.Contains method.

hi,
Refer to this link it may help you.

http://stackoverflow.com/questions/7569725/linq-like-search-across-multiple-fields