Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / web / ASP.NET

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

3.75/5 (7 votes)
6 Feb 2011CPOL 45.7K  
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)