protected void Page_Load(object sender, EventArgs e) { CarsInfoEntities db = new CarsInfoEntities(); var result = from a in db.Brands select new { a.BrandName }; GridView1.DataSource = result; GridView1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { String index = Request.QueryString["index"]; CarsInfoEntities db = new CarsInfoEntities(); Brand br = db.Brands.FirstOrDefault(m => m.BrandName == index); br.BrandName = txtboxBrand.Text; db.SaveChanges(); ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Brand Name has been successfully updated')</script>"); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { String index = Request.QueryString["index"]; CarsInfoEntities db = new CarsInfoEntities(); Brand br = db.Brands.FirstOrDefault(m => m.BrandName == index); txtboxBrand.Text = br.BrandName; } }
protected void Page_Load(object sender, EventArgs e) { CarsInfoEntities db = new CarsInfoEntities(); var result = from t in db.Cars join x in db.Brands on t.BrandId equals x.BrandId select new { x.BrandName, t.Model, t.Costs }; GridView1.DataSource = result; GridView1.DataBind(); }
protected void GridView1_RowEditing1(object sender, GridViewEditEventArgs e) { String index = GridView1.DataKeys[e.NewEditIndex].Value.ToString(); CarsInfoEntities db = new CarsInfoEntities(); var data = (from c in db.Cars where c.Model == index select new { c.BrandId }).ToList(); String id = data.ElementAt(0).BrandId.ToString(); Server.Transfer("CarEdit.aspx?index=" + index + "&id=" + id); }
protected void Button1_Click(object sender, EventArgs e) { CarsInfoEntities db = new CarsInfoEntities(); var data = from c in db.Brands where c.BrandName == txtSearch.Text select new { c.BrandName }; GridView1.Visible = false; GridView2.DataSource = data; GridView2.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { CarsInfoEntities db = new CarsInfoEntities(); var result = from t in db.Cars join x in db.Brands on t.BrandId equals x.BrandId where t.Model == txtModel.Text select new { x.BrandName, t.Model, t.Costs }; GridView1.Visible = false; GridView2.DataSource = result; GridView2.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { String index = Request.QueryString["index"]; String id = Request.QueryString["id"]; CarsInfoEntities db = new CarsInfoEntities(); Car c = db.Cars.FirstOrDefault(m => m.Model == index); c.Model = txtModel.Text; c.BrandId = int.Parse(ddlBrand.SelectedValue); c.Costs = int.Parse(txtCosts.Text); db.SaveChanges(); ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Car details have been successfully updated')</script>"); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack == false) { CarsInfoEntities db = new CarsInfoEntities(); String index = Request.QueryString["index"]; String id = Request.QueryString["id"]; ddlBrand.SelectedValue = id; Car c = db.Cars.FirstOrDefault(m => m.Model == index); txtModel.Text = c.Model; txtCosts.Text = Convert.ToString(c.Costs); } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { String s = GridView1.DataKeys[e.RowIndex].Value.ToString(); CarsInfoEntities db = new CarsInfoEntities(); Car c = db.Cars.FirstOrDefault(m => m.Model == s); db.DeleteObject(c); db.SaveChanges(); ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Record has been deleted successfully')</script>"); var result = from t in db.Cars join x in db.Brands on t.BrandId equals x.BrandId select new { x.BrandName, t.Model, t.Costs }; GridView1.DataSource = result; GridView1.DataBind(); }
protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e) { String s = GridView2.DataKeys[e.RowIndex].Value.ToString(); CarsInfoEntities db = new CarsInfoEntities(); Brand br = db.Brands.FirstOrDefault(m => m.BrandName == s); db.DeleteObject(br); db.SaveChanges(); ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Record has been deleted successfully')</script>"); var data = from a in db.Brands select new { a.BrandName }; GridView1.Visible = true; GridView2.Visible = false; GridView1.DataSource = data; GridView1.DataBind(); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { String s = GridView1.DataKeys[e.RowIndex].Value.ToString(); CarsInfoEntities db = new CarsInfoEntities(); Brand br = db.Brands.FirstOrDefault(m => m.BrandName == s); db.DeleteObject(br); try { db.SaveChanges(); } catch (Exception) { ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Cannot delete record. Foreign key constraint violated.')</script>"); } ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Record has been deleted successfully')</script>"); var data = from a in db.Brands select new { a.BrandName }; GridView1.DataSource = data; GridView1.DataBind(); }