|
——此文章摘自《ASPNET +SQL Server网络应用系统开发案例精解》定价￥特价￥ 详细>> //单击删除所触发的事件 if(eCommandName==delete) { //自定义delete()删除指定ID的信息 delete(); } BindGrid(); } //加载delete() public void delete() { //获取需要删除的信息的id号 string ID = Session[ID]ToString(); //创建删除指定id的产品信息的sql语句 string STstrsql = delete from STProDe where ID = @ID; //创建数据库的SqlCommand对象 SqlCommand STcmd = new SqlCommand(STstrsqlSTconn); //向SqlCommand对象添加参数 STcmdParametersAdd(new SqlParameter(@IDSqlDbTypeInt)); //给参数赋值 STcmdParameters[@ID]Value = ID; STcmdConnectionOpen(); try { //执行sql语句 STcmdExecuteNonQuery(); } catch(SqlException) { } STmysql = select STProDeIDSTProd* from STProDeSTProdSTDep where STProDeSTDepID = STDepSTDepID and STProDeSTProdID = STProdSTProdID; STcmdConnectionClose(); ResponseRedirect(STUserProductaspx); } [] [] [] |
