protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { if (Request.QueryString["menu"] == "5") { DetailsView5.Focus(); this.DetailsView5.ChangeMode(DetailsViewMode.ReadOnly); } if (Request.QueryString["menu"] == "4") { DetailsView2.Focus(); this.DetailsView2.ChangeMode(DetailsViewMode.ReadOnly); } if (Request.QueryString["menu"] == "3") { DetailsView1.Focus(); this.DetailsView1.ChangeMode(DetailsViewMode.ReadOnly); } if (Request.QueryString["menu"] == "2") { DetailsView3.Focus(); this.DetailsView3.ChangeMode(DetailsViewMode.ReadOnly); } if (Request.QueryString["menu"] == "1") { DetailsView4.Focus(); this.DetailsView4.ChangeMode(DetailsViewMode.ReadOnly); } }
protected void Button15_Click(object sender, EventArgs e) { string stcn = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|Database1.mdf;Integrated Security=True;User Instance=True"; SqlConnection con = new SqlConnection(stcn); con.Open(); SqlCommand cmd = new SqlCommand("update customer set custname='" + TextBox2.Text + "', custhostel='" + TextBox3.Text + "' , custroom ='" + TextBox4.Text + "' , custcontact= '" + TextBox5.Text + "' , custemail= '" + TextBox6.Text + "'where custid = '" + cuid + "'", con); cmd.ExecuteNonQuery(); con.Close(); DetailsView4.DataBind(); MultiView2.ActiveViewIndex = 0; //Response.Redirect("~/WebForm2.aspx"); // MultiView1.ActiveViewIndex = 0; }
private void displayDetails(int productid) { using (SqlConnection con = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand("SELECT * from tblSpecifications,tblMeasurement,tblLook,tblInstallation where tblSpecifications.ProductId=tblLook.ProductId and tblLook.ProductId=tblInstallation.ProductId and tblInstallation.ProductId=tblMeasurement.ProductId and tblMeasurement.ProductId=@id;")) { cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@id", SqlDbType.Int).Value = productid; cmd.Connection = con; try { con.Open(); using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); if (dt.Rows.Count > 0) { DetailsView1.DataSource = dt; DetailsView1.DataBind(); DetailsView2.DataSource = dt; DetailsView2.DataBind(); DetailsView3.DataSource = dt; DetailsView3.DataBind(); DetailsView4.DataSource = dt; DetailsView4.DataBind(); divDetails.Style.Add("display", "block"); } } } } catch (Exception ex) { Response.Write(ex.Message); } finally { con.Close(); con.Dispose(); } } } }
protected void DetailsView_ItemCommand(object sender, DetailsViewCommandEventArgs e) { #region ItemCommand Action if (e.CommandName == "Clear") { GridView1.SelectedIndex = -1; DetailsView1.DataBind(); DetailsView2.DataBind(); DetailsView3.DataBind(); DetailsView4.DataBind(); DetailsView5.DataBind(); } if (e.CommandName == "Update") { DetailsView dv = (DetailsView)sender; WriteToLabel("new", "Blue", dv.ID + " Update Processed [" + DateTime.Now.ToString("HH:mm:ss") + "]<br />", dtlLabel); } //dtlLabel.Text = e.CommandName; #endregion ItemCommand Action }
protected void DetailsView1_ModeChanged(object sender, EventArgs e) { if (Request.QueryString["menu"] == "5") { DetailsView5.Focus(); } if (Request.QueryString["menu"] == "4") { DetailsView2.Focus(); } if (Request.QueryString["menu"] == "3") { DetailsView1.Focus(); } if (Request.QueryString["menu"] == "2") { DetailsView3.Focus(); } if (Request.QueryString["menu"] == "1") { DetailsView4.Focus(); } }
/// <summary> /// /// </summary> protected void DetailsView_DataBound(object sender, EventArgs e) { #region DataBound Action DetailsView dv = (DetailsView)sender; #region DataBound Action for DetailsView1 if (dv.ID == "DetailsView1") { // Nothing } #endregion DataBound Action for DetailsView1 #region DataBound Action for DetailsView2 else if (dv.ID == "DetailsView2") { // Nothing } #endregion DataBound Action for DetailsView2 #region DataBound Action for DetailsView3 else if (dv.ID == "DetailsView3") { // Nothing } #endregion DataBound Action for DetailsView3 #region DataBound Action for DetailsView4 else if (dv.ID == "DetailsView4") { // Populate the State/Country Drop Down #region State/Country Populate if Edit Mode if (DetailsView4.CurrentMode == DetailsViewMode.Edit) { Label lblState = (Label)DetailsView4.FindControl("State"); DropDownList dvState = (DropDownList)DetailsView4.FindControl("ddlState"); DropDownList dvCountry = (DropDownList)DetailsView4.FindControl("ddlCountry"); if (dvState != null && dvCountry != null) { //dtlLabel.Text = "Found DDL 1"; if (lblState != null) { //dtlLabel.Text += " [" + lblState.Text + "]"; } try { Populate_StateProvinceCountry(dvState, null, dvCountry); } catch (Exception ex) { Error_Save(ex, "DetailsView4 - DDL State/Country Populate Error"); } } else if (dvState != null) { //dtlLabel.Text = "Found DDL 2"; try { Populate_StateProvinceCountry(dvState, null, null); } catch (Exception ex) { Error_Save(ex, "DetailsView4 - DDL State Populate Error"); } } else if (dvCountry != null) { //dtlLabel.Text = "Found DDL 3"; try { Populate_StateProvinceCountry(null, null, dvCountry); } catch (Exception ex) { Error_Save(ex, "DetailsView4 - DDL Country Populate Error"); } } else { //dtlLabel.Text = "Did not find DDL"; #region DeBug Code //dtlLabel.Text += " [" + DetailsView4.Rows.Count.ToString() + "]"; //foreach (DetailsViewRow dvr in DetailsView4.Rows) //{ // dtlLabel.Text += "<br />" + dvr.Cells.Count.ToString(); // dtlLabel.Text += " - " + dvr.Cells[0].Text.ToString(); // dtlLabel.Text += " - " + dvr.Cells[0].Controls.Count.ToString(); // dtlLabel.Text += " - " + dvr.Cells[1].Controls.Count.ToString(); // //dtlLabel.Text += " - " + dvr. // foreach (Control ctl in dvr.Cells[1].Controls) // { // dtlLabel.Text += "<br />---" + ctl.ClientID.ToString(); // } // //dvr.TemplateControl.FindControl // DropDownList dvState2 = (DropDownList)dvr.Cells[1].TemplateControl.FindControl("ddlState"); // if (dvState2 != null) // { // //dtlLabel.Text = "Found DDL"; // dtlLabel.Text += " [" + dvr.ID.ToString() + "]"; // break; // } //} #endregion } //dtlLabel.Text += " finished searching"; } #endregion else { ////dtlLabel.Text = "Other Mode"; } } #endregion DataBound Action for DetailsView4 #region DataBound Action for DetailsView5 else if (dv.ID == "DetailsView5") { } #endregion DataBound Action for DetailsView5 #endregion DataBound Action }