Click here to Skip to main content
15,115,557 members
Articles / Web Development / ASP.NET
Tip/Trick
Posted 5 Feb 2011

Stats

39.9K views
8 bookmarked

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

Rate me:
Please Sign up or sign in to vote.
3.75/5 (7 votes)
6 Feb 2011CPOL
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
No Biography provided

Comments and Discussions

 
Questioninsert using linq Pin
Member 995422424-Apr-14 6:43
MemberMember 995422424-Apr-14 6:43 
Questionlinq to sql basic Pin
SuhasHaridas13-Aug-12 1:15
MemberSuhasHaridas13-Aug-12 1:15 
GeneralWhat is most advantage of Linq to sql? Pin
kishore30914-Feb-11 20:08
Memberkishore30914-Feb-11 20:08 
GeneralRe: What is most advantage of Linq to sql? Pin
SuhasHaridas13-Aug-12 1:19
MemberSuhasHaridas13-Aug-12 1:19 
GeneralReason for my vote of 3 nothing excited!! Pin
maq_rohit8-Feb-11 2:28
professionalmaq_rohit8-Feb-11 2:28 
Generaledited for formatting and spelling Pin
Shahriar Iqbal Chowdhury/Galib5-Feb-11 5:47
professionalShahriar Iqbal Chowdhury/Galib5-Feb-11 5:47 
GeneralThank you for your tip. Besides the formatting also include ... Pin
Patrick Kalkman5-Feb-11 3:07
MemberPatrick Kalkman5-Feb-11 3:07 
GeneralRe: Thank you for your tip. Besides the formatting also include ... Pin
SuhasHaridas13-Aug-12 1:20
MemberSuhasHaridas13-Aug-12 1:20 
GeneralPlease fix the formatting Pin
Indivara5-Feb-11 2:15
professionalIndivara5-Feb-11 2:15 
GeneralRe: Please fix the formatting Pin
SuhasHaridas13-Aug-12 1:20
MemberSuhasHaridas13-Aug-12 1:20 

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

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