Nested ListView

Sample 

Output

----------------------------------

<style type="text/css">

        .collapse

        {

            background-position: left -172px;

            height: 14px;

            width: 13px;

            background-repeat: no-repeat;

            background-image: url('DXR1.png');

            cursor: pointer;

        }

        .expand

        {

            background-position: -14px -187px;

            height: 14px;

            width: 13px;

            background-repeat: no-repeat;

            background-image: url('DXR.png');

            cursor: pointer;

        }

        table

        {

            border: solid 0px black;

        }

        table td

        {

            border-right: solid 0px black;

            border-bottom: solid 0px black;

        }

        table th

        {

            border-bottom: solid opx black;

        }

        .SUBDIV table

        {

            border: 0px;

            border-left: 0px solid black;

        }

    </style>

    <script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script>

    <script language="javascript" type="text/javascript">

        $(document).ready(function () {

            // THIS IS FOR HIDE ALL DETAILS ROW

            $(".SUBDIV table tr:not(:first-child)").not("tr tr").hide();

            $(".SUBDIV .btncolexp").click(function () {

                $(this).closest('tr').next('tr').toggle();

                //this is for change img of btncolexp button

                if ($(this).attr('class').toString() == "btncolexp collapse") {

                    $(this).addClass('expand');

                    $(this).removeClass('collapse');

                }

                else {

                    $(this).removeClass('expand');

                    $(this).addClass('collapse');

                }

            });

        });

    </script>

    <div>

        <asp:ListView ID="ListView1" runat="server" OnItemDataBound="ListView1_ItemDataBound">

            <LayoutTemplate>

                <table width="100%" border="1" cellpadding="0" cellspacing="0">

                   <tr id="Tr2" style="background-color: #DCDCDC; color: #000000;">

                        <th style="width: 2%">

                            &nbsp;

                        </th>

                        <th id="Th2" style="width: 20%">

                            Manager Name

                        </th>

                        <th id="Th3" style="width: 20%">

                            A

                        </th>

                        <th id="Th4" style="width: 20%">

                            B

                        </th>

                        <th id="Th5" style="width: 20%">

                            C

                        </th>

                        <th id="Th6" style="width: 20%">

                            D

                        </th>

                    </tr>

                </table>

                <div runat="server" id="itemPlaceHolder">

                </div>

            </LayoutTemplate>

            <ItemTemplate>

                <div id="Div1" class="SUBDIV" runat="server">

                    <table width="100%" border="0" cellpadding="0" cellspacing="0">

                        <tr style="background-color: #F3FCEC; color: #000000;">

                            <td style="width: 2%">

                                <div class="btncolexp collapse">

                                    &nbsp;

                                </div>

                            </td>

                            <td style="width: 20%">

                                <asp:HiddenField ID="HdnManagerId" runat="server" Value='<%#Eval("MID") %>' />

                                <asp:Label ID="PriceDescLabel" runat="server" Text='<%# Eval("ManagerName") %>' />

                            </td>

                            <td style="width: 20%">

                                <asp:Label ID="ALabel" runat="server" Text='<%# Eval("A") %>' />

                            </td>

                            <td style="width: 20%">

                                <asp:Label ID="BLabel" runat="server" Text='<%# Eval("B") %>' />

                            </td>

                            <td style="width: 20%">

                                <asp:Label ID="CLabel" runat="server" Text='<%# Eval("C") %>' />

                            </td>

                            <td style="width: 20%">

                                <asp:Label ID="DLabel" runat="server" Text='<%# Eval("D") %>' />

                            </td>

                        </tr>

                        <tr>

                            <td colspan="6" style="width:100%;">

                                    <asp:ListView ID="ListView2" runat="server">                                        

                                        <LayoutTemplate>

                                            <table id="Table1" runat="server" style="width:100.7%; margin: -3px -3px -3px -3px;">

                                                <tr id="Tr1" runat="server">

                                                    <td id="Td1" runat="server">

                                                        <table id="itemPlaceholderContainer" runat="server" style="width: 100%;

                                                            background-color: #A3F5F3; border-collapse: collapse; border-color: #999999;

                                                            border-style: none; border-width: 1px; font-family: Verdana, Arial, Helvetica, sans-serif;">

                                                            <tr id="itemPlaceholder" runat="server">

                                                            </tr>

                                                        </table>

                                                    </td>

                                                </tr>

                                            </table>

                                        </LayoutTemplate>

                                        <ItemTemplate>

                                            <tr style="background-color: #A3F5F3; color: #000000;">

                                                <td style="width: 2%">

                                                    &nbsp;

                                                </td>

                                                <td style="width: 20%">

                                                    <asp:Label ID="PriceDescLabel" runat="server" Text='<%# Eval("PriceDesc") %>' />

                                                </td>

                                                <td style="width: 20%">

                                                    <asp:Label ID="ALabel" runat="server" Text='<%# Eval("A") %>' />

                                                </td>

                                                <td style="width: 20%">

                                                    <asp:Label ID="BLabel" runat="server" Text='<%# Eval("B") %>' />

                                                </td>

                                                <td style="width: 20%">

                                                    <asp:Label ID="CLabel" runat="server" Text='<%# Eval("C") %>' />

                                                </td>

                                                <td style="width: 20%">

                                                    <asp:Label ID="DLabel" runat="server" Text='<%# Eval("D") %>' />

                                                </td>

                                            </tr>

                                        </ItemTemplate>

                                    </asp:ListView>

                            </td>

                        </tr>

                    </table>

                </div>

            </ItemTemplate>

        </asp:ListView>

    </div>

---------------------------------------------------------------------

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

namespace HierachicalListViewDemo

{

    public partial class WebForm1 : System.Web.UI.Page

    {

        string connection = ConfigurationManager.ConnectionStrings["TestConnectionString"].ConnectionString;

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                PopulateFirstListData();

            }

        }

        private void PopulateFirstListData()

        {

            SqlConnection con = new SqlConnection(connection);

            SqlDataAdapter da = new SqlDataAdapter("SELECT MAX(ManagerName) as ManagerName, MAX(PriceDesc) as PriceDesc, Sum(A) as A, SUM(B) as B,SUM(C) as C,SUM(D) as D, MID FROM dbo.ExceptionList excp left join dbo.Manager Mgr on excp.ManagerId = Mgr.MID Group by MID", con);

            DataSet ds = new DataSet();

            da.Fill(ds);

            ListView1.DataSource = ds;

            ListView1.DataBind();

        }

        private DataSet PopulateSecondListData(int ManagerId)

        {

            SqlConnection con = new SqlConnection(connection);

            SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM dbo.ExceptionList where ManagerId=" + ManagerId, con);

            DataSet ds = new DataSet();

            da.Fill(ds);

            return ds;

        }

        protected void ListView1_ItemDataBound(object sender, ListViewItemEventArgs e)

        {

            if (e.Item.ItemType == ListViewItemType.DataItem)

            {

                HiddenField hdnManagerId = (HiddenField)e.Item.FindControl("HdnManagerId");

                ListView listview2 = (ListView)e.Item.FindControl("ListView2");

                DataSet list2ds = PopulateSecondListData(Convert.ToInt32(hdnManagerId.Value));

                listview2.DataSource = list2ds;

                listview2.DataBind();

            }

        }

    }

}

--------------------------------------------------------

<add name="TestConnectionString" connectionString="Data Source=.;Initial Catalog=test;Integrated Security=True" providerName="System.Data.SqlClient" />

--------------------------------------------------------

Tables

-------------------------------

CREATE TABLE [dbo].[Region](

[RID] [int] IDENTITY(1,1) NOT NULL,

[RegionName] [varchar](50) NOT NULL,

 CONSTRAINT [PK_Region] PRIMARY KEY CLUSTERED 

(

[RID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

SET IDENTITY_INSERT [dbo].[Region] ON

INSERT [dbo].[Region] ([RID], [RegionName]) VALUES (1, N'North')

INSERT [dbo].[Region] ([RID], [RegionName]) VALUES (2, N'South')

INSERT [dbo].[Region] ([RID], [RegionName]) VALUES (3, N'East')

INSERT [dbo].[Region] ([RID], [RegionName]) VALUES (4, N'West')

SET IDENTITY_INSERT [dbo].[Region] OFF

/****** Object:  Table [dbo].[Manager]    Script Date: 09/28/2014 23:58:23 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Manager](

[MID] [int] IDENTITY(1,1) NOT NULL,

[ManagerName] [varchar](50) NOT NULL,

[RegionId] [int] NOT NULL,

 CONSTRAINT [PK_Manager] PRIMARY KEY CLUSTERED 

(

[MID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

SET IDENTITY_INSERT [dbo].[Manager] ON

INSERT [dbo].[Manager] ([MID], [ManagerName], [RegionId]) VALUES (1, N'Raju', 1)

INSERT [dbo].[Manager] ([MID], [ManagerName], [RegionId]) VALUES (2, N'Raja', 2)

INSERT [dbo].[Manager] ([MID], [ManagerName], [RegionId]) VALUES (3, N'Sai', 3)

INSERT [dbo].[Manager] ([MID], [ManagerName], [RegionId]) VALUES (4, N'Pravin', 4)

INSERT [dbo].[Manager] ([MID], [ManagerName], [RegionId]) VALUES (5, N'Mahesh', 1)

INSERT [dbo].[Manager] ([MID], [ManagerName], [RegionId]) VALUES (6, N'Lakshmi', 2)

INSERT [dbo].[Manager] ([MID], [ManagerName], [RegionId]) VALUES (7, N'Gandharv', 3)

INSERT [dbo].[Manager] ([MID], [ManagerName], [RegionId]) VALUES (8, N'Avinash', 4)

INSERT [dbo].[Manager] ([MID], [ManagerName], [RegionId]) VALUES (9, N'Govind', 1)

INSERT [dbo].[Manager] ([MID], [ManagerName], [RegionId]) VALUES (10, N'Harish', 2)

SET IDENTITY_INSERT [dbo].[Manager] OFF

/****** Object:  Table [dbo].[ExceptionList]    Script Date: 09/28/2014 23:58:23 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[ExceptionList](

[PriceId] [int] IDENTITY(1,1) NOT NULL,

[PriceDesc] [varchar](500) NOT NULL,

[A] [int] NULL,

[B] [int] NULL,

[C] [int] NULL,

[D] [int] NULL,

[RegionId] [int] NOT NULL,

[ManagerId] [int] NOT NULL,

 CONSTRAINT [PK_ExceptionList] PRIMARY KEY CLUSTERED 

(

[PriceId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

SET IDENTITY_INSERT [dbo].[ExceptionList] ON

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (1, N'Testing_1', 6, 8, 5, NULL, 1, 1)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (2, N'Testing_2', 7, NULL, 8, NULL, 2, 2)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (3, N'Testing_3', NULL, NULL, 7, 8, 3, 3)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (4, N'Testing_4', NULL, 7, 7, NULL, 4, 4)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (5, N'Testing_5', 7, 7, 7, NULL, 1, 5)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (6, N'Testing_6', NULL, 7, NULL, 4, 2, 6)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (7, N'Testing_7', 8, NULL, 7, NULL, 3, 7)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (8, N'Testing_8', NULL, 7, NULL, 2, 4, 8)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (9, N'Testing_9', 9, NULL, 7, NULL, 1, 9)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (10, N'Testing_10', NULL, NULL, NULL, 3, 2, 10)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (11, N'Testing_11', NULL, NULL, 7, NULL, 3, 1)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (12, N'Testing_12', 12, 7, NULL, 3, 4, 2)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (13, N'Testing_13', NULL, NULL, NULL, NULL, 3, 3)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (14, N'Testing_14', 22, 7, 7, 6, 2, 4)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (15, N'Testing_15', 6, 8, 5, NULL, 1, 1)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (16, N'Testing_16', 7, NULL, 8, NULL, 2, 2)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (17, N'Testing_32', NULL, NULL, 7, 8, 3, 3)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (18, N'Testing_41', NULL, 7, 7, NULL, 4, 4)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (19, N'Testing_51', 7, 7, 7, NULL, 1, 5)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (20, N'Testing_61', NULL, 7, NULL, 4, 2, 6)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (21, N'Testing_71', 8, NULL, 7, NULL, 3, 7)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (22, N'Testing_81', NULL, 7, NULL, 2, 4, 8)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (23, N'Testing_91', 9, NULL, 7, NULL, 1, 9)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (24, N'Testing_101', NULL, NULL, NULL, 3, 2, 10)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (25, N'Testing_111', NULL, NULL, 7, NULL, 3, 1)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (26, N'Testing_121', 12, 7, NULL, 3, 4, 2)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (27, N'Testing_131', NULL, NULL, NULL, NULL, 3, 3)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (28, N'Testing_141', 22, 7, 7, 6, 2, 4)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (29, N'Testing_12', 6, 8, 5, NULL, 1, 1)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (30, N'Testing_22', 7, NULL, 8, NULL, 2, 2)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (31, N'Testing_32', NULL, NULL, 7, 8, 3, 3)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (32, N'Testing_42', NULL, 7, 7, NULL, 4, 4)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (33, N'Testing_52', 7, 7, 7, NULL, 1, 5)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (34, N'Testing_62', NULL, 7, NULL, 4, 2, 6)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (35, N'Testing_72', 8, NULL, 7, NULL, 3, 7)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (36, N'Testing_82', NULL, 7, NULL, 2, 4, 8)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (37, N'Testing_92', 9, NULL, 7, NULL, 1, 9)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (38, N'Testing_102', NULL, NULL, NULL, 3, 2, 10)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (39, N'Testing_112', NULL, NULL, 7, NULL, 3, 1)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (40, N'Testing_122', 12, 7, NULL, 3, 4, 2)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (41, N'Testing_132', NULL, NULL, NULL, NULL, 3, 3)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (42, N'Testing_142', 22, 7, 7, 6, 2, 4)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (43, N'Testing_152', 6, 8, 5, NULL, 1, 1)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (44, N'Testing_162', 7, NULL, 8, NULL, 2, 2)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (45, N'Testing_322', NULL, NULL, 7, 8, 3, 3)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (46, N'Testing_412', NULL, 7, 7, NULL, 4, 4)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (47, N'Testing_512', 7, 7, 7, NULL, 1, 5)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (48, N'Testing_612', NULL, 7, NULL, 4, 2, 6)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (49, N'Testing_712', 8, NULL, 7, NULL, 3, 7)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (50, N'Testing_812', NULL, 7, NULL, 2, 4, 8)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (51, N'Testing_912', 9, NULL, 7, NULL, 1, 9)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (52, N'Testing_1012', NULL, NULL, NULL, 3, 2, 10)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (53, N'Testing_1112', NULL, NULL, 7, NULL, 3, 1)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (54, N'Testing_1212', 12, 7, NULL, 3, 4, 2)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (55, N'Testing_1312', NULL, NULL, NULL, NULL, 3, 3)

INSERT [dbo].[ExceptionList] ([PriceId], [PriceDesc], [A], [B], [C], [D], [RegionId], [ManagerId]) VALUES (56, N'Testing_142', 22, 7, 7, 6, 2, 4)

SET IDENTITY_INSERT [dbo].[ExceptionList] OFF

/****** Object:  ForeignKey [FK_ExceptionList_Manager]    Script Date: 09/28/2014 23:58:23 ******/

ALTER TABLE [dbo].[ExceptionList]  WITH CHECK ADD  CONSTRAINT [FK_ExceptionList_Manager] FOREIGN KEY([ManagerId])

REFERENCES [dbo].[Manager] ([MID])

GO

ALTER TABLE [dbo].[ExceptionList] CHECK CONSTRAINT [FK_ExceptionList_Manager]

GO

/****** Object:  ForeignKey [FK_ExceptionList_Region]    Script Date: 09/28/2014 23:58:23 ******/

ALTER TABLE [dbo].[ExceptionList]  WITH CHECK ADD  CONSTRAINT [FK_ExceptionList_Region] FOREIGN KEY([RegionId])

REFERENCES [dbo].[Region] ([RID])

GO

ALTER TABLE [dbo].[ExceptionList] CHECK CONSTRAINT [FK_ExceptionList_Region]

GO

/****** Object:  ForeignKey [FK_Manager_Region]    Script Date: 09/28/2014 23:58:23 ******/

ALTER TABLE [dbo].[Manager]  WITH CHECK ADD  CONSTRAINT [FK_Manager_Region] FOREIGN KEY([RegionId])

REFERENCES [dbo].[Region] ([RID])

GO

ALTER TABLE [dbo].[Manager] CHECK CONSTRAINT [FK_Manager_Region]

GO

ListView Operations in Asp.Net

List View Links

http://www.nullskull.com/q/10111285/hyperlink-in-a-listview.aspx

Hyperlink in ListView

<asp:HyperLink runat="server" id="LoggedUserGroupList" Text="<%# DataBinder.Eval(Container.DataItem, "col1") %>"

        NavigateUrl='<%#"groupDisplay.aspx?groupName=" & DataBinder.Eval(Container.DataItem, "col2")%>'>

 </asp:HyperLink>

 where,
col1 = text that would appear
col2 = column in the datasource that would give the group name. OR

           
Hi,
                I've done something similar like this (note all the quotes and apostrophes):

          <asp:HyperLink ID="lnkView" runat="server" Text="View"
          NavigateUrl='<%#"~/Users/Transactions.aspx?account=" + Eval("AccountID")%>' />

List View using Templates

CRUD OPERATION USING LIST VIEW

Edit,Update,Delete and Insert in List View Control 

Various Data Bound Controls Used in ASP.Net

 

New trends in ASP.NET data binding: the ListView control

ListView: Displaying Hierarchical Data

How to Use ASP.NET 3.5 ListView & DataPager

Shortcut keys used in Visual Studio

Ctrl+M+O => Collapsing all functions

Ctrl+L       => Expanding all functions

prop+Tab Press  => Write whole property

foreach /if/ While/ do-while + Tab Press    => Write all if statement

F5           =>   Start your project in debug mode
Ctrl + Spacebar  => Intelligence 
Ctrl+ F5  => Starts the project without debugging
Ctrl+Shift+U  => Converts the currently selected text to upper case