News Rollup WebPart in SharePoint 2013

Open SharePoint Site.



Create a simple list named “News”.



Open Visual studio.

Create a new SharePoint 2013 empty project.

Add a visual webpart into the SharePoint solution named “News rollup”.





Now add a repeater control into the News Rollup.ascx.

Code:

1. <asp:Repeater ID="rptsmartspeak" runat="server">  
2.    <ItemTemplate>  
3.           
4.         <%#DataBinder.Eval(Container.DataItem,"Date")%>   
5.         <br />  
6.         <h2 style="padding-top: 5px; font-weight: 700; font-size: 12px;"><%#DataBinder.Eval(Container.DataItem,"Title")%></h2>  
7.         <br />  
8.         <br />  
9.         <p  style="margin-top: -39px;">  
10.             <%#FormatDescription(Container.DataItem,"Description")%>  
11.                                       
12.         </p>  
13.        <hr />  
14.     </ItemTemplate>  
15. </asp:Repeater>  

To bind the data into the repeater from SharePoint lists.

Download CAML Query builder.

Click here to download U2U CAML Query builder.

After installation, I am going to generate a query to retrieve the Isactive values from the news list.



Code

1. using Microsoft.SharePoint;  
2. using System;  
3. using System.ComponentModel;  
4. using System.Web.UI.WebControls.WebParts;  
5.   
6. namespace News.News_Rollup  
7. {  
8.     [ToolboxItemAttribute(false)]  
9.     public partial class News_Rollup : WebPart  
10.     {  
11.         // Uncomment the following SecurityPermission attribute only when doing Performance Profiling on a farm solution  
12.         // using the Instrumentation method, and then remove the SecurityPermission attribute when the code is ready  
13.         // for production. Because the SecurityPermission attribute bypasses the security check for callers of  
14.         // your constructor, it's not recommended for production purposes.  
15.         // [System.Security.Permissions.SecurityPermission(System.Security.Permissions.SecurityAction.Assert, UnmanagedCode = true)]  
16.         public News_Rollup()  
17.         {  
18.         }  
19.   
20.         protected override void OnInit(EventArgs e)  
21.         {  
22.             base.OnInit(e);  
23.             InitializeControl();  
24.         }  
25.   
26.         protected void Page_Load(object sender, EventArgs e)  
27.         {  
28.             if(!Page.IsPostBack)  
29.             {  
30.                 Bindspeaker();  
31.             }  
32.         }  
33.         private void Bindspeaker()  
34.         {  
35.             using (SPSite site = new SPSite(SPContext.Current.Site.Url))  
36.             {  
37.                 using (SPWeb web = site.OpenWeb())  
38.                 {  
39.                     SPList list = web.Lists["News"];  
40.                     if (list != null)  
41.                     {  
42.                         SPQuery query = new SPQuery();  
43.                         query.Query = "<Where><Eq><FieldRef Name='Isactive' /><Value Type='Boolean'>1</Value></Eq></Where>";  
44.                         SPListItemCollection collitem = list.GetItems(query);  
45.   
46.                         rptsmartspeak.DataSource = collitem.GetDataTable();  
47.                         rptsmartspeak.DataBind();  
48.   
49.                     }  
50.                 }  
51.             }  
52.         }  
53.     }  
54. }  

Now I am going to do some customization of my repeater control to view the news stylish.

Full code
News Rollup.ascx

1. <%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %>  
2. <%@ Assembly Name="Microsoft.Web.CommandUI, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>   
3. <%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>   
4. <%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>  
5. <%@ Register Tagprefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %>  
6. <%@ Import Namespace="Microsoft.SharePoint" %>   
7. <%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>  
8. <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="News Rollup.ascx.cs" Inherits="News.News_Rollup.News_Rollup" %>  
9. <div style="height:150px; width:200px" >  
10. <table  style="width:100%" >  
11.     <tr>  
12.         <td  style="width:10%" ></td>  
13.         <td  style="width:80%" >  
14.              <marquee  behavior="scroll" direction="up" scrollamount="3" onmouseover="stop();"  onmouseout="start()";>  
15.     <div class="smartspeak" style="padding-right: 20px; height:300px; width:280px;">  
16.  <asp:Repeater ID="rptsmartspeak" runat="server">  
17.                    <ItemTemplate>  
18.                           
19.                         <%#DataBinder.Eval(Container.DataItem,"Date")%>   
20.                         <br />  
21.                         <h2 style="padding-top: 5px; font-weight: 700; font-size: 12px;"><%#DataBinder.Eval(Container.DataItem,"Title")%></h2>  
22.                         <br />  
23.                         <br />  
24.                         <p  style="margin-top: -39px;">  
25.                             <%#FormatDescription(Container.DataItem,"Description")%>  
26.                                                       
27.                         </p>  
28.                        <hr />  
29.                     </ItemTemplate>  
30.                 </asp:Repeater>  
31.          </div>         
32.         </marquee>  
33.           </td>  
34.         <td  style="width:10%" ></td>  
35.   
36.     </tr>  
37. </table>  

News Rollup.ascx.cs

1. using Microsoft.SharePoint;  
2. using System;  
3. using System.ComponentModel;  
4. using System.Web.UI;  
5. using System.Web.UI.WebControls.WebParts;  
6.   
7. namespace News.News_Rollup  
8. {  
9.     [ToolboxItemAttribute(false)]  
10.     public partial class News_Rollup : WebPart  
11.     {  
12.         // Uncomment the following SecurityPermission attribute only when doing Performance Profiling on a farm solution  
13.         // using the Instrumentation method, and then remove the SecurityPermission attribute when the code is ready  
14.         // for production. Because the SecurityPermission attribute bypasses the security check for callers of  
15.         // your constructor, it's not recommended for production purposes.  
16.         // [System.Security.Permissions.SecurityPermission(System.Security.Permissions.SecurityAction.Assert, UnmanagedCode = true)]  
17.         public News_Rollup()  
18.         {  
19.         }  
20.   
21.         protected override void OnInit(EventArgs e)  
22.         {  
23.             base.OnInit(e);  
24.             InitializeControl();  
25.         }  
26.   
27.         protected void Page_Load(object sender, EventArgs e)  
28.         {  
29.             if (!Page.IsPostBack)  
30.             {  
31.                 Bindspeaker();  
32.             }  
33.         }  
34.         private void Bindspeaker()  
35.         {  
36.             using (SPSite site = new SPSite(SPContext.Current.Site.Url))  
37.             {  
38.                 using (SPWeb web = site.OpenWeb())  
39.                 {  
40.                     SPList list = web.Lists["News"];  
41.                     if (list != null)  
42.                     {  
43.                         SPQuery query = new SPQuery();  
44.                         query.Query = "<Where><Eq><FieldRef Name='Isactive' /><Value Type='Boolean'>1</Value></Eq></Where>";  
45.                         SPListItemCollection collitem = list.GetItems(query);  
46.   
47.                         rptsmartspeak.DataSource = collitem.GetDataTable();  
48.                         rptsmartspeak.DataBind();  
49.   
50.                     }  
51.                 }  
52.             }  
53.         }  
54.         protected string FormatDescription(object item, string fieldName)  
55.         {  
56.             if (string.IsNullOrEmpty(DataBinder.Eval(item, fieldName).ToString()))  
57.             {  
58.                 return string.Empty;  
59.             }  
60.             else  
61.             {  
62.                 string text = DataBinder.Eval(item, fieldName).ToString();  
63.                 if (text.Length < 250)  
64.                     return string.Format("{0}", text);  
65.                 return string.Format("{0}", text.Substring(0, 250));  
66.             }  
67.         }  
68.   
69.     }  
70. }  

Now deploy the solution.

After deploying, the webpart adds some news contents into the SharePoint list.

 



The final result is.