Delete Record MVC Ajax

Target User

Beginner He/She learning MVC and want to delete a record by clicking on delete button on table row.

Table Stucture

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

Model

public class StudentModel

{

    public int Roll { get; set; }

    public string Name { get; set; }

    public string City { get; set; }

}

Controller

//Show Record Page

public ActionResult ShowData()

Plane C Graphics

/*==============================

      Girfa Student Help

      Program :Plane C Graphics

      More Program :http://girfahelp.blogspot.in/p/graphics-c-language.html

================================*/

#include <graphics.h>

#include <stdlib.h>

#include <stdio.h>

#include <conio.h>

#include <dos.h>

void drawplane(int);

int main(void)

{

   /* request auto detection */

   int gdriver = DETECT, gmode, error

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; }