Create a Web Page using Razor without Entity Framework.

Question

Requirement:

1.Web Page using Razor without Entity Framework.
2.Page Containg grid with edit & Delete Button
3. Edit & Delete should be written in same view page

4. Update data using stored procedure

Can Anyone help me regarding this scenario Thanks.

Sachin Singh · Answer

Paste the below code , it is self explainatory. @model IEnumerable Vehicle Details Id Name ChasisNo OwnerId @ foreach (var item in Model) { @item.Id @item.Name @item.ChasisNo @item.OwnerId "submit" >Show "btn" type= "submit" data-Id= "@item.Id" onclick= "Edit(this)" > Edit "btn" type= "submit" data-Id= "@item.Id" onclick= "deletee(this)" > Delete } "Edit" > function Edit(e) { debugger; var id=$(e).attr( "data-Id" ); $.ajax({ type: "post" , url: "/Home/PartialEdit" , data: { id: id }, datatype: JSON, cache: false , success: function(val) { $( "#Edit" ).html(val) } }) } function deletee(e) { debugger; var id = $(e).attr( "data-Id" ); $.ajax({ type: "post" , url: "/Home/Delete" , data: { id: id }, datatype: JSON, cache: false , }) } public class AutoModel { public int Id { get ; set ; } public string Name { get ; set ; } public int ChasisNo { get ; set ; } public int OwnerId { get ; set ; } } //Index view "~/Home/Create" method= "post" > Id "text" name= "Id" value= " " /> Name "text" name= "Name" value= " " /> ChasisNo "text" name= "ChasisNo" value= " " /> OwnerId "text" name= "OwnerId" value= " " /> "submit" name= "Save" > Save //Partial page for edit model Automobile.Models.AutoModel "/Home/Update" method= "post" > Id "text" name= "Id" value= "@Model.Id" /> Name "text" name= "Name" value= "@Model.Name " /> ChasisNo "text" name= "ChasisNo" value= "@Model.ChasisNo " /> OwnerId "text" name= "OwnerId" value= "@Model.OwnerId " /> "submit" name= "Update" > Update //store procedure CREATE procedure [dbo].[SpgetVehicle] @Id int = null , @Name varchar(50)= null , @ChasisNo int = null , @ownerId int = null , @Type varchar(50) as begin if (@Type= 'Select' ) begin select * from Vehicle end if (@Type= 'Insert' ) begin insert into Vehicle values (@Name,@ChasisNo,@ownerId) end if (@Type= 'Update' ) begin Update Vehicle set Name=@Name,ChasisNo=@ChasisNo,OwnerId=@ownerId where Id=@Id end if (@Type= 'Delete' ) begin delete from Vehicle where Id=@Id end end GO