查看用户权限 用户信息的查看、修改和删除[4]

用户信息的查看、修改和删除[4]  

    ——此文章摘自《ASP NET +SQL Server网络应用系统开发案例精解》定价 ￥ 　特价 ￥ 详细>>//track linktech cn/?m_id=dangdang&a_id=A &l= &l_type = width= height= border= nosave>

             string STstrsql= update STUser set STNoAdmin = @STNoAdmin STNickName =@STNickName STUserName = @STUserName  where STUserID = @STUserID ;              //创建SqlCommand对象 对sql语句进行操作              SqlCommand STcmd=new SqlCommand(STstrsql STconn);              try              {                        //添加参数                        STcmd Parameters Add(new SqlParameter( @STUserID SqlDbType Int ));                        STcmd Parameters Add(new SqlParameter( @STNickName SqlDbType VarChar ));                        STcmd Parameters Add(new SqlParameter( @STUserName SqlDbType VarChar ));                        STcmd Parameters Add(new SqlParameter( @STNoAdmin SqlDbType Int ));                        string stupdatetext=((TextBox)e Item Cells[ ] Controls[ ]) Text ;                        STcmd Parameters[ @STNickName ] Value=stupdatetext;                        stupdatetext=((TextBox)e Item Cells[ ] Controls[ ]) Text;                        STcmd Parameters[ @STUserName ] Value=stupdatetext;                        stupdatetext=((TextBox)e Item Cells[ ] Controls[ ]) Text;                        STcmd Parameters[ @STNoAdmin ] Value=stupdatetext;                                                                STcmd Parameters[ @STUserID ] Value=STmyGrid DataKeys[(int)e Item ItemIndex];                        //打开连接                        STcmd Connection Open();                            //执行非查询                                     STcmd ExecuteNonQuery();                        STmyGrid EditItemIndex= ;              }              catch(SqlException ex)              {                        throw ex;              }              //关闭连接              STcmd Connection Close();                           BindGrid();           }     （ ）响应取消事件     //单击 取消 按钮所触发的事件     public void STmyGrid_cancel(object source System Web UI WebControls DataGridCommandEventArgs e)     {              //获取DataGrid所要编辑的项的索引为              STmyGrid EditItemIndex= ;              BindGrid();     }

lishixinzhi/Article/program/net/201311/15192