<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <p> </p> <p><asp:ScriptManager ID="MainScriptManager" runat="server" /> <asp:UpdatePanel ID="pnlHelloWorld" runat="server" UpdateMode="Conditional"> <ContentTemplate> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" DataSourceID="SqlDataSource1"> <Columns> <asp:BoundField DataField="username" HeaderText="username" SortExpression="username" /> <asp:BoundField DataField="comments" HeaderText="comments" SortExpression="comments" /> </Columns> </asp:GridView> <asp:Button ID="Button2" runat="server" onclick="Button2_Click" style="position: relative; top: 0px; left: 0px; width: 379px" Text="Button" /> </ContentTemplate> <Triggers> <asp:AsyncPostBackTrigger ControlID="Button2" EventName="Click" /> </Triggers> </asp:UpdatePanel>
protected void Button2_Click(object sender, EventArgs e) { string username = TextBox1.Text; string comments = TextBox2.Text; SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["ForumDBConnectionString"].ConnectionString);//create our sql command object SqlCommand cmd = new SqlCommand("Insert INTO tests(username,comments) VALUES (@username, @comments)", conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@username", username); cmd.Parameters.AddWithValue("@comments", comments); using (conn) { conn.Open(); cmd.ExecuteNonQuery(); }
using (conn) { conn.Open(); cmd.ExecuteNonQuery(); gridview1.DataBind(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)