private void BindTheGrid() { using (DemoDatabaseDB db = new DemoDatabaseDB()) { var listP = db.PersonalDetails; var listF = db.Files; var data = from p in listP join f in listF on p.AutoId equals f.PersonalDetailsId where p.FirstName.Contains("S") select new { f.FileName, p.Active, p.Age, p.AutoId, p.FirstName, p.LastName }; GridView1.DataSource = data; GridView1.DataBind(); } }
void ListRecords() { using (DemoDatabaseDB db = new DemoDatabaseDB()) { GridView1.DataSource = db.PersonalDetails; GridView1.DataBind(); GridView2.DataSource = db.Menus; GridView2.DataBind(); } }
protected void DeleteRecord(object sender, EventArgs e) { using (DemoDatabaseDB db = new DemoDatabaseDB()) { PersonalDetail p = db.PersonalDetails.Where(pp => pp.AutoId.Equals(52)).FirstOrDefault(); db.PersonalDetails.DeleteObject(p); db.SaveChanges(); } lblMessage.Text = "Record delete from the database successfully!"; }
/// <summary> /// Binds the grid. /// </summary> private void BindTheGrid() { using (DemoDatabaseDB db = new DemoDatabaseDB()) { var data = from d in db.PersonalDetails where d.FirstName.Contains("S") select d; var datas = db.PersonalDetails.OrderBy(p => p.FirstName).Take(5).Skip(2); GridView1.DataSource = db.PersonalDetails; //data; GridView1.DataBind(); } }
protected void UpdateRecord(object sender, EventArgs e) { using (DemoDatabaseDB db = new DemoDatabaseDB()) { PersonalDetail p = db.PersonalDetails.Where(pp => pp.AutoId.Equals(52)).FirstOrDefault(); p.Active = false; p.Age = 30; p.FirstName = "Ranjit modified"; p.LastName = "Mahato modified"; db.SaveChanges(); } lblMessage.Text = "Record updated to the database successfully!"; }
protected void InsertRecord(object sender, EventArgs e) { PersonalDetail p = new PersonalDetail() { Active = true, Age = 20, FirstName = "Ranjit", LastName = "Mahato" }; using (DemoDatabaseDB db = new DemoDatabaseDB()) { db.PersonalDetails.AddObject(p); db.SaveChanges(); } lblMessage.Text = "Record added to the database successfully!"; }
protected void SubmitData(object sender, EventArgs e) { int id = 0; int.TryParse(txtAutoId.Text.Trim(), out id); if (!id.Equals(0)) { using (DemoDatabaseDB db = new DemoDatabaseDB()) { var data = db.GetRecords(id); GridView1.DataSource = data; GridView1.DataBind(); } } else { lblMessage.Text = "Please enter numeric value only !"; } }
protected void SaveUsingLinqWithTransaction(object sender, EventArgs e) { using (TransactionScope scope = new TransactionScope()) { try { using (DemoDatabaseDB db = new DemoDatabaseDB()) { PersonalDetail p = new PersonalDetail() { Active = true, Age = int.MaxValue, FirstName = "firstnamne", LastName = "lastname" }; db.PersonalDetails.AddObject(p); db.SaveChanges(); DemoDatabaseModel.Menu m = new DemoDatabaseModel.Menu() { MenuDescription = "description1", MenuName = "Menu1Menu1Menu1Menu1Menu1Menu1Menu21", //Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1Menu1", MenuUrl = "http://www.fundooVideo.com/", ParentMenuId = 1, MenuId = 127 }; db.Menus.AddObject(m); db.SaveChanges(); } scope.Complete(); } catch (Exception ee) { Response.Write(ee.ToString()); } } }