473,509 Members | 10,100 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Datagrid relationships

How do you make a datagrid show an additional row under each row with
data connected by a relationship to another table (as like when you
create a relationship between tables in Access).

I have two tables
1
tblSurvey
Survey_ID
Q1
Q2
Q3

2
tblSurveyExtra
QuestionID
SurveyID
Answer

I want to be able to view the tblSurveyExtra.Answer for each Survey_ID
from tblSurvey

Aug 18 '06 #1
2 888
Dallas,

In a winform you cannot.
In a webpage I thought it was possible but I don't know how.

Therefore for others who maybe know this, what kind of datagrid

Cor

"dallasfreeman" <da************@sjk.net.auschreef in bericht
news:11**********************@74g2000cwt.googlegro ups.com...
How do you make a datagrid show an additional row under each row with
data connected by a relationship to another table (as like when you
create a relationship between tables in Access).

I have two tables
1
tblSurvey
Survey_ID
Q1
Q2
Q3

2
tblSurveyExtra
QuestionID
SurveyID
Answer

I want to be able to view the tblSurveyExtra.Answer for each Survey_ID
from tblSurvey

Aug 18 '06 #2
Have you considered creating a view in SQL that joins the two tables on
Survey_ID and then using that view as your data source for your
datagrid, or are specifically wanting the data only to appear when the
user clicks on the survey data?

Hope this helps,

dkb

Aug 18 '06 #3

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

Similar topics

4
10210
by: Do | last post by:
Hi, I tried to bind an XML similar to the following to a datagrid. <Idontwant> <Iwant> <Yes></Yes> <Yes></Yes> <Yes></Yes> <Yes></Yes>
1
3041
by: TusharP | last post by:
Hi Friends, My requirement are as follow..... 1) First DataGrid display all row of one table, with this one additional column having +/- control like tree. 2) When user click on +/- control ...
2
2486
by: Josef Meile | last post by:
Hi, I'm using a ComboBox, some Textboxes, and a DataGrid to represent a many-to-many relationship between Person and Course. Each time that I change the value in the ComboBox (which for now is...
3
1300
by: Christopher Jedlicka | last post by:
Hi, I am trying to use a datagrid control to display hierarchical data in a flat format essentially in a master-detail relationship. i.e. <Data> <Customer CustomerName="Customer1"> <Order...
1
917
by: Ozer | last post by:
Hi guys, I have 2 tables. First one is "Cities" and second one is "Reservations". In reservations table I have 2 fields to contain FromCity and ToCity IDs. But I have no idea to bind all of this...
3
2978
by: Maverick | last post by:
Assume i have 2 tables stored in a single dataSet (ds) and the relationship is well added ds.Tables("product") ds.Tables("descriptors") what I want to do is show the data from 2 of the tables,...
2
1059
by: geodev | last post by:
I’m building a small application and I have to build it using asp.net, vb.net and my database is MSDE. I have a datagrid with a list of customers and that is working great. I now need to be able...
3
5861
by: B-Dog | last post by:
I'm trying to comprehend the database features in VB and after tons of reading I'm not sure how do relationships. I want to display a parent column and the respective child columns on one line of...
3
2657
by: fripper | last post by:
I think I am using the proper terminology here ... I am using VB 2003 and have a DataGrid to which I then attach a TableStyle ... then I set the properties of the TableStyle (BackColor,...
5
2939
by: BMeyer | last post by:
I have been losing my mind trying to parse an XML document (with nested child elements, not all of which appear in each parent node) into a DataGrid object. What I want to do is "flatten" the XML...
0
7137
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7347
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7416
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7506
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5656
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5062
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3207
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1571
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
443
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.