Dream.In.Code > Programming Help > ASP.NET

Welcome to Dream.In.Code
	Become an Expert! Join 150,068 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,801 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a Expert

Help with DataRelation in dataset

Reply to this topic

Start new topic

Help with DataRelation in dataset, how to get my rows out of second table

minus4	10 Jun, 2008 - 08:15 AM Post #1
New D.I.C Head Joined: 6 Jun, 2008 Posts: 3	hi i have a dataset of 2 tables. table 1 holds the product info table 2 holds the sizes available for that product as multiple options. products is my dataset CODE Dim relation As DataRelation = New System.Data.DataRelation("productSizes", products.Tables(0).Columns("productID"), products.Tables(1).Columns("productID")) products.Relations.Add(relation) column productSizes is the column in table 2 i want to loop through: Dim mysizes As String = "sizes: " For Each DataRow In products.Tables(0).Rows(i).GetChildRows("productSizes") mysizes = ?????????????????????? Next what do you put in the question marks ????????????? thanks
	This Post Was Helpful!


Register for Free to Make These Ads Go Away!

Jayman	RE: Help With DataRelation In Dataset 10 Jun, 2008 - 10:07 AM Post #2
Student of Life Joined: 26 Dec, 2005 Posts: 7,319 Thanked: 66 times Dream Kudos: 500 Expert In: Everything My Contributions	Notice how I changed the ForEach loop to return a collection of rows. You said table 2, so you need to change Table property from 0 to 1 to reflect this in the loop and access the second table. CODE For Each dr As DataRow In products.Tables(1).Rows mysizes = dr("productSizes").ToString() Next
	This Post Was Helpful!

minus4	RE: Help With DataRelation In Dataset 11 Jun, 2008 - 12:11 AM Post #3
New D.I.C Head Joined: 6 Jun, 2008 Posts: 3	hi thanks, that would just loop through table 2 and not actuall loop through the datarelation from table 2 i used the same code but put CODE Dim relation As DataRelation = New System.Data.DataRelation("productSizes", products.Tables(0).Columns("productID"), products.Tables(1).Columns("productID")) products.Relations.Add(relation) For i = 0 To products.Tables(0).Rows.Count - 1 Dim mysizes As String = "sizes available: " For Each DataRow In products.Tables(0).Rows(i).GetChildRows("productSizes") mysizes = mysizes & "<br />" & DataRow("sizename").ToString Next Next but many thanks for your response
	This Post Was Helpful!

Fast Reply

Reply to this topic

Start new topic

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Time is now: 1/8/09 10:53PM

Invision Power Board v2.1.7 © 2009 IPS, Inc.

Licensed to: MediaGroup1

Advertising | Terms of Use | Privacy Policy | About Us | Site Map

Forum Index: Programming Help | C and C++ | Visual Basic | Java | VB.NET | C# | ASP.NET | PHP | ColdFusion | Perl and Python | Ruby | Databases | Other Languages | Game Programming | Software Development | Computer Science | Industry News | Programming Tutorials | C++ Tutorials | Visual Basic Tutorials | Java Tutorials | VB.NET Tutorials | C# Tutorials | Linux Tutorials | PHP Tutorials | ColdFusion Tutorials | Windows Tutorials | HTML/JavaScript Tutorials | CSS Tutorials | Flash Tutorials | Web Promotion Tutorials | Photoshop Tutorials | Software Development Tutorials | Database Tutorials | Other Language Tutorials | ASP.NET Tutorials |

Copyright 2001-2008 MediaGroup1 LLC, All Rights Reserved
A MediaGroup1 LLC Production - Version 6.0.2.1.36
Server: secure2

Search^Updated!w00t

Over 509,000 Pages! Advanced Forum Search

Be Social

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Join our IRC Chat

Bye Bye Ads

Monthly Drawing

Top Contributors

Top 10 Kudos This Month