数据表中删除记录 避免用 delete 应单独设置字段,防止误删 private void deleteproductinfo( int tempid){ sqlconnection con = null ; bool flag = false ; try {con = new sqlconnection(configurationmanager.appsettings[ connectionstring ]); string
数据表中删除记录 避免用 delete 应单独设置字段,防止误删
private void deleteproductinfo(int tempid){ sqlconnection con = null; bool flag = false; try {con = new sqlconnection(configurationmanager.appsettings[connectionstring]);string sql = update t_temp set deleted=1 where tempid= + tempid;con.open();sqlcommand com = new sqlcommand(sql, con);flag = com.executenonquery() > 0 ? true : false;con.close(); } catch (sqlexception se) { } finally {con.close(); } if (flag) {myshare.webmessagebox(this.page, 删除成功！); } else {myshare.webmessagebox(this.page, 删除信息时出错，请重试！); }}
posted on
copyright ©2013 porray powered by: 博客园 模板提供：沪江博客
，