Your question explanation has complete code but no error details, can you provide what was the error while connecting to database ?? As I don't find any issue in the above code, please check if there is any data in the database table to which you have connected the project.

I have added a completely new article for explaining CRUD operations using jqGrid in MVC, well tested and with code details, you can read it here