有两个列表框（listbox2和listbox3），通过一个列表框可以向另一个列表框中添加或者删除内容。
代码如下：
public partial class xiaoya : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Text = "你最喜欢的运动是：" + ListBox1.SelectedItem.Text;
}
protected void Button2_Click(object sender, EventArgs e)
{
for (int i = 0; i < ListBox2.Items.Count; i++)
ListBox3.Items.Add(ListBox2.Items[i]);
}
protected void Button3_Click(object sender, EventArgs e)
{
for (int i = 0; i < ListBox2.Items.Count; i++)
if (ListBox2.Items[i].Selected)
ListBox3.Items.Add(ListBox2.Items[i]);
}
protected void Button4_Click(object sender, EventArgs e)
{
for (int i = ListBox3.Items.Count - 1; i <= 0; i--)
if (ListBox3.Items[i].Selected)
select top 12 * from Product where [id] not in (select top 12 [id] from Product)
这样可以分页，但是我在后面想加个条件
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
