c# - jqGrid ASP.NET WebForms cellurl doesn't work -

-

i edit data in grid. can edit in table , see don't go c# method. tried ajax doesn't work too...serialization doesn't work too. wrong?

    [webmethod]     public static string loaddata()     {         sqlconnection cn = new sqlconnection(configurationmanager.connectionstrings["conn"].connectionstring);         sqldataadapter da = new sqldataadapter("select * employees", cn);         dataset ds = new dataset();         da.fill(ds);         return jsonconvert.serializeobject(ds.tables[0]);     }      [webmethod]     public void updategrid()     {         //code update database         sqlconnection cn = new sqlconnection(configurationmanager.connectionstrings["conn"].connectionstring);         sqldataadapter da = new sqldataadapter("select * employees", cn);     } }

and js:

$(document).ready(function () {         $("#btnemployee").click(function () {             var service = "default.aspx/loaddata";             var lastsel2;             $.ajax({                 url: service,                 datatype: "json",                 data: "{}",                 contenttype: "application/json; charset=utf-8",                 method: "post",                 success: function (result) {                     result = result.d;                     jquery("#emptable").jqgrid({                         datatype: "local",                         colnames : ['emp numb', 'first name', 'second name', 'salary'],                         colmodel: [                             { name:"emp_id", index: "emp_id", width:80, editable: true},                             { name: "first_name", index: "first_name", width: 80, editable: true},                             { name: "second_name", index: "second_name", width: 80, editable: true},                             { name: "salary", index: "salary", width: 80, editable: true}                         ],                         data: json.parse(result),                         rownum: 10,                         loadonce: true,                         rowlist: [5, 10, 20],                         pager: '#emppager',                         viewrecords: true,                         sortorder: 'asc',                         gridview: true,                         autowidth: true,                         sortname: 'emp_id',                          altrows: true,                         hoverrows: true,                          onselectrow: function (id) {                             if (id && id !== lastsel2) {                                 jquery('#emptable').restorerow(lastsel2);                                 jquery('#emptable').editrow(id, true);                                 lastsel2 = id;                             }                          },                         caption: "events",                         cellurl: 'default.aspx/updategrid'                     });                     $("#emptable").jqgrid('navgrid', '#emppager', { edit: true, add: true, del: false });                     $("#emptable").jqgrid('inlinenav', "#emppager");                      },                 error: function (error) {                     alert("oops!");                 }             });         });                  });


Comments

Post a Comment

Popular posts from this blog

sql - VB.NET Operand type clash: date is incompatible with int error -

-
i trying display records table named staffpresentee database using clause... i using visual studio 2010... the table design follows- .......fieldname..................datatype........allownull 1......staff_id (fk).............numeric(18,0)......yes 2.......date........................date.............no 3......present.....................char(1)..........yes note type of 2nd field date , not datetime... i want display records table have today's date int 'date' field... current query is- cmd = new sqlclient.sqlcommand("select * staffpresentee date=" & date.now.date, cn) dr = cmd.executereader for dr = cmd.executereader error "operand type clash: date incompatible int" i tried select * staffpresentee query without clause runs correctly. try putting date value in sigle quotes maybe. cmd = new sqlclient.sqlcommand("select * staffpresentee date='" & _
Read more

SVG stroke-linecap doesn't work for circles in Firefox? -

-
i've got problem svg stroke-linecap attribute. i've got circular progress bar in angularjs , set outer circle (blue one) have rounded "ends". @ fiddle . <svg ... height="130" width="130"> <!-- ngif: background --> <circle ... ng-if="background" fill="#fff" class="ng-scope" stroke-width="13" stroke="#cc3399" r="57.5" cy="65" cx="65" stroke-linecap="round" /> <!-- end ngif: background --> <circle ... fill="none" stroke-dashoffset="36.12831551628261" stroke-dasharray="361.28315516282623" stroke-width="13" stroke="#432db3" stroke-linecap="round" r="57.5" cy="65" cx="65" transform="rotate(-89.9, 65, 65)" /> </svg> how can that?
Read more

python - TypeError: Scalar value for argument 'color' is not numeric in openCV -

-
here code im = cv2.imread('luffy.jpg') gray = cv2.cvtcolor(im,cv2.color_bgr2gray) ret,thresh = cv2.threshold(gray,127,255,0) contours,h = cv2.findcontours(thresh,cv2.retr_tree,cv2.chain_approx_simple) cnt in contours: moment = cv2.moments(cnt) c_y = moment['m10']/(moment['m00']+0.01) c_x = moment['m01']/(moment['m00']+0.01) centroid_color = im[c_x,c_y] centroid_color = np.array((centroid_color[0],centroid_color[1],centroid_color[2])) print type(centroid_color) cv2.fillpoly(im,cnt,centroid_color) i getting error on last line try , pass centroid_color color argument. <type 'numpy.ndarray'> , have been able pass data type cv2.fillpoly color in other instances, not sure why having problem here. fillpoly() expects iterable, i.e. put cnt in brackets. believe duplicate of https://stackoverflow.com/a/17582850/5818240 . moreover, centroid color variable contains strings. need convert them i
Read more