Solved

Linq Data Source - adding a where clause

Posted on 2011-09-12
11
322 Views
Last Modified: 2012-05-12
Newby question related to LINQ and LINQ DataSource.

I have a standard ASP web page with a gridview attached to a linq data source.  A sort order is applied to the data so the most important data is generally at the top but sometimes I need to search (a very simple search)...

I have the code working by putting a hard coded string into .Where but I am confident that is NOT the best way to do this.

With User_Grid_LinqDataSource
   .Where = "First_Name.Contains(@SearchText) or Last_Name.Contains(@SearchText)"
   .WhereParameters.Clear()
   .WhereParameters.Add("SearchText", txtSearch.Text.Trim)
End With

The rest of the story...  I have 2 distinct searches based on a combo-box. 'Name' is shown above and 'Address' is the other one.

How do I use linq to apply different where clauses?

0
Comment
Question by:jongrossex
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 3
11 Comments
 
LVL 9

Expert Comment

by:dexterrajesh
ID: 36524595
hi,

pl refer here for some quick samples: http://msdn.microsoft.com/en-us/library/bb397927.aspx
0
 

Author Comment

by:jongrossex
ID: 36524813

Thanks. My questions was NOT clear, my fault.

I understand how to create the LINQ query but I do not understand how to associate it back with the LinkDataSource so that it is reflected in the grid.

So after I do the query like below...

var queryLondonCustomers = from cust in customers
                           where cust.City == "London"
                           select cust;

How do I associate the results with the data source so that it will be displayed on the grid.  I assume it is simple but I can not find the answer... or is there a better way to think about this.

-Jon

0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 36526202
Try using the Where property of the LinqDataSource itself to do the filtering

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.linqdatasource.where.aspx
0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 

Author Comment

by:jongrossex
ID: 36527153
We are getting closer...  but from the above link I do not want my query coded in a string.

The following code attaches linq data to a gridview

Dim db As New SjuDatalassesDataContext
Dim searchText As String = txtSearch.Text.Trim
Dim userList = From u In db.vUser Where u.First_Name.Contains(searchText) Select u
grid.DataSourceID = Nothing
grid.DataSource = userList
grid.DataBind()

How do I either
- tell the LinqDataSource 'control' to execute the query from the above Linq command
OR
- attached userlist to the LinqDataSource 'control'


0
 
LVL 9

Expert Comment

by:dexterrajesh
ID: 36527809
hi

can you give a try to the select property of the linqdatasource control http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.linqdatasource.select.aspx

Linqdatasource control is meant to perform the linq operations..... hence it comes with all required properties and methods to perform linq operations... I am not sure why you want to deviate from this...
0
 

Author Comment

by:jongrossex
ID: 36529238

What I am trying to get away from is a string for the where clause
   .Where = "First_Name.Contains(@SearchText) or Last_Name.Contains(@SearchText)"

If my data model changes I do not find out till runtime

Does the 'linqdatasource' have a property that allows me to add a link command?  For example:
From u In db.vUser Where u.First_Name.Contains(searchText) Select u
I have looked and did not see any such functionality.

Thanks for your help
0
 
LVL 9

Expert Comment

by:dexterrajesh
ID: 36530384
no you can't do that...
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 36531946
0
 

Author Comment

by:jongrossex
ID: 36533903
That seems exactly what I was looking for.  I will give it a try tomorrow.

Always enjoy Scott Gu's blogs.
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 36570193
Any Luck?
0
 

Author Comment

by:jongrossex
ID: 36570316
Sorry for the delay... that was perfect.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Set the FileVersion of a website dll 1 59
FTP recursive download files 5 27
Send parameters via datatable ajax call 4 44
Disable the weekends on datepicker control 6 52
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question