StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSharePoint 2010: Linq to Objects, Check if User is in another List and use of current Item
text
Body
copied!<p>my use-case: I have 2 SPLists, let's call one events, the other attendees. What I want: Show a "register" or "unregister" button (in a visual web part at the dispform of the event-list) depending of the current User can be located in the attendee-list for the current event. So, if the current user is registered for the event, page_load should show the "unregister"-button or the "register"-button if he's not. </p> <p>I get the current Item via </p> <p><code>currEventItem = (SPListItem)SPContext.Current.Item;</code> </p> <p>And the current user via</p> <p><code>currentUser = website.CurrentUser; userString = currentUser.ID.ToString() + ";#" + currentUser.LoginName.ToString();</code></p> <p>Now I wanted to use System.Linq (Linq to Objects) to execute the following Query (pseudo-sqlsyntax):</p> <p><code>select * from AttendeeList where userString equals attendeeList.Name AND currEventItem.Title equals AttendeeList.EventTitle</code></p> <p>The Name-Field in the attendeeList is a user (person or group, using german version here so I hope this is the actual translation) field. </p> <p>My Problem, and the actual question: I don't get the linq syntax to work. Could anyone help me out here? Would be great!</p> <p>edit: Later on, I want to show the corresponding button depending on the result is NULL or not NULL. Hope this works? If this is not the way to go, another solution would be greatly appreciated :) </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload