Adding New Record to Database II - Course Introduction to jQuery UI - Part 28 | web Developer courses

Duration: 17:22 min

Summary: In the video, we are proceeding with the ability to add, edit and delete records from the database.After setting the stage in the previous video by creating the skeleton of the function that will be called on the service side, we added the needed functionality to insert a new Employee. We did so by opening a connection to the database (using the connection string we setup before), creating a command that represents the stored procedure, setting up the correct parameters, and executing the command. On the page side, we added the editurl parameter that calls the appropriate function, and we modified some of the column properties and options to be able to load the dialog that allows us to enter a new employee and submit the information to the service. Next, we will add the final touch so we can actually add the employee.

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