Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
 
TECHNOLOGIES:
 

Web Part in SharePoint To Show All List and List Items

Article:
Viewed:  5029 
Posted On:  11/08/2013 13:25:14 
How to deploy Visual Web Part in SharePoint...? How to Show all List..? How to show All items of a selected List in SharePoint...? 

In this article I am going to show how we can create a Visual Web Part and how we can deploy web part.

In this web part I am showing a drop down list in which I am binding All SharePoint List and on selecting a particular list I am showing all items of this selected list in a GridView.

We will learn it step by step…

Open Visual Studio and select Blank SharePoint Project..

1.png


Image 1.

Give your  SharePoint site URL and validate…

2.png


Image 2.

Now Right Click on Solution Explorer and add a Visual Web part…

3.png

Image 3.

Now design your web part.. my ascx is:

<%@AssemblyName="$SharePoint.Project.AssemblyFullName$"%>
<%@AssemblyName="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"%>
<%@RegisterTagPrefix="SharePoint"Namespace="Microsoft.SharePoint.WebControls"
Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"%>
<%@RegisterTagPrefix="Utilities"Namespace="Microsoft.SharePoint.Utilities"Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral,
PublicKeyToken=71e9bce111e9429c"
%>
<%@RegisterTagPrefix="asp"Namespace="System.Web.UI"Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"%>
<%@ImportNamespace="Microsoft.SharePoint"%>
<%@RegisterTagPrefix="WebPartPages"Namespace="Microsoft.SharePoint.WebPartPages"
Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"%>
<%@ControlLanguage="C#"AutoEventWireup="true"CodeBehind="ShowListUserControl.ascx.cs"
Inherits="WVP_ShowListItem.ShowList.ShowListUserControl"%>
<tablecellpadding="4"cellpadding="4"width="90%"align="center"style="border: solid 1px Gray;">
<tr>
<td>
<asp:LabelID="lblErrorMsg"ForeColor="Red"runat="server"></asp:Label><br/>
<asp:LabelID="lblSelectList"runat="server"Text="Select Your List"></asp:Label>
&nbsp;
<asp:DropDownListID="ddlListCollection"runat="server"OnSelectedIndexChanged="ddlListCollection_SelectedIndexChanged"
AutoPostBack="true">
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:GridViewID="grdListItem"runat="server"EmptyDataText="There is no item."EmptyDataRowStyle-ForeColor="Red">
</asp:GridView>
</td>
</tr>
</table>
 

My ascx.cs is:

using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data;
using System.Data.SqlClient;
using Microsoft.SharePoint; 

namespace WVP_ShowListItem.ShowList
{
    public partial class ShowListUserControl : UserControl
   {
        protected void Page_Load(object sender, EventArgs e)
        {
             if (!Page.IsPostBack)
                    BindAllListName();
         }

         private void
BindAllListName()
         {
              try
             {
                  DataTable dt = newDataTable();
                 dt.Columns.Add("TitleName", typeof(string));
                 using (SPSite site = newSPSite("http://localhost:7000"))
                 {
                      using (SPWeb web = site.OpenWeb())
                      {
                           foreach (SPList oList in web.Lists)
                           {
                                DataRow dr = dt.NewRow();
                                dr["TitleName"] = oList.Title.ToString();
                                dt.Rows.Add(dr);
                           }
                           ddlListCollection.DataSource = dt;
                           ddlListCollection.DataValueField = "TitleName";
                           ddlListCollection.DataTextField = "TitleName";
                           ddlListCollection.DataBind();
                      }
                }
            }
             catch (SPException exp)
             {
                    lblErrorMsg.Text = exp.Message.ToString();
              }
        } 

       protected void ddlListCollection_SelectedIndexChanged(object sender, EventArgs e)
        {
             using (SPSite site = newSPSite("http://localhost:7000"))
             {
                   using (SPWeb web = site.OpenWeb())
                  {
                        SPList list = web.Lists[ddlListCollection.SelectedValue.ToString()];
                         SPListItemCollection items = list.Items;
                          if (items.GetDataTable().Rows.Count > 0)
                         {
                                grdListItem.DataSource = items.GetDataTable();
                                grdListItem.DataBind();
                         }
                         else
                         {
                                grdListItem.DataSource = null;
                                grdListItem.DataBind();
                         }
                  }
            }
        }
     }
}

Now Right Click on Solution Explorer and Click on Deploy

After successfully deployed Open your Site and Select page where you want to add this web part. In this solution I am going to use this web part on MyTest2.aspx page so go to page and click on Edit:

Click on insert -> Select Web Part -> Select Custom -> Select Your web part -> Click Add.

4.png


Image 4.

Save & Close.

Now open you page: All list will display in drop down

5.png


Image 5.

 Select A List…

6.png

Image 6.

Now select any list and see all items of selected List.

  Comment:
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us