protected void CarrierContactTypeDropDownList_SelectedIndexChanged(object sender, EventArgs e) { CarrierContactList.Items.Clear(); ContactTypeID = Int32.Parse(CarrierContactTypeDropDownList.SelectedValue.ToString()); string getcontacts = "SELECT * from CarrierContacts WHERE CarrierID = " + CarrierID + " AND ContactTypeID = " + ContactTypeID; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GHMConnectionString"].ConnectionString)) { SqlCommand cmd = new SqlCommand(getcontacts, conn); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); CarrierContactList.DataSource = rdr; CarrierContactList.DataTextField = "ContactName"; CarrierContactList.DataValueField = "Id"; CarrierContactList.DataBind(); rdr.Close(); conn.Close(); } string AddString = "Add New " + CarrierContactTypeDropDownList.SelectedItem.Text + " Contact..."; CarrierContactList.Items.Insert(0, new ListItem(AddString, "0")); ContactNameTextBox.Text = ""; ContactTitleTextBox.Text = ""; ContactPhoneTextBox.Text = ""; ContactFaxTextBox.Text = ""; ContactEmailTextBox.Text = ""; }
protected void CarrierContactTypeDropDownList_DataBound(object sender, EventArgs e) { ContactTypeID = CarrierContactTypeDropDownList.SelectedIndex; string getcontacts = "SELECT * from CarrierContacts WHERE CarrierID = " + CarrierID + " AND ContactTypeID = " + ContactTypeID; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GHMConnectionString"].ConnectionString)) { SqlCommand cmd = new SqlCommand(getcontacts, conn); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); CarrierContactList.DataSource = rdr; CarrierContactList.DataTextField = "ContactName"; CarrierContactList.DataValueField = "Id"; CarrierContactList.DataBind(); rdr.Close(); conn.Close(); } }
protected void Page_PreRenderComplete(object sender, EventArgs e) { if (!Page.IsPostBack) { string ContactTypeID = CarrierContactTypeDropDownList.SelectedValue.ToString(); string getcontacts = "SELECT * from CarrierContacts WHERE CarrierID = " + CarrierID + " AND ContactTypeID = " + ContactTypeID; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GHMConnectionString"].ConnectionString)) { SqlCommand cmd = new SqlCommand(getcontacts, conn); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); CarrierContactList.DataSource = rdr; CarrierContactList.DataTextField = "ContactName"; CarrierContactList.DataValueField = "Id"; CarrierContactList.DataBind(); rdr.Close(); conn.Close(); } string AddString = "Add New " + CarrierContactTypeDropDownList.SelectedItem.Text + " Contact..."; CarrierContactList.Items.Insert(0, new ListItem(AddString, "0")); } }