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> > >
