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 %>'
GridView上下移动记录
最新推荐文章于 2020-04-29 14:16:33 发布