static string id = string.Empty; //注意这里必须声明成static类型
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if(e.CommandName=="EditB")
{
this.divEdit.Style.Add("display","block"); //弹出div层 div前台需要声明成runat="server"
this.divopacity.Style.Add("display","block");
id = Convert.ToString(e.CommandArgument); //取出当前行的id
//前台绑定代码:<asp:LinkButton ID="linkEdit" CommandArgument='<%#Eval("ClassId") %>' CommandName="EditB"
runat="server"> 编辑</asp:LinkButton>
}
}
protected void btnEnsureE_Click(object sender, EventArgs e)
{
using (SqlConnection sqlcnn=new SqlConnection(sqlstr))
{
using (SqlCommand sqlcmm=sqlcnn.CreateCommand())
{
sqlcmm.CommandText = "update ArticleClass set ClassName=@classname where classid=@classid";
sqlcmm.Parameters.AddWithValue("@classname",this.TxtClassnameE.Text);
sqlcmm.Parameters.AddWithValue("@classid",id);
sqlcnn.Open();
int i= sqlcmm.ExecuteNonQuery();
if (i>0)
{
this.divEdit.Style.Add("display", "none"); //隐藏div层
this.divopacity.Style.Add("display", "none");
GetData();
}
else
{
Response.Write("<scritp>alert('更改失败!')</script>");
}
}
}
}//修改文章分类
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if(e.CommandName=="EditB")
{
this.divEdit.Style.Add("display","block"); //弹出div层 div前台需要声明成runat="server"
this.divopacity.Style.Add("display","block");
id = Convert.ToString(e.CommandArgument); //取出当前行的id
//前台绑定代码:<asp:LinkButton ID="linkEdit" CommandArgument='<%#Eval("ClassId") %>' CommandName="EditB"
runat="server"> 编辑</asp:LinkButton>
}
}
protected void btnEnsureE_Click(object sender, EventArgs e)
{
using (SqlConnection sqlcnn=new SqlConnection(sqlstr))
{
using (SqlCommand sqlcmm=sqlcnn.CreateCommand())
{
sqlcmm.CommandText = "update ArticleClass set ClassName=@classname where classid=@classid";
sqlcmm.Parameters.AddWithValue("@classname",this.TxtClassnameE.Text);
sqlcmm.Parameters.AddWithValue("@classid",id);
sqlcnn.Open();
int i= sqlcmm.ExecuteNonQuery();
if (i>0)
{
this.divEdit.Style.Add("display", "none"); //隐藏div层
this.divopacity.Style.Add("display", "none");
GetData();
}
else
{
Response.Write("<scritp>alert('更改失败!')</script>");
}
}
}
}//修改文章分类