Cool, thanks. I'll try that out tomorrow. I'll repost if there's any problems. Thanks, guys.
-AC --- On Sun, 12/14/08, Cerebrus <[email protected]> wrote: > From: Cerebrus <[email protected]> > Subject: [DotNetDevelopment] Re: ASPX bind textbox to stored procedure > To: "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web > Services,.NET Remoting" <[email protected]> > Date: Sunday, December 14, 2008, 12:19 PM > 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 -
