Click here to Skip to main content
Click here to Skip to main content
Go to top

Create Linq to SQL connection with select, insert, delete, update

, 6 Feb 2011
Rate this:
Please Sign up or sign in to vote.
Create Linq to SQL connection with select, insert, delete, update
* Create new website
* Add new item
→ Select LINQ TO SQL classes
Then, create one dataclasses.dbml file.
Tool→connect to database→ change data source
→ Select datasource (Microsoft sqlserver)
→ Select data provider .NET Framework (data provider for sqlserver)
→ Select servername, SQL authentication and database
→ Select dataclasses.dbml and we can choose the table and drag into the dataclasses.dbml file. Class for that Table will be created automatically.
 
Codes on default.aspx.cs at code behind page.
 
private void gridview()
{
   DataClassesDataContext dh = new DataClassesDataContext();
   var s = from data in dh.tests 
           orderby data.id descending 
           select new { data.id ,data.name, data.@class };
       
   GridView1.DataSource = s;
   GridView1.DataBind();
}

protected void insert_Click(object sender, EventArgs e)
{
   DataClassesDataContext dh = new DataClassesDataContext();
   test t = new test { id = Guid .NewGuid ().ToString (), 
                       name =TextBox1 .Text , 
                       @class = TextBox2 .Text 
                      };
   dh.tests.InsertOnSubmit(t);
   dh.SubmitChanges();
   gridview();
}
 
protected void update_Click(object sender, EventArgs e)
{
   DataClassesDataContext dh = new DataClassesDataContext();
   //test tt = dh.tests.First(p => p.name.StartsWith("manu"));
   test tt=dh.tests.Single (p1 => p1.name.StartsWith ("manu"));
   tt.@class +=4;
   tt.name = "raju";
   dh.SubmitChanges();
   gridview();
}
 
protected void delete_Click(object sender, EventArgs e)
{
   DataClassesDataContext dh = new DataClassesDataContext();
   test tt = dh.tests.First(p => p.name.StartsWith("new"));
   dh.tests.DeleteOnSubmit(tt);
   dh.SubmitChanges();
   gridview();
}

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

SuhasHaridas
Software Developer Standout IT Solutions(P) Ltd.
India India
My name is SuhasHaridas.
 
I'm a Software Engineer in the .NET Developer Platform group within the Developer Division at Standout IT Solutions(P) Ltd.
I have focused on the Web platform during these years.Specifically, that means I have worked on ASP.NET and c#.NET ,SharePoint,Sql, WCS Apps(Cisco Wireless Control System),.NET Compact Framework, LINQ , ADO.NET , Ado.net entity framework ,Silverlight , WCF Services , SQL SQLCE Visual Studio and Visual Studio Web Developer as well as on IIS7.
Follow on   Twitter   Google+

Comments and Discussions

 
Questioninsert using linq PinmemberMember 995422424-Apr-14 5:43 
Questionlinq to sql basic PinmemberSuhasHaridas13-Aug-12 0:15 
GeneralWhat is most advantage of Linq to sql? Pinmemberkishore30914-Feb-11 19:08 
GeneralRe: What is most advantage of Linq to sql? PinmemberSuhasHaridas13-Aug-12 0:19 
GeneralReason for my vote of 3 nothing excited!! Pinmembermaq_rohit8-Feb-11 1:28 
Generaledited for formatting and spelling PinmemberShahriar Iqbal Chowdhury5-Feb-11 4:47 
GeneralThank you for your tip. Besides the formatting also include ... PinmemberPatrick Kalkman5-Feb-11 2:07 
GeneralRe: Thank you for your tip. Besides the formatting also include ... PinmemberSuhasHaridas13-Aug-12 0:20 
GeneralPlease fix the formatting PinsubeditorIndivara5-Feb-11 1:15 
GeneralRe: Please fix the formatting PinmemberSuhasHaridas13-Aug-12 0:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 7 Feb 2011
Article Copyright 2011 by SuhasHaridas
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid