Record Update ajax MVC

Field	Data Type
Roll	Bigint
Name	Varchar(20)
City	Varchar(20

Table Structure 1

Store Procedure

USE [Girfa_Studb]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER proc [dbo].[UpdateProduct]

(

@roll bigint,

@name varchar(100),

@city varchar(100)

)

Save Data MVC Ajax

Target audience

Beginners learning MVC and want to save a from record into database using ajax.

Table Structure

Roll	Bigint
Name	Varchar(20)
City	Varchar(20)

Store Procedure

USE[Girfa_DB]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTERProc[dbo].[AddRecord]

(

@rollbigint,

@namevarchar(20),

@cityvarchar(20)

)

AS

BEGIN

       SETNOCOUNTON;

              INSERTintoStudent(roll,Name,City)values(@roll,@name,@city)

       SETNOCOUNTOFF;

END

Model

publicclassStudentModel

{

publicint Roll { get; set; }

publicstring Name { get; set; }

Data Render Using Razor

Display Student Record on cshtml page in table using Razor

@model IEnumerable<Britanic_MIS.Models.InvoiceModel>

<table >

        <thead>

            <tr><th>Roll</th><th>Name</th><th>City</th></tr>

        </thead>

        <tbody >

                 

                @foreach (var item in Model)

                {

MVC Data Reader with Razor

Store Procedure

USE [Girfa_StudentDB]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

alter proc [dbo].[GetStudentList]

AS

BEGIN

     SET NOCOUNT ON;

           select roll,name,city from dbo.Student

     SET NOCOUNT OFF;

END

Model

public class StudentModel