I don't know how to do that. I'm brand new to this. Everything I've done in the past was Perl CGI's or ASP 1. Please advise.
--- On Sun, 12/14/08, Brandon Betances <[email protected]> wrote: > From: Brandon Betances <[email protected]> > Subject: [DotNetDevelopment] Re: ASPX bind textbox to stored procedure > To: [email protected] > Date: Sunday, December 14, 2008, 7:02 AM > wire up an event for the submit button that handles the > procedure. > > On Sat, Dec 13, 2008 at 2:47 PM, AC > <[email protected]> wrote: > > > > > Hello, > > > > I'm trying to search my database for matching > patients. I have my > > stored procedure that works great (attached). How can > I bind a > > textbox to these values? How could the results be > returned to a > > control (DetailView, etc.)? Help! > > > > If anyone wants to see my stored procedure, let me > know. Thanks. > > > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 > Transitional//EN" "http:// > > > www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > > <%@ Page Language="C#" %> > > <html dir="ltr" > xmlns="http://www.w3.org/1999/xhtml";> > > > > <head runat="server"> > > <meta http-equiv="Content-Language" > content="en-us" /> > > <meta http-equiv="Content-Type" > content="text/html; charset=utf-8" /> > > <title>Search Patients</title> > > </head> > > > > <body> > > > > <form id="form1" > runat="server"> > > <asp:SqlDataSource runat="server" > id="qry_search_pts" > > ProviderName="System.Data.SqlClient" > > SelectCommandType="StoredProcedure" > ConnectionString="Data > > Source=TEST;Initial Catalog=TEST;Integrated > Security=True" > > SelectCommand="SearchResults"> > > <SelectParameters> > > <asp:controlparameter > > ControlID="frm_Chart_Number" > PropertyName="Text" Name="Chart_Num" > > Type="String" /> > > <asp:controlparameter > ControlID="frm_DOB" > > PropertyName="Text" Name="DOB" > Type="DateTime" /> > > <asp:controlparameter > > ControlID="frm_first_name" > PropertyName="Text" Name="First_Name" > > Type="String" /> > > <asp:controlparameter > > ControlID="frm_last_name" > PropertyName="Text" Name="Last_Name" > > Type="String" /> > > </SelectParameters> > > </asp:SqlDataSource> > > <asp:TextBox runat="server" > id="frm_Chart_Number"></ > > asp:TextBox> > > <br /> > > <asp:TextBox runat="server" > id="frm_DOB"></asp:TextBox> > > <br /> > > <asp:TextBox runat="server" > id="frm_first_name"></asp:TextBox> > > <br /> > > <asp:TextBox runat="server" > id="frm_last_name"></asp:TextBox> > > <br /> > > <asp:Button runat="server" > Text="Submit" id="btn_submit" /> > > </form> > > > > </body> > > > > </html> > > > >
