选择可搜索的数据库已经存在用户和双listbox界面模型

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="CustomerRegister.aspx.cs" Inherits="CustomerRegister" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table width="90%" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
  <tr>
    <td colspan="8" align="center" bgcolor="#FFFFCC" style="height: 30px"><strong>来人条</strong></td>
  </tr>
  <tr>
    <td colspan="8" bgcolor="#FFFFCC" style="height: 30px;text-align:left" ><strong>基本信息</strong></td>
  </tr>
  <tr align="left">
    <td bgcolor="#FFFFCC" style="height: 12px">客户姓名</td>
    <td bgcolor="#FFFFCC" style="height: 12px">&nbsp;<asp:TextBox ID="CustomerName" runat="server" BorderStyle="Solid" BackColor="#FFFFCC" BorderColor="#FFFFCC"></asp:TextBox></td>
    <td bgcolor="#FFFFCC" style="height: 12px">性别</td>
    <td bgcolor="#FFFFCC" style="height: 12px">&nbsp;<asp:TextBox ID="Gender" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC" style="height: 12px">年龄</td>
    <td bgcolor="#FFFFCC" style="height: 12px">&nbsp;<asp:TextBox ID="Age" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC" style="height: 12px">身份证</td>
    <td bgcolor="#FFFFCC" style="height: 12px; width: 196px;">
        <asp:TextBox ID="IDCode" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox>&nbsp;</td>
  </tr>
  <tr align="left">
    <td bgcolor="#FFFFCC">学历</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:TextBox ID="Degree" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC">职业</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:TextBox ID="Occupation" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC">公司名称</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:TextBox ID="CompanyName" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC">&nbsp;</td>
    <td bgcolor="#FFFFCC" style="width: 196px">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="8" bgcolor="#FFFFCC" style="height:30px;text-align:left"><strong>联系方式</strong></td>
  </tr>
  <tr align="left">
    <td bgcolor="#FFFFCC">手机</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:TextBox ID="Mobile" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC">宅电</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:TextBox ID="HomePhone" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC">公司</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:TextBox ID="CompanyPhone" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC">邮箱</td>
    <td bgcolor="#FFFFCC" style="width: 196px">&nbsp;<asp:TextBox ID="Email" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
  </tr>
  <tr align="left">
    <td bgcolor="#FFFFCC">通讯地址</td>
    <td bgcolor="#FFFFCC" colspan="3">&nbsp;<asp:TextBox ID="Address" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid" Width="400px"></asp:TextBox>
        &nbsp;</td>
    <td bgcolor="#FFFFCC">邮编</td>
    <td bgcolor="#FFFFCC" colspan="3">&nbsp;<asp:TextBox ID="Postcode" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox>
        &nbsp;</td>
  </tr>
  <tr>
    <td colspan="8" bgcolor="#FFFFCC" style="height:30px;text-align:left"><strong>询问重点</strong></td>
  </tr>
  <tr align="left">
    <td bgcolor="#FFFFCC">产品</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:TextBox ID="Product" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC">面积</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:TextBox ID="Areage" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC">楼层</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:TextBox ID="Floor" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC">位置</td>
    <td bgcolor="#FFFFCC" style="width: 196px">&nbsp;<asp:TextBox ID="Positions" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
  </tr>
  <tr align="left">
    <td bgcolor="#FFFFCC">区域</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:TextBox ID="Area" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC">媒体</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:TextBox ID="Meida" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC">朝向</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:TextBox ID="Heading" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
    <td bgcolor="#FFFFCC">总价</td>
    <td bgcolor="#FFFFCC" style="width: 196px">&nbsp;<asp:TextBox ID="TotalPrice" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid"></asp:TextBox></td>
  </tr>
  <tr align="left">
    <td bgcolor="#FFFFCC">用途</td>
    <td bgcolor="#FFFFCC" colspan="3">&nbsp;<asp:TextBox ID="Using" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid" Width="400px"></asp:TextBox>
        &nbsp;</td>
    <td bgcolor="#FFFFCC">备注</td>
    <td bgcolor="#FFFFCC" colspan="3">&nbsp;<asp:TextBox ID="Info" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid" Width="400px"></asp:TextBox>
        &nbsp;</td>
  </tr>
  <tr>
    <td colspan="8" bgcolor="#FFFFCC" style="height:30px;text-align:left"><strong>状态</strong></td>
  </tr>
  <tr align="left">
    <td bgcolor="#FFFFCC">已购</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:RadioButton ID="HasBuy" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC"
            BorderStyle="Solid" GroupName="ISBuy" /></td>
    <td bgcolor="#FFFFCC">未购</td>
    <td bgcolor="#FFFFCC">&nbsp;<asp:RadioButton ID="NotBuy" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC"
            BorderStyle="Solid" Checked="True" GroupName="ISBuy" /></td>
    <td bgcolor="#FFFFCC">
        &nbsp;未购原因</td>
    <td bgcolor="#FFFFCC" colspan="3">&nbsp;<asp:TextBox ID="ISNotBuyReason" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC" BorderStyle="Solid" Width="400px"></asp:TextBox>
        &nbsp;</td>
  </tr>
  <tr>
    <td colspan="6" bgcolor="#FFFFCC" style="height: 12px">&nbsp;</td>
    <td bgcolor="#FFFFCC" style="height: 12px">&nbsp;业务员</td>
    <td bgcolor="#FFFFCC" style="height: 12px; width: 196px;">&nbsp;<asp:TextBox ID="Sellers" runat="server" BackColor="#FFFFCC" BorderColor="#FFFFCC"
            BorderStyle="Solid" ></asp:TextBox></td>
  </tr>
  <tr>
    <td colspan="8" bgcolor="#FFFFCC" style="height: 12px">&nbsp;<asp:Button ID="Button1" runat="server" BackColor="ControlDark" BorderColor="Control"
            BorderStyle="Solid" Height="20px" OnClick="Button1_Click" Text="新增" BorderWidth="0px" /></td>
  </tr>
</table>
</asp:Content>

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class CustomerTransfer : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            dataBind();
        }
        //dataBind();
    }
    private void dataBind()
    {
        //Response.Write(getSqlString());
        SqlConnection Connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SellSystemConnectionString"].ToString());
        Connection.Open();
        SqlDataAdapter DataAdapter = new SqlDataAdapter(getSqlString(), Connection);
        DataSet ds = new DataSet();
        DataAdapter.Fill(ds, "Customers");
        GridView1.DataSource = ds;
        GridView1.DataBind();
        Connection.Close();


    }
    public string getSqlString()
    {
        string sqlstr;
        sqlstr="select CustomerID as ID,CustomerName as 姓名,Gender as 性别,age as 年龄,Mobile as 手机,sellers as 业务员 from Customers where 1=1";
        if(CustomerName.Text!="")
        {
           sqlstr= sqlstr+" and CustomerName like '%"+CustomerName.Text+"%'";
        }
        if (CustomerPhone.Text != "")
        {
           sqlstr = sqlstr + " and HomePhone like '%"+ CustomerPhone.Text + "%'";
        }
        if (Sellers.Text != "")
        {
           sqlstr = sqlstr + " and Sellers like '%" + Sellers.Text + "%'";
        }
        return sqlstr;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        dataBind();
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = (int)e.NewEditIndex;
        dataBind();
    }
    protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
    {
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        dataBind();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string sqlstr;
        string Sellers;
        GridView1.FooterRow.Enabled = false;

        Sellers = ((TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0]).Text;
        //Response.Write(((TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0]).Text);
        sqlstr = "update Customers set Sellers='" + Sellers + "' where CustomerID=" + GridView1.DataKeys[e.RowIndex].Value.ToString();
        //Response.Write(sqlstr);
        ExeSql(sqlstr);
        GridView1.EditIndex = -1;
        dataBind();
    }
    private void ExeSql(string sqlstr)
    {
        SqlConnection Connection1 = new SqlConnection(ConfigurationManager.ConnectionStrings["SellSystemConnectionString"].ToString());
        SqlCommand Comm = new SqlCommand(sqlstr,Connection1);
        Comm.Connection.Open();
        try
        {
            Comm.ExecuteNonQuery();
            
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="select.aspx.cs" Inherits="select" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>select</title>
</head>
<body style="background-color:#FFFFCC">
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SellSystemConnectionString %>"
            SelectCommand="SELECT [UName], [UID] FROM [Users] WHERE ([UName] LIKE '%' + @UName + '%')">
            <SelectParameters>
                <asp:ControlParameter ControlID="UName" Name="UName" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    <table  border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000">
  <tr>
    <td colspan="3" align="center" bgcolor="#FFFFCC" style="font-family:宋体; font-size:12px">姓名：<asp:TextBox ID="UName" runat="server" BorderStyle="Solid" BorderWidth="1px"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" Text="查找" OnClick="Button1_Click" BorderStyle="Solid" BorderWidth="0px" /></td>
  </tr>
  <tr>
    <td align="right" bgcolor="#FFFFCC"><asp:ListBox ID="ListBox1" runat="server" DataSourceID="SqlDataSource1" DataTextField="UName"
            DataValueField="UID" SelectionMode="Multiple"></asp:ListBox>
    </td>
    <td align="center" bgcolor="#FFFFCC">
        <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="<" BorderStyle="Solid" BorderWidth="0px" />
        <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text=">" BorderStyle="Solid" BorderWidth="0px" />&nbsp;</td>
    <td align="left" bgcolor="#FFFFCC">
        <asp:ListBox ID="ListBox2" runat="server" SelectionMode="Multiple"></asp:ListBox>&nbsp;</td>
  </tr>
  <tr>
    <td colspan="3" align="center" bgcolor="#FFFFCC">&nbsp;<asp:Button ID="Button4" runat="server" Text="确定" OnClick="Button4_Click" BorderStyle="Solid" BorderWidth="0px" /></td>
  </tr>
</table>
        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
           
              
    </div>
    </form>
</body>
</html>

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;


public partial class select : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        //Response.Write(ListBox1.SelectedIndex.ToString());
        if (ListBox1.SelectedIndex !=-1)
        {
            ListBox2.Items.Add(new ListItem(ListBox1.SelectedItem.Text, ListBox1.SelectedItem.Value));
            ListBox1.Items.RemoveAt(ListBox1.SelectedIndex);
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        if (ListBox2.SelectedIndex !=-1)
        {
            ListBox1.Items.Add(new ListItem(ListBox2.SelectedItem.Text, ListBox2.SelectedItem.Value));
            ListBox2.Items.RemoveAt(ListBox2.SelectedIndex);
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {

    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        string sellers;
        sellers = "";
        for (int i = 0; i < ListBox2.Items.Count; i++)
        {
            if (i == 0)
            {
                sellers = ListBox2.Items[i].Text;
            }
            else
            {
                sellers =sellers+","+ ListBox2.Items[i].Text;
            }
            //Response.Write(ListBox2.Items[i].Text);
            //Response.Write(ListBox2.Items[i].Value);
        }
        //Response.Write(sellers);
        Response.Write(Request.QueryString["clientID"].ToString());
        try
        {
            //Response.Write("<script>window.opener.document.getElementById( 'ctl00_ContentPlaceHolder1_Sellers').value='" + sellers + "';window.close(); </script>");
            Response.Write("<script>window.opener.document.getElementById( '" + Request.QueryString["clientID"].ToString() + "').value='" + sellers + "';window.close(); </script>");
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }

    }
}

        finally
        {
            ClientScript.RegisterClientScriptBlock(this.GetType(),"","<script>alert('更新成功')</script>");
            Connection1.Close();
        }
    }
}