1.将datatable的值给List

         DataTable allColumns = (DataTable)Session["allColumns"];
                if(null != allColumns)
                {
                    foreach(DataColumn dc in allColumns.Columns)
                    {
                        ListColumnName.Items.Add(dc.ColumnName+"("+dc.DataType.Name+")");
                    }
                }
 

 2.两个list中的item之间添加与清除,顺序变动

//add
            bool flag=false;
            ListItem listItem=ListColumnName.SelectedItem;
            if(listItem!= null)
            {
                foreach (ListItem listItem1 in ListPrimaryKey.Items)
                {
                    if (listItem1.Text== listItem.Text)
                    {
                        flag=true;
                    }
                }
                if(flag== false)
                {
                    ListPrimaryKey.Items.Add(listItem);
                    ListColumnName.Items.Remove(listItem);   
                    ListPrimaryKey.SelectedIndex=-1;
                    ListColumnName.SelectedIndex=-1;
                }   
            }

//up
            int i=ListColumnName.SelectedIndex;
            if ( i >0)
            {
                ListItem listItem= new ListItem(ListColumnName.Items[i-1].Text,ListColumnName.Items[i-1].Value);
                ListColumnName.Items[i-1].Text=ListColumnName.Items[i].Text;
                ListColumnName.Items[i].Text=listItem.Text;
                ListColumnName.SelectedIndex=i-1;
                ListPrimaryKey.SelectedIndex=i-1;
            }
 

//remove
            ListItem listItem=ListPrimaryKey.SelectedItem;
            bool flag=false;
            if (listItem!= null)
            {
                foreach (ListItem listItem1 in ListColumnName.Items)
                {
                    if (listItem1.Text== listItem.Text)
                    {
                        flag=true;
                    }

                }
                if(flag== false)
                {
                    ListColumnName.Items.Add(listItem);
                    ListColumnName.SelectedIndex=-1;
                }
                ListPrimaryKey.Items.Remove(listItem);
                ListPrimaryKey.SelectedIndex=-1;
            }
//down
            int i=ListColumnName.SelectedIndex;
            if ( i >=0 && i            {
                ListItem listItem= new ListItem(ListColumnName.Items[i].Text,ListColumnName.Items[i].Value);
                ListColumnName.Items[i].Text=ListColumnName.Items[i+1].Text;
                ListColumnName.Items[i+1].Text=listItem.Text;
                ListColumnName.SelectedIndex=i+1;
                ListPrimaryKey.SelectedIndex=i+1;
            }