请问是怎么回事哈代码如下: protected void ToTop(object sender, GridViewCommandEventArgs e)
{
c1 = e.CommandArgument.ToString().Trim();
if (!c1.Equals("0"))
{
SqlConnection con = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["trainConnectionString"].ToString());
string sql = "update series set rank=1989 where rank="+c1;
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
sql = "update series set rank=" + c1 + " where rank=(" + c1 + "-1)";
SqlCommand cmd2 = new SqlCommand(sql, con);
con.Open();
cmd2.ExecuteNonQuery();
sql = "update series set rank=(" + c1 + "-1) where rank=1989";
SqlCommand cmd3 = new SqlCommand(sql, con);
con.Open();
cmd3.ExecuteNonQuery();
SqlDataSource1.DataBind();
GridView1.DataBind();
}
}
{
c1 = e.CommandArgument.ToString().Trim();
if (!c1.Equals("0"))
{
SqlConnection con = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["trainConnectionString"].ToString());
string sql = "update series set rank=1989 where rank="+c1;
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
sql = "update series set rank=" + c1 + " where rank=(" + c1 + "-1)";
SqlCommand cmd2 = new SqlCommand(sql, con);
con.Open();
cmd2.ExecuteNonQuery();
sql = "update series set rank=(" + c1 + "-1) where rank=1989";
SqlCommand cmd3 = new SqlCommand(sql, con);
con.Open();
cmd3.ExecuteNonQuery();
SqlDataSource1.DataBind();
GridView1.DataBind();
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货