Get Single value from database using ajax

Store Procedure

USE [Girfa_StudentHelp]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER proc [dbo].[GetPhone]

(

   @id int

Get Data from server Using ajax

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>

Internet & Web design Sample paper set 2

I

Internet & Web Design

Time: 1 hour                                                                                           Name: ______________

Note: All question of part-1 is mandatory and each question is carrying one marks. 2 questions are compulsory out of 4 from part-2.

(Part one)

Multiple Choices

1.  Effectiveness of data communication is depend on

a)      Delivery   b) Accuracy   c)Timeliness   d)All

2. Which of the following is not considered as network performance criteria?

a) Performance    b) Reliability   c)Security   d) Brand

3. Application of data communication is

a) Marketing & Sales   b)Manufacturing c) EDI  d) All

Longest common sequence

Given sequences say “MNOP” and NPA”

Longest common sequence of LCS is a sequence that appears in the same relative order in both the given sequence but not necessarily in a continuous manner.

See the example

M

N

O

P