TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
nwind
NA
1
0
Translating Sequel Query to C#
Jul 9 2004 3:50 PM
Hi All, I am working on a pedigree page where one can input the name of an animal and have the pedigree display. I have an MS SQL table with an animal's name(Col. A), registration number (Col. B), sire's registration number (Col. C) and dam's registration number (Col. D). I want to input the animal's name or number and show it's parent's names, rather than the numbers. (The parent's are, of course, also listed as animal's by name and number in Col. A). I made a dataset that returns the horse name (first column of the table) and the parents ID numbers (separate cells in the second column of the table). I have a query that will turn the parents ID numbers into the names. I cannot figure out how to get the second cell to take the ID Number from the first query and use that number to return the name. Since the query works I am guessing that the problem is in telling the dynamic text what I want. All I know how to do with it is: <%# dsPedigree.FieldValue("regRegNumber", Container) %> How can I make it take a second dataset and perform that switching operation with it in the same table cell to return the value I want? Or do I somehow need to incorporate the second query into the first dataset? Thanks for any help you may offer! Pat H
Reply
Answers (
0
)
COM Object
EventInfo and Reflection