Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How to connect SharePoint 2010 list to Telerik RadGrid
Posted on 2012-12-20
I want to populate a RadGrid with SharePoint 2010 list data. I cannot figure out how this is accomplished.
Here is my ASPX page:
Here is my code-behind:
I don't know if this is the best way to start, but I do know something is wrong because I cant render any data. Plus, I don't understand why by RadGrid ID will not compile. I get an error stating "The name 'GridView1' does not exist in the current context". Why. That is the ID of my RadGrid.
My end goal is to create a RadGrid that I can filter by individual columns, such as: name, client#, topic, etc. I am not sure if the filtering allows for multiple entries, but I would like to be able to filter on more than one criteria. Also, wildcard searches are very important.
Thank you for the help!
Here is my ASPX page:
<SPWebControls:SPDataSource runat="server" ID="dsclientmatter" DataSourceMode="ListItem" UseInternalName="true">
<SelectParameters>
<asp:Parameter Name="WebUrl" DefaultValue="/configuration/" />
<asp:Parameter Name="ListID" DefaultValue="4056449D-1884-4C79-AAAD-CD0ABEB2F854" />
<asp:Parameter Name="ListItemID" DefaultValue="1" />
</SelectParameters>
</SPWebControls:SPDataSource>
<telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None" ShowStatusBar="true" PageSize="7" AllowPaging="True" DataSourceID="dsclientmatter" >
<ClientSettings>
<Selecting AllowRowSelect="True" />
</ClientSettings>
<MasterTableView datasourceid="">
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
</MasterTableView>
<FilterMenu EnableImageSprites="False"></FilterMenu>
</telerik:RadGrid>
Here is my code-behind:
protected void Page_Load(object sender, EventArgs e)
{
SPSite site = new SPSite("http://abcdev");
using (SPWeb web = site.OpenWeb())
{
SPList clientlist = web.Lists.TryGetList("clientmatter");
DataTable dt = new DataTable();
SPQuery query = new SPQuery();
query.ViewFields = "<Where><Eq><FieldRef Name='clientid'/><Value Type='Text'>12345</Value></Eq></Where>";
SPListItemCollection items = clientlist.GetItems(query);
if(items != null)
{
if(items.Count > 0)
{
dt = items.GetDataTable();
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
}
I don't know if this is the best way to start, but I do know something is wrong because I cant render any data. Plus, I don't understand why by RadGrid ID will not compile. I get an error stating "The name 'GridView1' does not exist in the current context". Why. That is the ID of my RadGrid.
My end goal is to create a RadGrid that I can filter by individual columns, such as: name, client#, topic, etc. I am not sure if the filtering allows for multiple entries, but I would like to be able to filter on more than one criteria. Also, wildcard searches are very important.
Thank you for the help!
[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
-
3
4 Comments
First of all, create the columns that you want to display in the rad grid in the .aspx file.
in your code behind
write a function that loads the data into the rad grid.
create a data table and create the columns that are needed to store the values.
create a function that returns the data table.
inside that data table get the data from the list and assign each data to the columns that are created for the data table and return the data table.
now in the page load event
if it is not post back then load the function where you will assign the data source of the current rad grid to function that return the data table.
there is one function called needdatasource event in the rad grid.
if you click on the rad grid in the aspx file and check the event properties of the rad grid you can see needdatasource double click on that and write the code that will bind the data source with the data table.
i don't want to write the code here unless you need it there are bunch of examples about this i hope. you can also search in telerik forums they are of great help.
in your code behind
write a function that loads the data into the rad grid.
create a data table and create the columns that are needed to store the values.
create a function that returns the data table.
inside that data table get the data from the list and assign each data to the columns that are created for the data table and return the data table.
now in the page load event
if it is not post back then load the function where you will assign the data source of the current rad grid to function that return the data table.
there is one function called needdatasource event in the rad grid.
if you click on the rad grid in the aspx file and check the event properties of the rad grid you can see needdatasource double click on that and write the code that will bind the data source with the data table.
i don't want to write the code here unless you need it there are bunch of examples about this i hope. you can also search in telerik forums they are of great help.
Telerik support replied via email and I wanted to post it here:
I will look into this Telerik solution and the one offered by kukdai and post a reply soon.
RadGrid, by itself, does not support binding to SPLists directly, neither can it handle an SPDataSource control.
However, there is a solution that you can employ in your project. Our controls for SharePoint go with an extension of RadGrid, called SPRadGrid. It is a standalone class that offers a built-in support for binding to SharePoint lists. What you need to do is to download the installer for the Telerik web parts for SharePoint 2010.
Go to Manager your producets -> Download Installer and Other Resources -> (Under RadControls for ASP.NET AJAX) Browser all product lines -> SharePoint 2007/2010 -> SharePoint 2010 Web Parts - Manual Installation. Within the zip file there is a wsp - make that with a .rar/.zip extension and extract the Telerik.Ajax.SharePoint.dll. In the dll, you will find the SPRadGrid class. Alternatively, you can download and run the installer of our extensions for SharePoint 2010 - it will install the web parts (you can use them or not as per your scenario) and deploy the dll to the GAC where you can safely reference it from.
I will look into this Telerik solution and the one offered by kukdai and post a reply soon.
I found an answer how to connect to an external list posted by http://blah.winsmarts.com/2010-3-Telerik_Silverlight_Grid_with_BCS_Lists_in_SharePoint_2010.aspx My implementation of his example is added below.
MainPage.xaml.cs
MainPage.xaml.cs
private List<Matters> matters = new List<Matters>();
private IEnumerable<ListItem> returnedItems = null;
public MainPage()
{
InitializeComponent();
this.Loaded += new RoutedEventHandler(MainPage_Loaded);
}
void MainPage_Loaded(object sender, RoutedEventArgs e)
{
ClientContext context = ClientContext.Current;
returnedItems = context.LoadQuery(
context.Web.Lists.GetByTitle("myExternalListName").GetItems(new CamlQuery())
);
context.ExecuteQueryAsync(succeededCallback, failedCallback);
}
void succeededCallback(object sender, ClientRequestSucceededEventArgs e)
{
this.Dispatcher.BeginInvoke(() =>
{
matters.Clear();
foreach (var item in returnedItems)
{
matters.Add(new Matters(item));
}
radGridView1.ItemsSource = matters;
}
);
}
void failedCallback(object sender, ClientRequestFailedEventArgs e)
{
MessageBox.Show(e.ErrorDetails.ToString(), "Error", MessageBoxButton.OK);
}
<Grid x:Name="LayoutRoot" Background="White" Height="580">
<controls:RadGridView Name="radGridView1" HorizontalAlignment="Left" VerticalAlignment="Top" Margin="12,12,0,0" CanUserSelect="True" CanUserFreezeColumns="False" AutoExpandGroups="False" AutoGenerateColumns="False" CanUserDeleteRows="False" AlternateRowBackground="CadetBlue" Width="600">
<controls:RadGridView.Columns>
<controls:GridViewDataColumn Header="Client Name" DataMemberBinding="{Binding ClientName}" />
<controls:GridViewDataColumn Header="Client Num" DataMemberBinding="{Binding ClientNum}" />
<controls:GridViewDataColumn Header="Billing Attorney" DataMemberBinding="{Binding BillingName}" />
</controls:RadGridView.Columns>
</controls:RadGridView>
<telerik:RadDataPager PageSize="100" Width="600" HorizontalAlignment="Left" Source="{Binding Items, ElementName=GridView}"
IsTotalItemCountFixed="True"
DisplayMode="FirstLastPreviousNextNumeric, Text" Margin="0,552,0,0" />
</Grid>
private ListItem _item;
public myClassFileName(ListItem item) { _item = item; }
public string ClientName { get { return _item.FieldValues["Client_Name"].ToString(); } }
public string ClientNum { get { return _item.FieldValues["Client_Number"].ToString(); } }
public string BillingName { get { return _item.FieldValues["Billing_Name"].ToString(); } }
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done?
Scenario
For a recent pr…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
The purpose of this video is to demonstrate how to set up the WordPress backend so that each
page automatically generates a Mailchimp signup form in the sidebar.
This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month7 days, 3 hours left to enroll
Earn Certification
MTA - Cloud Fundamentals - 98-369
$59.00$53.10
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.