Save and Retrieve using Jquery with Grid

CREATE TABLE [dbo].[student_tbl](
   [Sregno] [int] IDENTITY(1, 1) NOT NULL,
   [sname] [varchar](50) NULL,
   [saddress] [varchar](max) NULL,
   [mobile] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO Create PROCEDURE [dbo].[Studinfo] (
   @sregno INT,
   @sname varchar(50),
   @saddress varchar(max),
   @mobile int,
   @mode varchar(10) = ''
) AS BEGIN IF @mode = 'Insert' BEGIN insert into student_tbl (sname, saddress, mobile)
values
   (@sname, @saddress, @mobile) END IF @mode = 'Select' BEGIN
select
*
from
   student_tbl END IF @mode = 'Update' BEGIN
update
   student_tbl
set
   sname = @sname,
   saddress = @saddress,
   mobile = @mobile
WHERE
   Sregno = @sregno END else IF @mode = 'Delete' BEGIN
DELETE FROM
   student_tbl
WHERE
   Sregno = @sregno END end GO