ASCX.CS(.ascx.cs)

STEP 1: Create a VisualWebPart like DepartmentNavigation

STEP 2: Write a coding in DepartmentNavigationUserControl.ascx.cs


STEP 3:

using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data;
using Microsoft.SharePoint;
using VCSB.INTRANET.BLL;
using System.Linq;

namespace VCSB01.INTRANET.VCSBWebPart.DepartmentNavigation
{
    public partial class DepartmentNavigationUserControl : UserControl
    {
        protected void Page_Load(object sender, EventArgs e)
        {

            if (!IsPostBack)
            {
                BindDeptNavigationData();

            }
          
        }
        private void BindDeptNavigationData()
        {
           
            DataTable dt = new DataTable();
            dt.Columns.Add("PageUrl");
            dt.Columns.Add("PageName");
            DataRow row;
            SPSecurity.RunWithElevatedPrivileges(delegate()
            {
                using (VCSBINTRANETDataContext cont = new VCSBINTRANETDataContext(SiteHelper.SiteUrl))
                {
                    var quer = from navigationData in cont.Pages
                               orderby navigationData.Id descending
                               select navigationData;

                    if (quer != null)
                    {
                       foreach (SPListItem uitem in SPContext.Current.Web.Lists["Pages"].Items)
                        {
                            row = dt.Rows.Add();
                            row["PageUrl"] = Convert.ToString(SPContext.Current.Web.Url+"//"+uitem.Url);
                            string pagename =Convert.ToString(uitem.Name);
                            if (!string.IsNullOrEmpty(pagename))
                            {
                                string[] pagename1 = pagename.Split('.');
                                row["PageName"] = Convert.ToString(pagename1[0]);
//  row["PageName"] =Convert.ToString(pagename.Split('.').GetValue(0));
                            }
                        }
                    }
                }
            });
            grdDeptNavigation.DataSource = dt;
            grdDeptNavigation.DataBind();
        }
    }
}