PC Review


Reply
Thread Tools Rate Thread

databinding to a text box

 
 
JJ297
Guest
Posts: n/a
 
      22nd Jan 2008
How do I bring text back from the database to populate two text boxes.

I have a details view on the page plus two text boxes I want shipdate
text box and due date text box to poplutaed with info from the
database.

Do I bring back all of the info in one stored procedure (even the text
box info), such as...

CREATE procedure GetRequestInfo
@Requestorid int


AS
select distinct requestors.Requestorid, titles.title,
requestors.requestorEmail,Requestors.requestdate, fname, lname,
phonenum,
StreetAddress1, City, State, Zip,
libraryrequest.shipdate,libraryrequest.duedate


Cast(DATEPART(m, requestors.requestDate) as Varchar(5)) + '/' +
Cast(DATEPART(d, requestors.requestDate) as Varchar(5)) + '/' +
Cast(DATEPART(yy, requestors.RequestDate) as Varchar(5))


from Requestors
join Titles on titles.Titleid = requestors.Titleid
join libraryRequest on LibraryRequest.requestorid =
Requestors.requestorid
where Requestors.requestorid = @requestorid


Do I need to put something in the page load to populate the text boxes?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom databinding of a text box Keith G Hicks Microsoft ASP .NET 3 10th Feb 2008 12:52 AM
2 way Databinding and a Text Box Wayne Sepega Microsoft ASP .NET 0 20th Mar 2006 12:37 PM
Usercontrol databinding on property Text Tim Wilson Microsoft C# .NET 1 23rd Feb 2006 08:57 PM
help !!!! databinding with text box Marc R. Microsoft VB .NET 3 15th Jan 2006 03:29 PM
Combo box , text box and databinding Fernb2000 Microsoft Dot NET 0 19th Feb 2005 05:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:08 PM.