What Brandon is trying to tell you is that you need to create an event
handler for the Submit button which will set the DataSourceID of the
DetailsView to your SqlDataSource. Something like this :
---
private void btn_submit_Click(Object sender, EventArgs e)
{
myDetailsView.DataSourceID = "qry_search_pts";
myDetailsView.DataBind();
}
---
Don't forget to wire up your eventhandler to the Event.
On Dec 14, 8:27 pm, Adam Cary <[email protected]> wrote:
> 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>- Hide quoted text -
>
> - Show quoted text -
