private void AddContact(string name, string email, string phone, string msg) { if (connection == null || connection.State == ConnectionState.Closed) { connection = WebText.TextDatabase(); } // Ensure the database connection exists before querying it if (connection != null && connection.State == ConnectionState.Open) { SqlCommand cmd = connection.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT INTO Contact VALUES (@name, @email, @phone, @msg)"; cmd.Parameters.AddWithValue("name", name.Trim(charsToTrim)); cmd.Parameters.AddWithValue("email", email.Trim(charsToTrim)); cmd.Parameters.AddWithValue("phone", phone.Trim(charsToTrim)); cmd.Parameters.AddWithValue("msg", msg.Trim(charsToTrim)); try { int values = cmd.ExecuteNonQuery(); btnClearContact_Click(btnClearContact, new EventArgs()); } catch (Exception ex) { txtEntryMsg.Text = "ERROR: " + ex.Message + "\n" + txtEntryMsg.Text; } connection.Close(); } }
protected void Page_Load(object sender, EventArgs e) { switch (slideShowImageIndex) { case 0: // Monkey imgHomeImage.ImageUrl = "~/Images/elephants.jpg"; slide1.BackColor = System.Drawing.Color.OrangeRed; break; case 1: imgHomeImage.ImageUrl = "~/Images/wierdDeers.jpg"; slide2.BackColor = System.Drawing.Color.OrangeRed; break; case 2: imgHomeImage.ImageUrl = "~/Images/Monkey.jpg"; slide3.BackColor = System.Drawing.Color.OrangeRed; break; default: break; } // Card labels Label[] cardLabels = new Label[] { cardHeader0, cardHeader1, cardHeader2, cardTitle0, cardTitle1, cardTitle2, cardDesc0, cardDesc1, cardDesc2 }; for (int i = 0; i < 3; i++) { WebText cardText = WebText.RetrieveText(i + 1); cardLabels[i].Text = cardText.Header; cardLabels[i + 3].Text = cardText.Title; cardLabels[i + 6].Text = cardText.Desc; } // Main Title WebText homeText = WebText.RetrieveText(4); labelHomeImage.Text = homeText.Header; labelHomeImage2.Text = homeText.Title; titleDesc.Text = homeText.Desc; }
protected void Page_Load(object sender, EventArgs e) { txtEntryName.Attributes.Add("placeholder", "Name"); txtEntryEmail.Attributes.Add("placeholder", "Email"); txtEntryPhone.Attributes.Add("placeholder", "Phone"); connection = WebText.TextDatabase(); // Title line titleDesc.Text = WebText.RetrieveText(4).Desc; // Address, phone, fax WebText contact = WebText.RetrieveText(5); lblAddress.Text = contact.Header; lblPhone.Text = contact.Title; lblFax.Text = contact.Desc; // Email WebText email = WebText.RetrieveText(6); lblEmail.Text = email.Header; }
protected void Page_Unload(object sender, EventArgs e) { WebText.DisposeTextDatabase(); }