Placement of variable in dynamic sql query

[Sebrina]

I have a form that users can enter text, that text is then used in the query. If I place the text = Request.Querystring(text) anywhere other than in the InitaliazeComponent() of the Region(using Studio.NET), the text form the form is never captured. What's the best way to do this?If your useing asp.net textboxes in your form then you can just grab the value in them instead of looking on the query. <BR><BR>So if you have<BR><asp:textbox id="tbx1" runat="server" /><BR><BR>You can do <BR>mySQLStr = "SELECT * FROM tbl1 WHERE id =" &tbx1.text<BR><BR>Hope that helpsthanks, but I have the original form on a standard htm page that clicks to the aspx page.Use<BR><BR>Request.Form("mytextbox")<BR><BR>where "mytextbox" is the name of the form element of the html page.<BR><BR>AaronThanks for all the help. This seems to work from an HTML page. This is my first go with VS.NET and I can't decide whether to use all aspx pages or integrated types as needed.