<table> <tr> <td><asp:Label ID="Labelcontact1" runat="server" Text="Contact 1" CssClass="label"></asp:Label></td> <td><asp:TextBox ID="TextBoxContact1" runat="server" CssClass="textbox" ValidationGroup="updatebasics"></asp:TextBox></td> </tr> <tr> <td><asp:Label ID="Labelcontact2" runat="server" Text="Contact 2" CssClass="label"></asp:Label></td> <td><asp:TextBox ID="TextBoxContact2" runat="server" CssClass="textbox" ValidationGroup="updatebasics"></asp:TextBox></td> </tr> <tr> <td><asp:Label ID="Labelemail1" runat="server" Text="Email 1" CssClass="label"></asp:Label></td> <td><asp:TextBox ID="TextBoxEmail1" runat="server" CssClass="textbox" ValidationGroup="updatebasics"></asp:TextBox></td> </tr> <tr> <td><asp:Label ID="Labelemail2" runat="server" Text="Email 2" CssClass="label"></asp:Label></td> <td><asp:TextBox ID="TextBoxEmail2" runat="server" CssClass="textbox" ValidationGroup="updatebasics"></asp:TextBox></td> </tr> <tr> <td><asp:Button ID="ButtonSubmit" runat="server" Text="Update" CssClass="button" OnClick="ButtonSubmit_Click" ValidationGroup="updatebasics"/></td> </tr> </table>
public partial class Default2 : System.Web.UI.Page { static string connstr = ConfigurationManager.ConnectionStrings["ethena"].ConnectionString; private static SqlConnection con = new SqlConnection(connstr); private static SqlCommand cmd; protected void Page_Load(object sender, EventArgs e) { cmd = new SqlCommand("select * from page_content", con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { TextBoxContact1.Text=reader["contact1"].ToString(); TextBoxContact2.Text = reader["contact2"].ToString(); TextBoxEmail1.Text = reader["email1"].ToString(); TextBoxEmail2.Text = reader["email2"].ToString(); } con.Close(); } protected void ButtonSubmit_Click(object sender, EventArgs e) { string query="UPDATE page_content SET contact1='"+TextBoxContact1.Text.Trim()+"',contact2='"+TextBoxContact2.Text.Trim()+"',email1='"+TextBoxEmail1.Text.Trim()+"',email2='"+TextBoxEmail2.Text.Trim()+"'"; //Labelcontact1.Text = query; cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteReader(); con.Close(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)