473,320 Members | 2,122 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,320 software developers and data experts.

Creating DataTable relations


Hello,
I am trying to build a relation between 2 datatables & bind the
resultant to the datagrid.

For Example from DataTable 1 architecture

Column1 Column2 Column3
X A 1
X B 2
X C 3
Y D 1
Table 2 Architecture

Column1 Column2 Column3 Column4
A XYZ XYZ XYZ
B XYZ XYZ XYZ
C XYZ XYZ XYZ
D XYZ XYZ XYZ
E XYZ XYZ XYZ
When I pass X into Table 1, I get A, B, C from column 2, & respective
data from column 3. I need to display these on my Datagrid & also build
a relation for Table 1 & Table 2 & get columns 2, columns 3,columns 4
from Table 2 for A, B, C & bind the data to the respective row.

I'm building a relation between the 2 tables in a dataset, & I'm lost
from there, I don't know how to display the relation. Unfortunately I
can't do this on stored proc, have to put this in code behind.

Kindly help
Shaun

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #1
0 953

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

Similar topics

6
by: Jade | last post by:
Hi, I am trying to create a dataset with 6 tables and 5 relationships created between them. I am creating it in the Form_Load event. However i keep getting the following error... An unhandled...
3
by: Edward Mostrom | last post by:
I have 2 tables that have a relation between them. The parent table also has an expression in a column that sums the values in the child table. Both tables are hooked up to datagrids. ...
0
by: Chris Ericoli | last post by:
Hi, I am working with an 'in session' ado dataset with an asp.net application. My dataset is comprised of two tables, one of which maintains a few calculated datacolumns. For some reason these...
1
by: Gene Ariani | last post by:
I have one dataset that contains two DataTables: DataTable1: Customer_ID 1
4
by: Fred Nelson | last post by:
Hi: I have built and loaded a datatable with three columns and defined the first as a primary key as below: ' define datatable dim fvtable as new DataTable dim fvrow as DataRow...
0
by: # Cyrille37 # | last post by:
Hello, I make a little words indexer (search engine like), without a SQL server. So I'm using Datatable to store data. The schema is like: table Words + WORD + IID table WordsIndex
9
by: Anil Gupte | last post by:
After reading a tutorial and fiddling, I finally got this to work. I can now put two tables created with a DataTable class into a DataRelation. Phew! And it works! Dim tblSliceInfo As New...
3
by: Spectre1337 | last post by:
Hello, I've encountered a rather puzzling problem with SqlDataAdapter. I've set up a number of elaborate tables in the Microsoft SQL Server Management Studio Express (including several table key...
2
by: Emre DİNÇER | last post by:
Dear All, is it possible to extract the DataColumn which is a foreign key of another table. The DataTable has only one table. foreach (DataRelation dr in dsIlce.Tables.ParentRelations) { ...
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: 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
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.