473,322 Members | 1,614 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,322 software developers and data experts.

Help! How can I set up a relation between 2 tables in memory?

I've got a situation where I have live data coming in from multiple sources.
I'm able to get it into two tables in RAM.

I have one table called "Providers" and it has a ProviderID and some other
fields.

I have another table called "Services"and it has a ProviderID in it as well
as a ServiceID and some other fields.

I just added data to these tables by using DataRow(0) = <first data item>,
DataRow(1) = <second data item>, etc. ThenI added the row to the table by
using Provider.Rows.Add(datarow)

Did something similar for the 2nd table. Now I want to do a nested
repeater, and I've figured out how to do that, but I'm apparently missing
something on setting up the relations.

How do I set up a relationship between these two tables AT RUNTIME?

I haven't introduced a "Dataset" yet at all. Not sure where to do this, and
I'm not sure what to do. Can someone take pity on me and give me the syntax
for doing a relation when both tables are in memory already?

Thanks in advance!
Feb 26 '06 #1
4 1487
Have a look into the DataRelation class. That is exactly what you are after.

Eliyahu

"Scott at Cedar Creek" <Sc***************@discussions.microsoft.com> wrote
in message news:48**********************************@microsof t.com...
I've got a situation where I have live data coming in from multiple
sources.
I'm able to get it into two tables in RAM.

I have one table called "Providers" and it has a ProviderID and some other
fields.

I have another table called "Services"and it has a ProviderID in it as
well
as a ServiceID and some other fields.

I just added data to these tables by using DataRow(0) = <first data item>,
DataRow(1) = <second data item>, etc. ThenI added the row to the table by
using Provider.Rows.Add(datarow)

Did something similar for the 2nd table. Now I want to do a nested
repeater, and I've figured out how to do that, but I'm apparently missing
something on setting up the relations.

How do I set up a relationship between these two tables AT RUNTIME?

I haven't introduced a "Dataset" yet at all. Not sure where to do this,
and
I'm not sure what to do. Can someone take pity on me and give me the
syntax
for doing a relation when both tables are in memory already?

Thanks in advance!

Feb 26 '06 #2
Yes, I've seen that. Apparently I'm not smart enough to make it work. I
keep getting various errors no matter what I try. I'm very frustrated by the
apparent lack of examples for folks who are just starting out (like me). I
can usually figure out what I need if I can see an example. All of the
examples I've seen use some kind of DataSet.Fill method. I don't think I
need to do that... since I've "manually" populated my lists. I don't even
have a DataSet defined at all... just two tables. Do I *need* to define a
dataset?

Really, I'm just trying to get to the point where I have a nested repeater.
If anyone knows a simpler way to do that with two tables in memory, I'm open
for suggestions.

"Eliyahu Goldin" wrote:
Have a look into the DataRelation class. That is exactly what you are after.


Feb 26 '06 #3
Using the Northwind database, drag orders and order details tables onto the
design canvass and create a dataset, then in code.

Dim relation As New Data.DataRelation("MyRelation",
DataSet11.Orders.OrderIDColumn, DataSet11.Order_Details.OrderIDColumn)

DataSet11.Relations.Add(relation)


--
Terry Burns
http://TrainingOn.net
"Scott at Cedar Creek" <Sc***************@discussions.microsoft.com> wrote
in message news:6F**********************************@microsof t.com...
Yes, I've seen that. Apparently I'm not smart enough to make it work. I
keep getting various errors no matter what I try. I'm very frustrated by
the
apparent lack of examples for folks who are just starting out (like me).
I
can usually figure out what I need if I can see an example. All of the
examples I've seen use some kind of DataSet.Fill method. I don't think I
need to do that... since I've "manually" populated my lists. I don't even
have a DataSet defined at all... just two tables. Do I *need* to define a
dataset?

Really, I'm just trying to get to the point where I have a nested
repeater.
If anyone knows a simpler way to do that with two tables in memory, I'm
open
for suggestions.

"Eliyahu Goldin" wrote:
Have a look into the DataRelation class. That is exactly what you are
after.

Feb 26 '06 #4
Dataset is a sort of a cornerstone in Asp.Net. In many cases you will
benefit a lot from using them. Look at them from the perspective of
organizing your data in the way suitable for your task, regardless how you
obtain the data.

Eliyahu

"Scott at Cedar Creek" <Sc***************@discussions.microsoft.com> wrote
in message news:6F**********************************@microsof t.com...
Yes, I've seen that. Apparently I'm not smart enough to make it work. I
keep getting various errors no matter what I try. I'm very frustrated by
the
apparent lack of examples for folks who are just starting out (like me).
I
can usually figure out what I need if I can see an example. All of the
examples I've seen use some kind of DataSet.Fill method. I don't think I
need to do that... since I've "manually" populated my lists. I don't even
have a DataSet defined at all... just two tables. Do I *need* to define a
dataset?

Really, I'm just trying to get to the point where I have a nested
repeater.
If anyone knows a simpler way to do that with two tables in memory, I'm
open
for suggestions.

"Eliyahu Goldin" wrote:
Have a look into the DataRelation class. That is exactly what you are
after.

Feb 26 '06 #5

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

Similar topics

21
by: Dave | last post by:
After following Microsofts admonition to reformat my system before doing a final compilation of my app I got many warnings/errors upon compiling an rtf file created in word. I used the Help...
9
by: Tom | last post by:
A question for gui application programmers. . . I 've got some GUI programs, written in Python/wxPython, and I've got a help button and a help menu item. Also, I've got a compiled file made with...
6
by: wukexin | last post by:
Help me, good men. I find mang books that introduce bit "mang header files",they talk too bit,in fact it is my too fool, I don't learn it, I have do a test program, but I have no correct doing...
3
by: Colin J. Williams | last post by:
Python advertises some basic service: C:\Python24>python Python 2.4.1 (#65, Mar 30 2005, 09:13:57) on win32 Type "help", "copyright", "credits" or "license" for more information. >>> With...
7
by: Corepaul | last post by:
Missing Help Files When I enter "recordset" as the keyword and search the Visual Basic Help index, I get many topics of interest in the resulting list. But there isn't any information available...
5
by: Steve | last post by:
I have written a help file (chm) for a DLL and referenced it using Help.ShowHelp My expectation is that a developer using my DLL would be able to access this help file during his development time...
8
by: Mark | last post by:
I have loaded Visual Studio .net on my home computer and my laptop, but my home computer has an abbreviated help screen not 2% of the help on my laptop. All the settings look the same on both...
10
by: JonathanOrlev | last post by:
Hello everybody, I wrote this comment in another message of mine, but decided to post it again as a standalone message. I think that Microsoft's Office 2003 help system is horrible, probably...
1
by: trunxnirvana007 | last post by:
'UPGRADE_WARNING: Array has a new behavior. Click for more: 'ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?keyword="9B7D5ADD-D8FE-4819-A36C-6DEDAF088CC7"' 'UPGRADE_WARNING: Couldn't resolve...
0
by: hitencontractor | last post by:
I am working on .NET Version 2003 making an SDI application that calls MS Excel 2003. I added a menu item called "MyApp Help" in the end of the menu bar to show Help-> About. The application...
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...
1
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
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...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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.