nwind

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