listbost.aspx.cs

关于ASP.NET制作程序模块

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            bandlist2();
        }
    }
    protected void add_Click(object sender, EventArgs e)
    {
        if (tname.Text == string.Empty)
        {
            Response.Write("<font color=red>请输入</font>");
        }
        else
        {
            string aa = tname.Text;
            this.list1.Items.Add(aa);
            this.tname.Text = string.Empty;
            this.labout.Text = "你刚添加了<font color=red>" + aa + "</font>";
        }
        
    }
    protected void move_Click(object sender, EventArgs e)
    {
        if (list1.SelectedValue == string.Empty)
        {
            Response.Write("<font color=red>请选择要转移的值</font>");
        }
        else
        {
            string bb = list1.SelectedValue;
            list1.Items.Remove(bb);
            list2.Items.Add(bb);
        }
    }
    protected void up_Click(object sender, EventArgs e)
    {
        if (list1.SelectedIndex > 0)
        {
            string name = list1.SelectedItem.Text;
            string id = list1.SelectedValue;
            int index = list1.SelectedIndex;
            list1.SelectedItem.Text = list1.Items[index - 1].Text;
            list1.SelectedItem.Value = list1.Items[index - 1].Value;
            list1.Items[index-1].Text=name;
            list1.Items[index-1].Value=id;
            list1.SelectedIndex--;
        }
    }
    protected void down_Click(object sender, EventArgs e)
    {
        if (list1.SelectedIndex >= 0 && list1.SelectedIndex < list1.Items.Count - 1)
        {
            string name = list1.SelectedItem.Text;
            string id = list1.SelectedValue;
            int index = list1.SelectedIndex;
            list1.SelectedItem.Text = list1.Items[index + 1].Text;
            list1.SelectedItem.Value = list1.Items[index + 1].Value;
            list1.Items[index + 1].Text = name;
            list1.Items[index + 1].Value = id;
            list1.SelectedIndex++;
        }
    }
    private void bandlist2()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
        con.Open();
        string cmdtext="select shipname from orders";
        SqlDataAdapter  sda=new SqlDataAdapter(cmdtext,con);
        DataSet ds=new DataSet();
        sda.Fill(ds,"orders");
        list2.DataSource=ds.Tables["orders"].DefaultView;
        list2.DataValueField="shipname";
        list2.DataBind();
        con.Close();
    }
    protected void btndel_Click(object sender, EventArgs e)
    {
        if (list1.SelectedIndex > -1)
            {
                for (int m = list1.Items.Count - 1; m >= 0; m--)
                {
                    if (this.list1.Items[m].Selected == true)
                    {
                        list1.Items.Remove(list1.Items[m]);
                        // list1.Items.RemoveAt(m);

                    }
                }
            }
            else
            {
                this.labout.Text = "<font color=red>请选择左边要删除的项！</font>";
            }
    }
  
    protected void list2_SelectedIndexChanged(object sender, EventArgs e)
    {
        this.labout.Text = "你选择了：<font color=red>" + list2.SelectedItem.Text + "</font>";
    }
}