Adding New Record to Database III - Course Introduction to jQuery UI - Part 29 | web Developer courses

Duration: 16:50 min

Summary: In the video, we wrap up the adding functionality. After we created the stored procedure and the web service method, we started the page modification to be able to make the appropriate call to the service and add a new employee. We confirmed that the editurl is correct and the pager navigation options are turned on. Then we moved to the jQuery extension where we setup the ajaxEditOptions, recreateForm, serializeEditData, and stringify to be able to send the data the way the web service will understand them. Finally, we loaded the page and tried to add a new employee. The process worked as expected. But more importantly, we were able to view the incoming and outgoing request/response using Fiddler2. When we did so, it became clear to us why the service was setup with the correct “id” and “Oper”.

Technologies and Resources: jQuery, jqGrid, Visual Studio 2010,WebService, asmx, Compare, StringComparison, output, database, identity, varchar, decimal, SqlConnection, SqlCommand, Open, CommadnType, Parameters, ExecuteNonQuery, Convert, reloadAfterSubmit, closeAfterAdd, extend, ajaxEditOptions, recreateForm, serializeEditData, stringify.