LINQ Basic Quires

In this Article we learn Basic LINQ Queries in Asp.Net .

1-      Fill Gridview record:

public void showgridview()

    {

        DataClassesDataContext dc = new DataClassesDataContext();

        var q =

        from a in dc.GetTable<bio>()

        select a;

        GridView1.DataSource = q;

        GridView1.DataBind();
   
   }

         

                 

2-      Search record:

public void SearchQuery()

    {

        DataClassesDataContext dc = new DataClassesDataContext();

        var q =

        from a in dc.GetTable<bio>()

        where a.name == TextBox3.Text

        select a;

        GridView1.DataSource = q;

        GridView1.DataBind();

    }

                   

3-      Insert Record

  Public void InsertQuery()

    {

        DataClassesDataContext dc = new DataClassesDataContext();

        bio obj = new bio();

        obj.name = TextBox3.Text;

        obj.passw = TextBox5.Text;

        obj.fname = TextBox4.Text;

        dc.bios.InsertOnSubmit(obj);

        dc.SubmitChanges();

        showgridview();

    }

                     

4-      Update record

public void UpdateQuery()

    {

        DataClassesDataContext dc = new DataClassesDataContext();

        bio objbio = dc.bios.Single(bio => bio.name == TextBox3.Text);

        objbio.passw = TextBox5.Text;

        objbio.fname = TextBox4.Text;

        dc.SubmitChanges();

    }

                     

5-      Delete Record

public void DeleteQuery()

    {

        DataClassesDataContext dc = new DataClassesDataContext();

        bio obb = dc.bios.Single(bio => bio.name == TextBox3.Text);

        dc.bios.DeleteOnSubmit(obb);

        dc.SubmitChanges();

    }

                    

6-      Inner Join

There is two table fee and bio.

Bio Table:

                            

                         

Fee Table:

                         

DataClassesDataContext dc = new DataClassesDataContext();

        var biofee = from bio in dc.bios

                     join fee in dc.fees

                     on bio.id equals fee.id

                     select new { bio.name, bio.fname, fee.Address };

        GridView1.DataSource = biofee;

        GridView1.DataBind();

//You can also do this with the help of lambda operator

// Inner joinning Usin lambda operator

        DataClassesDataContext dc = new DataClassesDataContext();

        var query = dc.bios.Join(dc.fees, r => r.id, p => p.id, (r, p) => new { r.name, r.fname, p.Address });

        GridView1.DataSource = query;

        GridView1.DataBind();