ASP.Net MVC CRUD Operations Using jQuery JSON and LINQ To SQL Class

In this index view create a webgrid, script for a window open to insert data, an edit data and a delete dialog box.

2. Create View (Insert data)

Create a view to create a partial view .


Figure 11: Add Create view

This section also created a script for the model data insert into the table.

Create View Code
3. Edit View (Update Employee)

Also create an Editview as a Partial view.


Figure 12: Add Edit View

Edit view code In this view also create an update record script as in the following.

Finally all the operation views are created and can be seen in the project solution.


Figure 13: Views

Step: Models

Now create a Model for EmployeeInfo as in the following:


Figure 14: Add Models class


Figuer 15: Class Name

Models Class Code
Now run your MVC example in a browser.


Figure 16: Run Application.

Now click the Add New Employee button and insert a record as in the following:


Figure 17: Add Record

Now delete the record without 130 with the delete button.


Figure 18: Record Delete


Figure 19: Selected record opened with the Edit dialog

Press the update button and close the dialog and check the record in the webgrid.


Figure 20: Record Update

Finally you have learned how to do Create, Retrieve, Update and Delete (CRUD) operations in MVC with jQuery JSON and LINQ to SQL classes.

Note: Please maintain your database connection for CRUD.

Have a nice Day.