Would anyone be willing to show me how to write the code to use SPContext in order to get the UserName (without Domain) of the currently logged in SharePoint user, and then to Query a SQL Server external content source for items in a field called "Assignee" where the logged in name is contained in the Assignee?
Further, could you then tell me how to load that query into a RadGrid by default.... But to be able to clear the filter (or apply a new one) when desired?
Further, could you then tell me how to load that query into a RadGrid by default.... But to be able to clear the filter (or apply a new one) when desired?
1 Answer, 1 is accepted
0
Hi,
Marin
the Telerik team
The SPContext.Current.Web.CurrentUser.LoginName return the user and the domain but you can easily split the string and get only the user name.
You can query an external SQL server using BCS in SP 2010 as shown in this article.
You can use the NeedDataSource event of the grid to bind to any data by default. There you can also change the datasource when the filter is cleared.
Marin
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.