ASP.NET Discussion - how to display information from related t

Print Page | Close Window

how to display information from related t

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=10132
Printed Date: 29 March 2026 at 5:17am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: how to display information from related t

Posted By: nima555ir
Subject: how to display information from related t
Date Posted: 24 April 2004 at 5:34pm

hi
i have two table which has a one to many relationship.
one is Orders table and other Customer table.
Orders (fields) :OrderID(Key),OrderDate,....,CustomerID
Customers (fields) : CustomerID(key),CustomerName,...
and relation is in CustomerID column (CustomersTable Parent and Orders table child) .
i want to display orders in a datagrid and use a tamplate column which display some fields .
i use a label in template column to display Customer name from Customers table which is related to Current record.
plz help me how to do that which the labels have the related Customer name.
plzz help
thanks

Replies:

Posted By: michael
Date Posted: 25 April 2004 at 10:13am

that does not have to do much with a datagrid, more of having a join sql query but I could be wrong as I am really not sure I can make sense out of your question.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker