Tuesday, 3 September 2013

LINQ(LANGUAGE INTEGRATED QUERRY) TO SQL USING C#,ASP.NET SAMPLE SAVING FORM?

WE NEED TO DEVELOPE SIMPLE SAVING FORM USING LINQ TO SQL:

->OPEN VISUAL STUDIO  SELECT THE FILE & SELECT THE NEW WEB APPLICATION GIVE FILE NAME AS SAMPLE LINQ.

-> FROM SOLUTION EXPLORE ADD A NEW AND GIVE PAGE NAME AND ADD THE TWO TEXT BOXES AND ONE BUTTON.

->GIVE TEXT BOX LABEL NAMES  AS(NAME,QUALIFICATION) AND GIVVE BUTTON NAME AS SUBMIT.

CREATE DATA BASE:

 -> OPEN THE SQL SERVER 2008
->CREATE A NEW DATABASE AND GIVE DATA BASE NAME.

->CREATE THE TABLE  GIVE TABLE NAME AS "EMP" AND ADD THE COLOUMNS AS NAME(VARCHAR(50)) AND QUALIFICATION (VARCHAR(50)),ID(INT))

->SELECT ID AS PRIMARY KEY AND SELECT AUTO INCREMENT COLUMNS.

->OPEN THE SERVER EXPLORER ADD THE DATA BASE.

->FROM THE SOLUTION EXPLORER ADD THE .DBML AND GIVE NAME AS "SAMPELINQ".OPEN THE .DBML DRAG AND DROP THE TABLES FROM SERVER EXPLORER TO THE .DBML.

->THE CONNECTION STRING IS AUTOMATICALLY ADDED IN THE WEB.CONFIG FILE.

->OPRN THE FORM AND DOUBLE CLICK ON THE SUBMIT BUTTON.

CODE BEHIND THE FORM:

using var context=new samplelinq datacontext()
{

emp en=new wmp()
{
en.name=txtname.text;
en.qualification=txtqualification.text;
context.emps.insertonsubmit(en);
context.submitchanges();

}

}




No comments:

Post a Comment