473,246 Members | 1,314 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,246 software developers and data experts.

Use a single DataGrid to show Master/Detail records?

I want to show a table of master records, with the right most column
displayed as a comma (or space) delimited list of details. The practical
application of this is a thesaurus, where the master records show a term and
the details show n number of synonyms for the master term. I have two
tables, one for terms the other for synonyms (keyed back to the primary key
of the terms). I have defined a DataRelation and used
objTable.ChildRelations to successfully write this stuff out into an
ASP:Table, however I'd like to use a DataGrid instead if it's at all
possible. Any ideas on how to bind that last column to my detail records?

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

Nov 17 '05 #1
0 1466

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: vinay | last post by:
I have created a Master-Detail DataGrid The detail grid is embedded inside the Mastergrid with each row. Adding the detail grid in ItemDatabound event. I am exporting the Grid to a Excel....
2
by: Mardy | last post by:
I have a datagrid that allows users to eidt/update detail records. The grid shows detail records for a master record. Once the status of the master record changes to "closed", I need to ensure...
1
by: Larry Woods | last post by:
I have a combobox that is populated with a list of names. When a name is selected I want to populate a datagrid with name information. I have my master-detail defined in my dataset and it works...
4
by: Melson | last post by:
Hi I've a problem. Can anyone help. I would like to use datagrid for data entry. How can I set the number of rows in the datagrid. And use the datagrid to update the ms sql table. regards...
2
by: blue_nirvana | last post by:
Is there an event that fires when a user clicks the plus sign in a Master/Detail datagrid? It would be even better if I could catch when the user clicks the link to see the detail records. What...
2
by: Enrique Santa Cruz | last post by:
Hi I've been trying to read the greek-like dictionary help on the datagrid control with little success in some things and I hope you can help me: I have a datagrid populated with a data set with...
3
by: no | last post by:
Hi all, I have a dataset that contain 2 tables and a relationship between them (master detail). I bind this dataset to a form that include some textboxes that bind to the parent record, and a...
7
by: john | last post by:
In my form I have a master table and a details table linked 1xM. I can search through the whole parent table but I also like to be able to search through the child table fields to find parent...
1
by: Shalini Bhalla | last post by:
i have 2 tables one is master and another is detail having Ins-no common and iwant that when master recordset is moved then detail recordset pointershould filter detail records correspondint to...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.