Setting SqlDataSource SelectParameters from form text box

Question

I am trying to use a text box input as a SqlParameter but it only goes into DataSelecting when the page first loads. Not after the from is submitted.

Here is the code on the aspx page.

protected void DataSelecting(object sender, SqlDataSourceSelectingEventArgs e) { e.Command.Parameters["@zip"].Value = ZipBox.Text; }

"
SelectCommand="SELECT Name FROM Names WHERE (ZipCode = @zip)" OnSelecting="DataSelecting"> SelectParameters> parameter Name="zip" DefaultValue="1" /> SelectParameters> SqlDataSource>

FORM

id="ZipSearch" runat="server" action="Default.aspx" method="post">

TextBox ID="ZipBox" runat="server" />

Button id="btnSubmit" Text="Submit" runat="server" />

FORM

Thanks for your help,

Matt

Answer 1

You need to place that code in the button click event. Selecting event is for different purpose.

Old reply (Before OP's comment) : What do you have in button click event? The Selecting event would fire before your select command is executed. Hence if your button click event is firing any command, the Selecting event won't be fired.