Hi Fellows,

Just a simple question,

I have a table with one row. This row itself has got multiple Child Rows.
Once I retrieve this array of rows using GetChildRows, how do I add a row
into it ?

Thanks for any help or advice.

--
William T
Chief Software Developer
Software Architect
Softwaremaker.Net Pte Ltd

+++++++++++++++++++++++++++++

Not sure what you mean. Do you mean add a row to the Array? Do you have a code sample that shows what you are doing?

Want to know more? Check out the MSDN Library at http://msdn.microsoft.com or the Microsoft Knowledge Base at http://support.microsoft.com

Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : (E-Mail Removed) <Remove word online. from address>

This posting is provided “AS IS”, with no warranties, and confers no rights.




--------------------
>From: "Softwaremaker" <(E-Mail Removed)>
>Subject: How to add Rows to GetChildRows ?
>Date: Mon, 21 Jul 2003 07:11:18 +0800
>Lines: 19
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
>Message-ID: <(E-Mail Removed)>
>Newsgroups: microsoft.public.dotnet.framework.adonet
>NNTP-Posting-Host: bb220-255-83-238.singnet.com.sg 220.255.83.238
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:56258
>X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
>
>Hi Fellows,
>
>Just a simple question,
>
>I have a table with one row. This row itself has got multiple Child Rows.
>Once I retrieve this array of rows using GetChildRows, how do I add a row
>into it ?
>
>Thanks for any help or advice.
>
>--
>William T
>Chief Software Developer
>Software Architect
>Softwaremaker.Net Pte Ltd
>
>+++++++++++++++++++++++++++++
>
>
>

Hi Scott,

Yes...adding a row to an array of Rows. But after that,
how do we assign this array back into the GetChildRows
again.

See below for Source :
'====================
For Each myRelation In ds.Tables(0).ChildRelations
For Each myRow In ds.Tables(0).Rows
arrRows = myRow.GetChildRows(myRelation)
MessageBox.Show(arrRows.GetLength(0))
ReDim Preserve arrRows(arrRows.GetLength(0))
'How to add a Row into arrRows ???
'How to assign arrRows back into ChildRows ???
Next myRow
Next myRelation
'====================

>-----Original Message-----
>Not sure what you mean. Do you mean add a row to the
Array? Do you have a code sample that shows what you are
doing?
>
>Want to know more? Check out the MSDN Library at
http://msdn.microsoft.com or the Microsoft Knowledge Base
at http://support.microsoft.com
>
>Scot Rose, MCSD
>Microsoft Visual Basic Developer Support
>Email : (E-Mail Removed) <Remove word online.
from address>
>
>This posting is provided "AS IS", with no warranties, and
confers no rights.
>
>
>
>
>--------------------
>>From: "Softwaremaker" <(E-Mail Removed)>
>>Subject: How to add Rows to GetChildRows ?
>>Date: Mon, 21 Jul 2003 07:11:18 +0800
>>Lines: 19
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
>>Message-ID: <(E-Mail Removed)>
>>Newsgroups: microsoft.public.dotnet.framework.adonet
>>NNTP-Posting-Host: bb220-255-83-238.singnet.com.sg
220.255.83.238
>>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!
TK2MSFTNGP11.phx.gbl
>>Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.adonet:56258
>>X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
>>
>>Hi Fellows,
>>
>>Just a simple question,
>>
>>I have a table with one row. This row itself has got
multiple Child Rows.
>>Once I retrieve this array of rows using GetChildRows,
how do I add a row
>>into it ?
>>
>>Thanks for any help or advice.
>>
>>--
>>William T
>>Chief Software Developer
>>Software Architect
>>Softwaremaker.Net Pte Ltd
>>
>>+++++++++++++++++++++++++++++
>>
>>
>>
>
>
>.
>

You wan tto put the contents of the array back into the Dataset?

Want to know more? Check out the MSDN Library at http://msdn.microsoft.com or the Microsoft Knowledge Base at http://support.microsoft.com

Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : (E-Mail Removed) <Remove word online. from address>

This posting is provided “AS IS”, with no warranties, and confers no rights.




--------------------
>Content-Class: urn:content-classes:message
>From: "Softwaremaker" <(E-Mail Removed)>
>Sender: "Softwaremaker" <(E-Mail Removed)>
>References: <(E-Mail Removed)> <(E-Mail Removed)>
>Subject: RE: How to add Rows to GetChildRows ?
>Date: Mon, 21 Jul 2003 19:26:53 -0700
>Lines: 84
>Message-ID: <051d01c34ff8$b693d050$(E-Mail Removed)>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Thread-Index: AcNP+LaTjsI+uf+sQ86zQeLoiolNlQ==
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Newsgroups: microsoft.public.dotnet.framework.adonet
>Path: cpmsftngxa06.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:56386
>NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
>X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
>
>Hi Scott,
>
>Yes...adding a row to an array of Rows. But after that,
>how do we assign this array back into the GetChildRows
>again.
>
>See below for Source :
>'====================
>For Each myRelation In ds.Tables(0).ChildRelations
> For Each myRow In ds.Tables(0).Rows
> arrRows = myRow.GetChildRows(myRelation)
> MessageBox.Show(arrRows.GetLength(0))
> ReDim Preserve arrRows(arrRows.GetLength(0))
> 'How to add a Row into arrRows ???
> 'How to assign arrRows back into ChildRows ???
> Next myRow
> Next myRelation
>'====================
>
>>-----Original Message-----
>>Not sure what you mean. Do you mean add a row to the
>Array? Do you have a code sample that shows what you are
>doing?
>>
>>Want to know more? Check out the MSDN Library at
>http://msdn.microsoft.com or the Microsoft Knowledge Base
>at http://support.microsoft.com
>>
>>Scot Rose, MCSD
>>Microsoft Visual Basic Developer Support
>>Email : (E-Mail Removed) <Remove word online.
>from address>
>>
>>This posting is provided "AS IS", with no warranties, and
>confers no rights.
>>
>>
>>
>>
>>--------------------
>>>From: "Softwaremaker" <(E-Mail Removed)>
>>>Subject: How to add Rows to GetChildRows ?
>>>Date: Mon, 21 Jul 2003 07:11:18 +0800
>>>Lines: 19
>>>X-Priority: 3
>>>X-MSMail-Priority: Normal
>>>X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
>>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
>>>Message-ID: <(E-Mail Removed)>
>>>Newsgroups: microsoft.public.dotnet.framework.adonet
>>>NNTP-Posting-Host: bb220-255-83-238.singnet.com.sg
>220.255.83.238
>>>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!
>TK2MSFTNGP11.phx.gbl
>>>Xref: cpmsftngxa06.phx.gbl
>microsoft.public.dotnet.framework.adonet:56258
>>>X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
>>>
>>>Hi Fellows,
>>>
>>>Just a simple question,
>>>
>>>I have a table with one row. This row itself has got
>multiple Child Rows.
>>>Once I retrieve this array of rows using GetChildRows,
>how do I add a row
>>>into it ?
>>>
>>>Thanks for any help or advice.
>>>
>>>--
>>>William T
>>>Chief Software Developer
>>>Software Architect
>>>Softwaremaker.Net Pte Ltd
>>>
>>>+++++++++++++++++++++++++++++
>>>
>>>
>>>
>>
>>
>>.
>>
>