gridview的删除事件,测试时发生错误,protected void Button1_Click(object sender, EventArgs e)
{ SqlConnection conn = new SqlConnection(str);//str数据库连接串
SqlDataAdapter ad = new SqlDataAdapter("select * from a ", conn); DataSet ds = new DataSet();
conn.Open(); ad.Fill(ds);//填充数据集 GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { "TopicID" };
GridView1.DataBind();
conn.Close();
for(int j=0;j<GridView1.Rows.Count;j++)
{
CheckBox cb2 = new CheckBox();
cb2 = (CheckBox)GridView1.Rows[j].FindControl("checkbox1");
if (cb2.Checked == true)
{
string strg = "delete from a where TopicID='" + GridView1.DataKeys[j].Value + "'";
SqlCommand cmd = new SqlCommand(strg, conn);
conn.Open();
int Row = cmd.ExecuteNonQuery();
if (Row > 0)
{
Response.Write("<Script >alert(\"删除成功!\")</Script>");
}
conn.Close();
}
}
}
{ SqlConnection conn = new SqlConnection(str);//str数据库连接串
SqlDataAdapter ad = new SqlDataAdapter("select * from a ", conn); DataSet ds = new DataSet();
conn.Open(); ad.Fill(ds);//填充数据集 GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { "TopicID" };
GridView1.DataBind();
conn.Close();
for(int j=0;j<GridView1.Rows.Count;j++)
{
CheckBox cb2 = new CheckBox();
cb2 = (CheckBox)GridView1.Rows[j].FindControl("checkbox1");
if (cb2.Checked == true)
{
string strg = "delete from a where TopicID='" + GridView1.DataKeys[j].Value + "'";
SqlCommand cmd = new SqlCommand(strg, conn);
conn.Open();
int Row = cmd.ExecuteNonQuery();
if (Row > 0)
{
Response.Write("<Script >alert(\"删除成功!\")</Script>");
}
conn.Close();
}
}
}
解决方案 »
- 求超大数据量自定义分页思路,或伪代码
- log4net读取到的参数全部为null
- 编译错误:未能加载程序集“App_Web_..!!!
- 微软资深讲师亲述,来自全球最顶尖的IT培训企业 Total Training for Microsoft Visual Studio 2005 中文版视频教程。极品中的极品,要的快来!
- 各位老师,有一个关于session的问题!
- Web控件如何封装成DLL?
- 关于数据绑定的问题!
- 网站模块划分和数据库建立的问题~
- Label、TextBox在禁用ViewState后不同的表现
- 请问如何写一个查询记录的语句,谢谢!
- asp.net如何做好友管理
- <input type="hidden" name="__VIEWSTATE"的去留问题讨论
提示cb2为null
SqlConnection conn = new SqlConnection(str);//str数据库连接串
应该不是吧,我测试的时候直接写数据库连接的啊,
是不是别的地方出错了,