title: Passing dynamic params to delete url method in JQGrid
body: <p>I am using a JQGrid witha  json service to list all the database users membership information, so the url of the grid points to my json service and method.  Everything is working fine so far, I can add and edit the users and amend data and it saves fine.  However the delete of a DB user is another story as the Membership.DeleteUser takes the username as its parameter.  The JQGrid only seems to pass editable params back when in add or edit mode.  But when you're trying to delete it doesn't seem to allow any params to be returned which I find very odd.  I have only just started using JQGrids so I could just be being thick :-).  Please can anyone tell me how to accomplish this?  I have the username as a column in the JQGrid itself.  I have tried various things to date:</p>
  
  <p>url: 'misc/myservice.svc/AddEditDeleteGridRow?UserName=' + $('#MyGridTbl').getCell('selrow', 'UserName')</p>
  
  <p>in the delete section of the navGrid.  I have also tried setting the URL in the select row event too but I found it required a reload to insert it into the grid and when this happens the selected row is lost and so defeats the object.  I just need to be able to access/get the username inside the json service in order to pass it to Membership.DeleteUser.  I have been searching the internet and can't seem to find anything.</p>
  
  <p>Here is the JQGrid I am using.  There json service basically just has the GetData which returns JQGridJSONData (json object dataset) and AddEditDeleteGridRow methods in it, both are public.  All the column data is being sent to the json service for the add and edit but nothing is being sent for the delete operation.</p>
  
  <p>Just to clarify I need the UserName on the server side in the json service.</p>
  
  <pre><code>   $('#MyGrid').jqGrid({
      url: 'Misc/MyjsonService.svc/GetData',
      editurl: 'Misc/MyjsonService.svc/AddEditDeleteGridRow',
      datatype: 'json',
      colNames: ['UserId', 'UserName', 'Email Address', 'Password Last Changed', 'Locked'],
      colModel: [
                  { name: 'UserId', index: 'UserId', hidden:true, editable: true, editrules:{edithidden: true}},
                  { name: 'UserName', index: 'UserName', editable: true, width: 200, sortable: false, editrules: { required: true} },
                  { name: 'Email Address', index: 'Email', editable: true, width: 500, sortable: false, editrules: { email: true, required: true} },
                  { name: 'Password Last Changed', index: 'LastPasswordChangedDate', editable: false, width: 200, sortable: false, align: 'center' },
                  { name: 'Locked', index: 'IsLockedOut', sortable: false, editable: true, edittype: "checkbox", formatter: 'checkbox', align: 'center' }
              ],
      rowNum: 20,
      hidegrid: false,
      rowList: [20, 40, 60],
      pager: $('#MyGridPager'),
      sortname: 'UserName',
      viewrecords: true,
      multiselect: false,
      sortorder: 'asc',
      height: '400',
      caption: 'Database Users',
      shrinkToFit: false,
      onPaging: function(pgButton) {
          this.DBUserId = null;
      },
      onSelectRow: function(Id) {
          if (Id &amp;&amp; Id !== this.DBUserId) {
              this.DBUserSelect(Id);
          }
      },
      loadComplete: function() {
          if (this.DBUserId)
              this.DBUserSelect(this.DBUserId, true);
      },
      gridComplete: function() {
          var grid = $('#MyGrid');
          var body = $('#AvailableDBUsersArea');
          if ((grid) &amp;&amp; (body)) {
              grid.setGridWidth(body.width() - 10);
  
              //keep the grid at 100% width of it's parent container
              body.bind('resize', function() {
                  var grid = $('#MyGrid');
                  var body = $('#AvailableDBUsersArea');
                  if ((grid) &amp;&amp; (body)) {
                      grid.setGridWidth(body.width() - 2);
                  }
              });
          }
      }
  }).navGrid('#MyGridPager',
          { add: true, edit: true, del: true, refresh: false, search: false }, //general options
          {
          //Options for the Edit Dialog
          editCaption: 'Edit User',
          height: 250,
          width: 520,
          modal: true,
          closeAfterEdit: true,
          beforeShowForm: function(frm) { $('#UserName').attr('readonly', 'readonly'); },
          beforeShowForm: function(frm) { $('#UserId').removeAttr('readonly'); },
          beforeShowForm: function(frm) { $('#UserId').attr('readonly', 'readonly'); }
      },
          {
              //Options for the Add Dialog
              addCaption: 'Add User',
              height: 250,
              width: 520,
              modal: true,
              closeAfterAdd: true,
              beforeShowForm: function(frm) { $('#UserName').removeAttr('readonly'); },
              beforeShowForm: function(frm) { $('#UserId').removeAttr('readonly'); },
              beforeShowForm: function(frm) { $('#UserId').attr('readonly', 'readonly'); }
          },
          {
              //Delete options
              width: 350,
              caption: 'Delete User',
              msg: 'Are you sure you want to delete this User?\nThis action is irreversable.'
          },
          {} //Search options
      );
  </code></pre>