
gridview 编辑 后无法显示新的内容
用gridview控件编辑后..无法显示修改后的内容...还是显示原来的..(执行完SQL更新语句后...也将gridview重新绑定了)...这是为什么...把代码贴出...
用gridview控件编辑后..无法显示修改后的内容...还是显示原来的..(执行完SQL更新语句后...也将gridview重新绑定了)...这是为什么...把代码贴出来...请大家帮我看看...
//更新
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
sqlcon = new SqlConnection(strCon);
sqlcon.Open();
string sqlstr = "update tb_info set type='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim() + "',title='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',info='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "'where id='" + GridView1.DataKeys[e.RowIndex][0].ToString() + "'";
sqlcom = new SqlCommand(sqlstr, sqlcon);
GridView1.EditIndex = -1;
bind();//绑定gridview的方法
}
另外...请高手帮我解释一下...[GridView1.EditIndex = -1;]这一句是什么意思....是用来做什么的... 展开
//更新
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
sqlcon = new SqlConnection(strCon);
sqlcon.Open();
string sqlstr = "update tb_info set type='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim() + "',title='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',info='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "'where id='" + GridView1.DataKeys[e.RowIndex][0].ToString() + "'";
sqlcom = new SqlCommand(sqlstr, sqlcon);
GridView1.EditIndex = -1;
bind();//绑定gridview的方法
}
另外...请高手帮我解释一下...[GridView1.EditIndex = -1;]这一句是什么意思....是用来做什么的... 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询