473,508 Members | 2,343 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

show relationship between tables in Asp.net using c#

35 New Member
hello,

Can I show relationship between tables in the datagrid control.

I have written a below code for establish relation b/w tables.

dset.Relations.Add("Customer requests",
dset.Tables["Customers"].Columns["icustid"],
dset.Tables["requests"].Columns["icustid"]);
Jan 5 '07 #1
3 2933
radcaesar
759 Recognized Expert Contributor
hello,

Can I show relationship between tables in the datagrid control.

I have written a below code for establish relation b/w tables.

dset.Relations.Add("Customer requests",
dset.Tables["Customers"].Columns["icustid"],
dset.Tables["requests"].Columns["icustid"]);


When u bind this dset to grid, it will shows u as a drill down records in the datagrid.

I Was unable to decide whether it will work with this single line of code. Please post with the detailed code snippet and ur problem in brief.

:)
Jan 5 '07 #2
Rathorevivek
17 New Member
Hi Muskan,

Would u please tell in detail that what is ur requirement?
It is not getting clear that wat are ur intentions means wat do u actually want to do?

Thanks and Regards,
VIVEK RATHORE.
Jan 8 '07 #3
muskan
35 New Member
thanks for reply..

actually I have showed the relationship b/w the 2 tables
I want to know that it is possible to show the result of the relationship into the datagrid control.


Hi Muskan,

Would u please tell in detail that what is ur requirement?
It is not getting clear that wat are ur intentions means wat do u actually want to do?

Thanks and Regards,
VIVEK RATHORE.
Jan 8 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

44
3830
by: Mariusz Jedrzejewski | last post by:
Hi, I'll be very grateful if somebody can explain me why my Opera 7.23 (runing under linux) doesn't show me inner tables. Using below code I can see only "inner table 1". There is no problem with...
2
2039
by: Marco Simone | last post by:
Hi, I have 4 tables, tblCompany, tblA, tblB and tblC. tblA, tblB and tblC contain same type of data, they should be in one table, but since there are many fields, I split it into 3 tables. Each...
7
1604
by: Luis Esteban Valencia | last post by:
I have this i need to show the datagrid with columns of 2 datatables Dim myadap As New SqlDataAdapter myconn.Open() myadap.TableMappings().Add("Table", "vistaUsuarios")
3
1461
by: shawnews | last post by:
Ok...I'll first describe briefly what I've done. Working from a paper form with over 200 fields - broken into 10 areas, I created a database with 10 tables. I then created a form using those 10...
2
2597
by: cspowart | last post by:
Consider first, table "A" : Plate Make Model ===================== ABC123 Ford F150 XYZ789 Dodge 1500 IJK444 Chev Silverado Then consider, table "B";
1
1367
by: adham | last post by:
Hey there, Im not even sure if im using the terminology correctly. Anyway heres my questions. I have a three tables. The main table has two ID fields. A website id, which is the primary key in...
10
4425
by: Richard | last post by:
Hi folks, thanks for taking the time to read this (and hopefully point our where I'm going wrong). The scenario: I have a local Access2007 database which links in several read only mySql...
11
10603
by: RobertJohn | last post by:
Hi all I am using Access 2007 to start a small home library application, and so far it has two tables. 1. Books, with fields Book_ID (Primary Key) and Title, and 2. Authors, with fields...
6
4047
by: NicoleCartrette | last post by:
Going back to school is easier said than done.. This was posted to an older thread earlier but I don't think it got any attention. Your help is appreciated Professor requires we create a...
0
7225
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7123
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
7324
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
7382
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
7495
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...
1
5052
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
3181
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
766
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
418
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.