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
}
