How to select more colums with LIke

Question

HI everybody I have this: [code] 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 = ; } [/code] But that doenst work. THX for helping

albert albert · Answer

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.

albert albert · Answer

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:

Sanjeeb Lenka · Answer

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 };

albert albert · Answer

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

albert albert · Answer

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.

Sanjeeb Lenka · Answer

hi Refer to this link it may help you. http://stackoverflow.com/questions/7569725/linq-like-search-across-multiple-fields