TreeView 排序

Table tab = new Table();        TableRow row = new TableRow();        TableCell cell = new TableCell();        cell.Text = "栏目编号";        row.Cells.Add(cell);        cell = new TableCell();        cell.Text = "栏目名称";        row.Cells.Add(cell);        cell = new TableCell();        cell.Text = "排序";        row.Cells.Add(cell);        cell = new TableCell();        cell.Text = " ";        row.Cells.Add(cell);        tab.Rows.Add(row);        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)        {            row = new TableRow();            cell = new TableCell();            cell.Text = ds.Tables[0].Rows[i]["MenuID"].ToString();            row.Cells.Add(cell);            cell = new TableCell();            cell.Text = ds.Tables[0].Rows[i]["MenuName"].ToString();            row.Cells.Add(cell);                                   cell = new TableCell();            string MenuID=ds.Tables[0].Rows[i]["MenuID"].ToString();//当前记录ID            string MenuOrder = ds.Tables[0].Rows[i]["MenuOrder"].ToString();//当前记录序号            //向上            Button btnup = new Button();            btnup.Text = "up";            btnup.Command += new CommandEventHandler(btnup_Command);            btnup.CommandName = "up";            string UpMenuOrder;            string UpMenuID;            if (i==0)            {                UpMenuID = MenuID;                UpMenuOrder = MenuOrder;            }            else            {                UpMenuID = ds.Tables[0].Rows[i - 1]["MenuID"].ToString();                UpMenuOrder = ds.Tables[0].Rows[i-1]["MenuOrder"].ToString();            }            btnup.CommandArgument = MenuID + ";" + UpMenuID + ";" + MenuOrder + ";" + UpMenuOrder;            //向下            Button btnDown = new Button();            btnDown.Text = "Down";            btnDown.Command += new CommandEventHandler(btnup_Command);            btnDown.CommandName = "Down";            string DownMenuOrder;//下面的记录序号            string DownMenuID;//下面的记录ID            if (i==ds.Tables[0].Rows.Count-1)            {                DownMenuOrder = MenuOrder;                DownMenuID = MenuID;            }            else            {                DownMenuOrder = ds.Tables[0].Rows[i+1]["MenuOrder"].ToString();                DownMenuID = ds.Tables[0].Rows[i+1]["MenuID"].ToString();            }            btnDown.CommandArgument = MenuID+";"+DownMenuID+";"+MenuOrder+";"+DownMenuOrder;            cell.Controls.Add(btnup);            cell.Controls.Add(btnDown);            row.Cells.Add(cell);            tab.Rows.Add(row);        }       this.Label2.Controls.Add(tab);

 void btnup_Command(object sender, CommandEventArgs e)    {        string sql = ConfigurationManager.ConnectionStrings["sql"].ConnectionString;        if (e.CommandName=="up")        {            string[] str = e.CommandArgument.ToString().Split(';');            string MenuID = str[0];            string UpMenuID = str[1];            string MenuOrder = str[2];            string UpMenuOrder = str[3];            using (SqlConnection conn=new SqlConnection (sql))            {                SqlCommand comm = conn.CreateCommand();                comm.CommandText = "update MenuTree set MenuOrder='" + UpMenuOrder+"' where MenuID='"+MenuID+"'";                conn.Open();                comm.ExecuteNonQuery();                comm.CommandText = "update MenuTree set MenuOrder='" + MenuOrder + "' where MenuID='" + UpMenuID+"'";                comm.ExecuteNonQuery();            }            this.TreeView1.Nodes.Clear();            bindTree();        }        if (e.CommandName == "Down")        {            string[] str = e.CommandArgument.ToString().Split(';');            string MenuID = str[0];            string DownMenuID = str[1];            string MenuOrder = str[2];            string DownMenuOrder = str[3];            using (SqlConnection conn = new SqlConnection(sql))            {                SqlCommand comm = conn.CreateCommand();                comm.CommandText = "update MenuTree set MenuOrder='" + DownMenuOrder + "' where MenuID='" + MenuID + "'";                conn.Open();                comm.ExecuteNonQuery();                comm.CommandText = "update MenuTree set MenuOrder='" + MenuOrder + "' where MenuID='" + DownMenuID + "'";                comm.ExecuteNonQuery();            }            this.TreeView1.Nodes.Clear();            bindTree();        }           Response.Redirect(Request.Url.ToString());    }