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