protected void ButtonContact_Click(object sender, EventArgs e) { ContactUti con = new ContactUti(); con.Name = TextBoxName.Text; con.Content = TextBoxContact.Text; con.insertLog(); LabelMessage.Text = "Message sent!"; ButtonContact.Visible = false; LabelMessage.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { List <ContactUti> list_contact = new ContactUti().getContactInfo(); foreach (ContactUti con in list_contact) { ContactList.InnerHtml += "<div class=\"col-xs-2 table-bordered\"><p>" + con.id + "</p></div>"; ContactList.InnerHtml += "<div class=\"col-xs-2 table-bordered\"><p>" + con.Name + "</p></div>"; ContactList.InnerHtml += "<div class=\"col-xs-6 table-bordered\"><p>" + con.Content + "</p></div>"; ContactList.InnerHtml += "<div class=\"col-xs-2 table-bordered\"><p>" + con.Time + "</p></div>"; } }
public List <ContactUti> getContactInfo() { List <ContactUti> list_contact = new List <ContactUti>(); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["PizzaDBRemote"].ConnectionString); conn.Open(); string qry = "select * from ContactLog order by Time"; SqlCommand comd = new SqlCommand(qry, conn); SqlDataReader dr = comd.ExecuteReader(); while (dr.Read()) { ContactUti contact = new ContactUti(); contact.id = dr[0].ToString(); contact.Name = dr[1].ToString(); contact.Content = dr[2].ToString(); contact.Time = dr[3].ToString(); list_contact.Add(contact); } return(list_contact); }