Target Audience
Beginners who are learning C# MVC
and want to get record from SQL server to browser using jquery ajax.
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
View
<input type="button" value="Get
Data" onclick="GetData()"/>
<table>
<thead>