Leinholder management

<%@ Page Language="VB" MasterPageFile ="~/PolicyWatch.master"  AutoEventWireup="false" CodeFile="~/PW_LeinholderManagement.aspx.vb" Inherits="_Default" %>

<script runat="server">


</script>

<asp:Content ID="Content1" runat="server"
    contentplaceholderid="ContentPlaceHolder1">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
            </asp:ScriptManager>

            <div class="style1">
                <a href="PW_Approval.aspx" style="text-align: left">Policy Watch Approval Page</a>
            </div>
        <table style=" table-layout:fixed "><tr><td>

            <asp:SqlDataSource ID="SqlDataSource1" runat="server"
                ConnectionString="<%$ ConnectionStrings:GoAutoTestDataConnectionString2 %>"


                SelectCommand="SELECT DISTINCT [EmailAddress] FROM [PolicyWatch_Registration]">
            </asp:SqlDataSource>
            <asp:Label ID="Label1" runat="server" Text="Registration Email"
                style="font-weight: 700"></asp:Label>
            <br />
            <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            <asp:ListBox ID="lb_Emails" runat="server"
                DataTextField="EmailAddress" DataValueField="EmailAddress"
                AutoPostBack="True"
                DataSourceID="SqlDataSource1"></asp:ListBox>
                  </ContentTemplate>
    </asp:UpdatePanel>

            </td></tr>
            <tr><td style="overflow:scroll; height:400px;">

                <asp:Label ID="Label3" runat="server" style="font-weight: 700"
                    Text="List of Lienholders"></asp:Label>

            <asp:UpdatePanel ID="UpdatePanel3" runat="server">
    <ContentTemplate>

                <asp:ListBox ID="gv_AllLeins" runat="server"
                    DataTextField="LienName" Height="301px"
                    Width="260px" SelectionMode="Multiple"
                    DataSourceID="SqlDataSource3" DataValueField="LienName"
                    AutoPostBack="True">
                </asp:ListBox>
                <asp:SqlDataSource ID="SqlDataSource3" runat="server"

                    ConnectionString="<%$ ConnectionStrings:GoAutoTestDataConnectionString2 %>" SelectCommand="create table #LienList (LienName varchar(64))



insert into #LienList

   select distinct LienName from Vehicle (nolock)

   union

   select distinct Lien2Name from Vehicle (nolock)



select distinct LienName as LienName
from #LienList
where LienName is not null and LienName &lt;&gt; '0' and LienName &lt;&gt; '' order by LienName asc

"></asp:SqlDataSource>
</ContentTemplate>
</asp:UpdatePanel>
                        </td>
            <td>
                <asp:Button ID="btnAdd" runat="server" Text="Add Lienholder" />
                <br /> <br />
                <asp:Button ID="btnRemove" runat="server" Text="Remove Lienholder"
                    Width="124px" /></td>
            <td>
                <asp:Label ID="Label2" runat="server" Text="Attached Liens"
                    style="font-weight: 700"></asp:Label>
            <asp:UpdatePanel ID="UpdatePanel2" runat="server">
        <ContentTemplate>



                <asp:ListBox ID="gv_Selected" runat="server" Height="300px" Width="260px"
                    AutoPostBack="True">
                </asp:ListBox></ContentTemplate>
    </asp:UpdatePanel>
                </td></tr>
            </table>

</asp:Content>



<asp:Content ID="Content2" runat="server" contentplaceholderid="head">

    <style type="text/css">
        .style1
        {
            text-align: left;
        }
    </style>

</asp:Content>