GridView上下移动记录

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Bind();
        }
    }

    private void Bind()
    {
        string strCon = @"server=./sqlexpress;database=GridTest;uid=sa;pwd=";
        SqlConnection con = new SqlConnection(strCon);
        DataTable dt = new DataTable();
        SqlDataAdapter sda = new SqlDataAdapter("select * from test order by orderIndex", con);
        sda.Fill(dt);
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        string strCon = @"server=./sqlexpress;database=GridTest;uid=sa;pwd=";
        SqlConnection con = new SqlConnection(strCon);
        int index = Convert.ToInt32(e.CommandArgument);
        int totle = GridView1.Rows.Count;
        if (e.CommandName == "up")
        {
            if (index > 0)
            {
                int orderIndex1 = Convert.ToInt32(GridView1.Rows[index].Cells[3].Text);
                int key1 = Convert.ToInt32(GridView1.Rows[index].Cells[1].Text);
                int preOrderIndex = Convert.ToInt32(GridView1.Rows[index - 1].Cells[3].Text);
                int key2 = Convert.ToInt32(GridView1.Rows[index - 1].Cells[1].Text);
                int temp;
                temp = orderIndex1;
                orderIndex1 = preOrderIndex;
                preOrderIndex = temp;
                //string sqlText = "delete Test";
                string sqlText = "update test set orderIndex='" + orderIndex1 + "' where id='" + key1 + "'";
                Response.Write(sqlText);
                SqlCommand cmd = new SqlCommand(sqlText, con);
                con.Open();
                cmd.ExecuteNonQuery();
                string sqlText2 = "update test set orderIndex='" + preOrderIndex + "' where id='" + key2 + "'";
                cmd = new SqlCommand(sqlText2, con);
                Response.Write(sqlText2);
                cmd.ExecuteNonQuery();
                con.Close();
                Bind();
            }
            else
            {
                Response.Write("已到第一条记录");
                //在这还可以用注册到脚本的方法更好
                  //ClientScriptManage csm=this.Page.ClientManage;
                //csm.RegisterUpScript(this.GetType(),"MyScript","javascript:alert('已到第一条记录！')");
            }
        }
        if (e.CommandName == "down")
        {
            if (index < totle-1)
            {
                int orderIndex1 = Convert.ToInt32(GridView1.Rows[index].Cells[3].Text);
                int key1 = Convert.ToInt32(GridView1.Rows[index].Cells[1].Text);
                int preOrderIndex = Convert.ToInt32(GridView1.Rows[index + 1].Cells[3].Text);
                int key2 = Convert.ToInt32(GridView1.Rows[index + 1].Cells[1].Text);
                int temp;
                temp = orderIndex1;
                orderIndex1 = preOrderIndex;
                preOrderIndex = temp;
                //string sqlText = "delete Test";
                string sqlText = "update test set orderIndex='" + orderIndex1 + "' where id='" + key1 + "'";
                Response.Write(sqlText);
                SqlCommand cmd = new SqlCommand(sqlText, con);
                con.Open();
                cmd.ExecuteNonQuery();
                string sqlText2 = "update test set orderIndex='" + preOrderIndex + "' where id='" + key2 + "'";
                cmd = new SqlCommand(sqlText2, con);
                Response.Write(sqlText2);
                cmd.ExecuteNonQuery();
                con.Close();
                Bind();
            }
            else
            {
                Response.Write("已到最后一条");
            }
        }
    }

CommandArgument='<%# ((GridViewRow)Container).RowIndex %>'