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>
