StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>You have add a form that call the FormParameter.aspx. This can not work like that, manually.</p> <p>So keep one form only and place there all the controls, and there the post back will work correctly.</p> <pre><code><form id="form1" runat="server"> <label >Title :</label> <input id="txtTitle" type="text" /><br /> <label >Subject:</label> <input id="txtSubject" type="text" /><br /> <label >Category: </label> <input id="txtCategory" type="text" /><br /> <input id="btnAdd" type="submit" value="Add" /> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MessagesConnectionString %>" InsertCommand="INSERT INTO [Messages] ([Title], [Subject], [CategoryID]) VALUES (@Title, @Subject, @CategoryID)" SelectCommand="SELECT * FROM [Messages]" > <InsertParameters> <asp:FormParameter Name="Title" FormField="txtTitle" DefaultValue="No Title" /> <asp:FormParameter Name="Subject" FormField="txtSubject" DefaultValue="No Subject" /> <asp:FormParameter Name="CategoryID" FormField="txtCategory" DefaultValue="No Category" /> </InsertParameters> </asp:SqlDataSource> </form> </code></pre> <p>and on code behind is better to use</p> <pre><code>void Page_Load() { if (IsPostBack) SqlDataSource1.Insert(); } </code></pre> <p>There is a way to make your code work, by disable the validation for this page, but you make then your page vulnerable to attacks.</p> <p>Now I see again your code and I am not so sure that InsertParametres can get the values of non server controls, I think that you also need to change them to ServerControls.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload