linq to sql select/insert/update/delete

        DataClassesDataContext db = new DataClassesDataContext();
        var challan = from c in db.viewchallans where c.Brand_Name=="Brand"
                      select c;

        GridView1.DataSource = challan;
        GridView1.DataBind();
        DataClassesDataContext db = new DataClassesDataContext();
        {
            buddget bud = new buddget
            {
                Buddegerbetwwen = "2000000"
            };
            db.buddgets.InsertOnSubmit(bud);
            db.SubmitChanges();
        }
 
        DataClassesDataContext db = new DataClassesDataContext();
        var challan = from c in db.viewchallans where c.Brand_Name.Contains("Brand")
                      select c;
        db.SubmitChanges();