Database operation in mvc

See more:

MVC3

Hi All,

My requirement is in my MVC razor page having one search box and button.

I need the records from the db according to the search result using jquery ajax post method.
How could I create an ER diagram from an sqlstoredprocedure and How it use in Model
as I am not good enough knowledge in ER diagram.The sqlstored procedure return the value from different tables with a where condition like(if groupid=1{select * from table1)else
{select * from table2}).This result should pass in to the view using ajax onsuccess call

The above result how could I shows in a gridview with an edit function and paging(I am confused that which gridview is sutiable for MVC)

Please help me

Thanks & Regards,
soumyaraj