Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!Page.IsPostBack)
- {
- customerInformation();
- }
- }
- protected void ddNames_SelectedIndexChanged(object sender, EventArgs e)
- {
- customerInformation();
- }
- private void customerInformation()
- {
- string dbString = ConfigurationManager.ConnectionStrings["TechSupportDBConString"].ConnectionString;
- string query = "SELECT * FROM Customers WHERE Name='" + ddNames.Text + "'";
- SqlConnection Connection = new SqlConnection(dbString);
- Connection.Open();
- SqlCommand Com = new SqlCommand(query, Connection);
- SqlDataReader reader = Com.ExecuteReader();
- if (reader.Read())
- {
- lblName.Text = reader["Name"].ToString() + "'s Personal Information";
- lblAddress.Text = reader["Address"].ToString() + "n" + reader["City"].ToString() + " " + reader["State"].ToString() + " " + reader["ZipCode"].ToString();
- lblPhone.Text = reader["Phone"].ToString();
- lblEmail.Text = reader["Email"].ToString();
- reader.Close();
- Connection.Close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement