How does Dataset.Relations work internally?

TheMSsForum.com: The Microsoft Software Forum

Does ADO.NET internally sets up hashtables for the columns that are used
to tie tables, so that later on hashtables can be used to quickly
retrieve data? Or does it just loop through data to locate the
ChildRows. For instance, in a line like this.

ds.Relations.Add(
new DataRelation(RELATION_BREAK_PRODUCT,
tblBreak.Columns[FIELD_BREAK_ID],
ds.Tables["Product"].Columns[FIELD_BREAK_ID]));



Thanks.
Top

Re: How does Dataset.Relations work internally? by Sahil

Sahil
Wed May 25 17:10:34 CDT 2005

Frank,

This is probably a question for the softies, but given the fact that it
takes a while to add a relation, and it is damn quick to fetch childrows, I
suspect that some kind of pre-calculation is going on.

Now it might not be a hashtable - but maybe a combination of a bunch of
techniques.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/



"Frank Rizzo" <none@none.com> wrote in message
news:u3z4ilWYFHA.3836@TK2MSFTNGP10.phx.gbl...
> Does ADO.NET internally sets up hashtables for the columns that are used
> to tie tables, so that later on hashtables can be used to quickly
> retrieve data? Or does it just loop through data to locate the
> ChildRows. For instance, in a line like this.
>
> ds.Relations.Add(
> new DataRelation(RELATION_BREAK_PRODUCT,
> tblBreak.Columns[FIELD_BREAK_ID],
> ds.Tables["Product"].Columns[FIELD_BREAK_ID]));
>
>
>
> Thanks.


Top

Re: How does Dataset.Relations work internally? by Frank

Frank
Wed May 25 17:35:09 CDT 2005

I just looked at the source via Reflector and it seems like like they
are looping through rows on DataRow.GetChildRows().

Softies?

Sahil Malik [MVP] wrote:
> Frank,
>
> This is probably a question for the softies, but given the fact that it
> takes a while to add a relation, and it is damn quick to fetch childrows, I
> suspect that some kind of pre-calculation is going on.
>
> Now it might not be a hashtable - but maybe a combination of a bunch of
> techniques.
>
> - Sahil Malik [MVP]
> http://codebetter.com/blogs/sahil.malik/
>
>
>
> "Frank Rizzo" <none@none.com> wrote in message
> news:u3z4ilWYFHA.3836@TK2MSFTNGP10.phx.gbl...
>
>>Does ADO.NET internally sets up hashtables for the columns that are used
>>to tie tables, so that later on hashtables can be used to quickly
>>retrieve data? Or does it just loop through data to locate the
>>ChildRows. For instance, in a line like this.
>>
>>ds.Relations.Add(
>>new DataRelation(RELATION_BREAK_PRODUCT,
>>tblBreak.Columns[FIELD_BREAK_ID],
>>ds.Tables["Product"].Columns[FIELD_BREAK_ID]));
>>
>>
>>
>>Thanks.
>
>
>
Top

RE: How does Dataset.Relations work internally? by aconrad

aconrad
Wed May 25 19:19:58 CDT 2005

DataRelation support is done via internal indexes for efficient access.

Andrew Conrad
Microsoft Corporation

Top

Re: How does Dataset.Relations work internally? by Sahil

Sahil
Wed May 25 20:52:07 CDT 2005

Sofites == Microsoft employees. :-)

That term is entirely my creation - sorry.

BTW - Andrew answered your question. There is usage of internal indexes. So
there ya go.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/


"Frank Rizzo" <none@none.com> wrote in message
news:uTFxEoXYFHA.228@TK2MSFTNGP12.phx.gbl...
>I just looked at the source via Reflector and it seems like like they are
>looping through rows on DataRow.GetChildRows().
>
> Softies?
>
> Sahil Malik [MVP] wrote:
>> Frank,
>>
>> This is probably a question for the softies, but given the fact that it
>> takes a while to add a relation, and it is damn quick to fetch childrows,
>> I
>> suspect that some kind of pre-calculation is going on.
>>
>> Now it might not be a hashtable - but maybe a combination of a bunch of
>> techniques.
>>
>> - Sahil Malik [MVP]
>> http://codebetter.com/blogs/sahil.malik/
>>
>>
>>
>> "Frank Rizzo" <none@none.com> wrote in message
>> news:u3z4ilWYFHA.3836@TK2MSFTNGP10.phx.gbl...
>>
>>>Does ADO.NET internally sets up hashtables for the columns that are used
>>>to tie tables, so that later on hashtables can be used to quickly
>>>retrieve data? Or does it just loop through data to locate the
>>>ChildRows. For instance, in a line like this.
>>>
>>>ds.Relations.Add(
>>>new DataRelation(RELATION_BREAK_PRODUCT,
>>>tblBreak.Columns[FIELD_BREAK_ID],
>>>ds.Tables["Product"].Columns[FIELD_BREAK_ID]));
>>>
>>>
>>>
>>>Thanks.
>>
>>

Top

Re: How does Dataset.Relations work internally? by Frank

Frank
Thu May 26 17:43:47 CDT 2005

Sahil Malik [MVP] wrote:
> Sofites == Microsoft employees. :-)

I know what it means. I was just calling out to see whether there was
any softies in the crowd here.

>
> That term is entirely my creation - sorry.
>
> BTW - Andrew answered your question. There is usage of internal indexes. So
> there ya go.
>
> - Sahil Malik [MVP]
> http://codebetter.com/blogs/sahil.malik/
>
>
> "Frank Rizzo" <none@none.com> wrote in message
> news:uTFxEoXYFHA.228@TK2MSFTNGP12.phx.gbl...
>
>>I just looked at the source via Reflector and it seems like like they are
>>looping through rows on DataRow.GetChildRows().
>>
>>Softies?
>>
>>Sahil Malik [MVP] wrote:
>>
>>>Frank,
>>>
>>>This is probably a question for the softies, but given the fact that it
>>>takes a while to add a relation, and it is damn quick to fetch childrows,
>>>I
>>>suspect that some kind of pre-calculation is going on.
>>>
>>>Now it might not be a hashtable - but maybe a combination of a bunch of
>>>techniques.
>>>
>>>- Sahil Malik [MVP]
>>>http://codebetter.com/blogs/sahil.malik/
>>>
>>>
>>>
>>>"Frank Rizzo" <none@none.com> wrote in message
>>>news:u3z4ilWYFHA.3836@TK2MSFTNGP10.phx.gbl...
>>>
>>>
>>>>Does ADO.NET internally sets up hashtables for the columns that are used
>>>>to tie tables, so that later on hashtables can be used to quickly
>>>>retrieve data? Or does it just loop through data to locate the
>>>>ChildRows. For instance, in a line like this.
>>>>
>>>>ds.Relations.Add(
>>>>new DataRelation(RELATION_BREAK_PRODUCT,
>>>>tblBreak.Columns[FIELD_BREAK_ID],
>>>>ds.Tables["Product"].Columns[FIELD_BREAK_ID]));
>>>>
>>>>
>>>>
>>>>Thanks.
>>>
>>>
>
Top

Re: How does Dataset.Relations work internally? by Sahil

Sahil
Thu May 26 22:15:14 CDT 2005

You bet there are tonnes of softies who watch these NG's regularly. If there
is an unanswered question, you will see a softie show up sooner or later and
clear it out. BTW - Andrew Conrad (the guy who just answered your question)
is a softie.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/


"Frank Rizzo" <none@none.com> wrote in message
news:%23ledjRkYFHA.3648@TK2MSFTNGP14.phx.gbl...
> Sahil Malik [MVP] wrote:
>> Sofites == Microsoft employees. :-)
>
> I know what it means. I was just calling out to see whether there was any
> softies in the crowd here.
>
>>
>> That term is entirely my creation - sorry.
>>
>> BTW - Andrew answered your question. There is usage of internal indexes.
>> So there ya go.
>>
>> - Sahil Malik [MVP]
>> http://codebetter.com/blogs/sahil.malik/
>>
>>
>> "Frank Rizzo" <none@none.com> wrote in message
>> news:uTFxEoXYFHA.228@TK2MSFTNGP12.phx.gbl...
>>
>>>I just looked at the source via Reflector and it seems like like they are
>>>looping through rows on DataRow.GetChildRows().
>>>
>>>Softies?
>>>
>>>Sahil Malik [MVP] wrote:
>>>
>>>>Frank,
>>>>
>>>>This is probably a question for the softies, but given the fact that it
>>>>takes a while to add a relation, and it is damn quick to fetch
>>>>childrows, I
>>>>suspect that some kind of pre-calculation is going on.
>>>>
>>>>Now it might not be a hashtable - but maybe a combination of a bunch of
>>>>techniques.
>>>>
>>>>- Sahil Malik [MVP]
>>>>http://codebetter.com/blogs/sahil.malik/
>>>>
>>>>
>>>>
>>>>"Frank Rizzo" <none@none.com> wrote in message
>>>>news:u3z4ilWYFHA.3836@TK2MSFTNGP10.phx.gbl...
>>>>
>>>>
>>>>>Does ADO.NET internally sets up hashtables for the columns that are
>>>>>used
>>>>>to tie tables, so that later on hashtables can be used to quickly
>>>>>retrieve data? Or does it just loop through data to locate the
>>>>>ChildRows. For instance, in a line like this.
>>>>>
>>>>>ds.Relations.Add(
>>>>>new DataRelation(RELATION_BREAK_PRODUCT,
>>>>>tblBreak.Columns[FIELD_BREAK_ID],
>>>>>ds.Tables["Product"].Columns[FIELD_BREAK_ID]));
>>>>>
>>>>>
>>>>>
>>>>>Thanks.
>>>>
>>>>
>>


Top

Re: How does Dataset.Relations work internally? by Frank

Frank
Fri May 27 12:38:47 CDT 2005

Btw, are you the guy, Carl Franklin mentions on his show all the time?

Sahil Malik [MVP] wrote:
> You bet there are tonnes of softies who watch these NG's regularly. If there
> is an unanswered question, you will see a softie show up sooner or later and
> clear it out. BTW - Andrew Conrad (the guy who just answered your question)
> is a softie.
>
> - Sahil Malik [MVP]
> http://codebetter.com/blogs/sahil.malik/
>
>
> "Frank Rizzo" <none@none.com> wrote in message
> news:%23ledjRkYFHA.3648@TK2MSFTNGP14.phx.gbl...
>
>>Sahil Malik [MVP] wrote:
>>
>>>Sofites == Microsoft employees. :-)
>>
>>I know what it means. I was just calling out to see whether there was any
>>softies in the crowd here.
>>
>>
>>>That term is entirely my creation - sorry.
>>>
>>>BTW - Andrew answered your question. There is usage of internal indexes.
>>>So there ya go.
>>>
>>>- Sahil Malik [MVP]
>>>http://codebetter.com/blogs/sahil.malik/
>>>
>>>
>>>"Frank Rizzo" <none@none.com> wrote in message
>>>news:uTFxEoXYFHA.228@TK2MSFTNGP12.phx.gbl...
>>>
>>>
>>>>I just looked at the source via Reflector and it seems like like they are
>>>>looping through rows on DataRow.GetChildRows().
>>>>
>>>>Softies?
>>>>
>>>>Sahil Malik [MVP] wrote:
>>>>
>>>>
>>>>>Frank,
>>>>>
>>>>>This is probably a question for the softies, but given the fact that it
>>>>>takes a while to add a relation, and it is damn quick to fetch
>>>>>childrows, I
>>>>>suspect that some kind of pre-calculation is going on.
>>>>>
>>>>>Now it might not be a hashtable - but maybe a combination of a bunch of
>>>>>techniques.
>>>>>
>>>>>- Sahil Malik [MVP]
>>>>>http://codebetter.com/blogs/sahil.malik/
>>>>>
>>>>>
>>>>>
>>>>>"Frank Rizzo" <none@none.com> wrote in message
>>>>>news:u3z4ilWYFHA.3836@TK2MSFTNGP10.phx.gbl...
>>>>>
>>>>>
>>>>>
>>>>>>Does ADO.NET internally sets up hashtables for the columns that are
>>>>>>used
>>>>>>to tie tables, so that later on hashtables can be used to quickly
>>>>>>retrieve data? Or does it just loop through data to locate the
>>>>>>ChildRows. For instance, in a line like this.
>>>>>>
>>>>>>ds.Relations.Add(
>>>>>>new DataRelation(RELATION_BREAK_PRODUCT,
>>>>>>tblBreak.Columns[FIELD_BREAK_ID],
>>>>>>ds.Tables["Product"].Columns[FIELD_BREAK_ID]));
>>>>>>
>>>>>>
>>>>>>
>>>>>>Thanks.
>>>>>
>>>>>
>
>
Top

Re: How does Dataset.Relations work internally? by Sahil

Sahil
Fri May 27 13:08:02 CDT 2005

I think so .. I know Carl .. so I must be him .. when and how did he mention
me? I hope he isn't making fun of me :-). What specific show ru talking
about man?

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/



"Frank Rizzo" <none@none.com> wrote in message
news:eUpLyLuYFHA.612@TK2MSFTNGP12.phx.gbl...
> Btw, are you the guy, Carl Franklin mentions on his show all the time?
>
> Sahil Malik [MVP] wrote:
> > You bet there are tonnes of softies who watch these NG's regularly. If
there
> > is an unanswered question, you will see a softie show up sooner or later
and
> > clear it out. BTW - Andrew Conrad (the guy who just answered your
question)
> > is a softie.
> >
> > - Sahil Malik [MVP]
> > http://codebetter.com/blogs/sahil.malik/
> >
> >
> > "Frank Rizzo" <none@none.com> wrote in message
> > news:%23ledjRkYFHA.3648@TK2MSFTNGP14.phx.gbl...
> >
> >>Sahil Malik [MVP] wrote:
> >>
> >>>Sofites == Microsoft employees. :-)
> >>
> >>I know what it means. I was just calling out to see whether there was
any
> >>softies in the crowd here.
> >>
> >>
> >>>That term is entirely my creation - sorry.
> >>>
> >>>BTW - Andrew answered your question. There is usage of internal
indexes.
> >>>So there ya go.
> >>>
> >>>- Sahil Malik [MVP]
> >>>http://codebetter.com/blogs/sahil.malik/
> >>>
> >>>
> >>>"Frank Rizzo" <none@none.com> wrote in message
> >>>news:uTFxEoXYFHA.228@TK2MSFTNGP12.phx.gbl...
> >>>
> >>>
> >>>>I just looked at the source via Reflector and it seems like like they
are
> >>>>looping through rows on DataRow.GetChildRows().
> >>>>
> >>>>Softies?
> >>>>
> >>>>Sahil Malik [MVP] wrote:
> >>>>
> >>>>
> >>>>>Frank,
> >>>>>
> >>>>>This is probably a question for the softies, but given the fact that
it
> >>>>>takes a while to add a relation, and it is damn quick to fetch
> >>>>>childrows, I
> >>>>>suspect that some kind of pre-calculation is going on.
> >>>>>
> >>>>>Now it might not be a hashtable - but maybe a combination of a bunch
of
> >>>>>techniques.
> >>>>>
> >>>>>- Sahil Malik [MVP]
> >>>>>http://codebetter.com/blogs/sahil.malik/
> >>>>>
> >>>>>
> >>>>>
> >>>>>"Frank Rizzo" <none@none.com> wrote in message
> >>>>>news:u3z4ilWYFHA.3836@TK2MSFTNGP10.phx.gbl...
> >>>>>
> >>>>>
> >>>>>
> >>>>>>Does ADO.NET internally sets up hashtables for the columns that are
> >>>>>>used
> >>>>>>to tie tables, so that later on hashtables can be used to quickly
> >>>>>>retrieve data? Or does it just loop through data to locate the
> >>>>>>ChildRows. For instance, in a line like this.
> >>>>>>
> >>>>>>ds.Relations.Add(
> >>>>>>new DataRelation(RELATION_BREAK_PRODUCT,
> >>>>>>tblBreak.Columns[FIELD_BREAK_ID],
> >>>>>>ds.Tables["Product"].Columns[FIELD_BREAK_ID]));
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>Thanks.
> >>>>>
> >>>>>
> >
> >


Top

Re: How does Dataset.Relations work internally? by Frank

Frank
Fri May 27 13:52:35 CDT 2005

Sahil Malik [MVP] wrote:
> I think so .. I know Carl .. so I must be him .. when and how did he mention
> me? I hope he isn't making fun of me :-). What specific show ru talking
> about man?

DotNetRocks

>
> - Sahil Malik [MVP]
> http://codebetter.com/blogs/sahil.malik/
>
>
>
> "Frank Rizzo" <none@none.com> wrote in message
> news:eUpLyLuYFHA.612@TK2MSFTNGP12.phx.gbl...
>
>>Btw, are you the guy, Carl Franklin mentions on his show all the time?
>>
>>Sahil Malik [MVP] wrote:
>>
>>>You bet there are tonnes of softies who watch these NG's regularly. If
>
> there
>
>>>is an unanswered question, you will see a softie show up sooner or later
>
> and
>
>>>clear it out. BTW - Andrew Conrad (the guy who just answered your
>
> question)
>
>>>is a softie.
>>>
>>>- Sahil Malik [MVP]
>>>http://codebetter.com/blogs/sahil.malik/
>>>
>>>
>>>"Frank Rizzo" <none@none.com> wrote in message
>>>news:%23ledjRkYFHA.3648@TK2MSFTNGP14.phx.gbl...
>>>
>>>
>>>>Sahil Malik [MVP] wrote:
>>>>
>>>>
>>>>>Sofites == Microsoft employees. :-)
>>>>
>>>>I know what it means. I was just calling out to see whether there was
>
> any
>
>>>>softies in the crowd here.
>>>>
>>>>
>>>>
>>>>>That term is entirely my creation - sorry.
>>>>>
>>>>>BTW - Andrew answered your question. There is usage of internal
>
> indexes.
>
>>>>>So there ya go.
>>>>>
>>>>>- Sahil Malik [MVP]
>>>>>http://codebetter.com/blogs/sahil.malik/
>>>>>
>>>>>
>>>>>"Frank Rizzo" <none@none.com> wrote in message
>>>>>news:uTFxEoXYFHA.228@TK2MSFTNGP12.phx.gbl...
>>>>>
>>>>>
>>>>>
>>>>>>I just looked at the source via Reflector and it seems like like they
>
> are
>
>>>>>>looping through rows on DataRow.GetChildRows().
>>>>>>
>>>>>>Softies?
>>>>>>
>>>>>>Sahil Malik [MVP] wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>>Frank,
>>>>>>>
>>>>>>>This is probably a question for the softies, but given the fact that
>
> it
>
>>>>>>>takes a while to add a relation, and it is damn quick to fetch
>>>>>>>childrows, I
>>>>>>>suspect that some kind of pre-calculation is going on.
>>>>>>>
>>>>>>>Now it might not be a hashtable - but maybe a combination of a bunch
>
> of
>
>>>>>>>techniques.
>>>>>>>
>>>>>>>- Sahil Malik [MVP]
>>>>>>>http://codebetter.com/blogs/sahil.malik/
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>"Frank Rizzo" <none@none.com> wrote in message
>>>>>>>news:u3z4ilWYFHA.3836@TK2MSFTNGP10.phx.gbl...
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>Does ADO.NET internally sets up hashtables for the columns that are
>>>>>>>>used
>>>>>>>>to tie tables, so that later on hashtables can be used to quickly
>>>>>>>>retrieve data? Or does it just loop through data to locate the
>>>>>>>>ChildRows. For instance, in a line like this.
>>>>>>>>
>>>>>>>>ds.Relations.Add(
>>>>>>>>new DataRelation(RELATION_BREAK_PRODUCT,
>>>>>>>>tblBreak.Columns[FIELD_BREAK_ID],
>>>>>>>>ds.Tables["Product"].Columns[FIELD_BREAK_ID]));
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>Thanks.
>>>>>>>
>>>>>>>
>>>
>
>
Top

Re: How does Dataset.Relations work internally? by Sahil

Sahil
Fri May 27 20:14:11 CDT 2005

I meant which DotNetRocks show :-)

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/


"Frank Rizzo" <none@none.com> wrote in message
news:u$xVB1uYFHA.3780@tk2msftngp13.phx.gbl...
> Sahil Malik [MVP] wrote:
>> I think so .. I know Carl .. so I must be him .. when and how did he
>> mention
>> me? I hope he isn't making fun of me :-). What specific show ru talking
>> about man?
>
> DotNetRocks
>
>>
>> - Sahil Malik [MVP]
>> http://codebetter.com/blogs/sahil.malik/
>>
>>
>>
>> "Frank Rizzo" <none@none.com> wrote in message
>> news:eUpLyLuYFHA.612@TK2MSFTNGP12.phx.gbl...
>>
>>>Btw, are you the guy, Carl Franklin mentions on his show all the time?
>>>
>>>Sahil Malik [MVP] wrote:
>>>
>>>>You bet there are tonnes of softies who watch these NG's regularly. If
>>
>> there
>>
>>>>is an unanswered question, you will see a softie show up sooner or later
>>
>> and
>>
>>>>clear it out. BTW - Andrew Conrad (the guy who just answered your
>>
>> question)
>>
>>>>is a softie.
>>>>
>>>>- Sahil Malik [MVP]
>>>>http://codebetter.com/blogs/sahil.malik/
>>>>
>>>>
>>>>"Frank Rizzo" <none@none.com> wrote in message
>>>>news:%23ledjRkYFHA.3648@TK2MSFTNGP14.phx.gbl...
>>>>
>>>>
>>>>>Sahil Malik [MVP] wrote:
>>>>>
>>>>>
>>>>>>Sofites == Microsoft employees. :-)
>>>>>
>>>>>I know what it means. I was just calling out to see whether there was
>>
>> any
>>
>>>>>softies in the crowd here.
>>>>>
>>>>>
>>>>>
>>>>>>That term is entirely my creation - sorry.
>>>>>>
>>>>>>BTW - Andrew answered your question. There is usage of internal
>>
>> indexes.
>>
>>>>>>So there ya go.
>>>>>>
>>>>>>- Sahil Malik [MVP]
>>>>>>http://codebetter.com/blogs/sahil.malik/
>>>>>>
>>>>>>
>>>>>>"Frank Rizzo" <none@none.com> wrote in message
>>>>>>news:uTFxEoXYFHA.228@TK2MSFTNGP12.phx.gbl...
>>>>>>
>>>>>>
>>>>>>
>>>>>>>I just looked at the source via Reflector and it seems like like they
>>
>> are
>>
>>>>>>>looping through rows on DataRow.GetChildRows().
>>>>>>>
>>>>>>>Softies?
>>>>>>>
>>>>>>>Sahil Malik [MVP] wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>Frank,
>>>>>>>>
>>>>>>>>This is probably a question for the softies, but given the fact that
>>
>> it
>>
>>>>>>>>takes a while to add a relation, and it is damn quick to fetch
>>>>>>>>childrows, I
>>>>>>>>suspect that some kind of pre-calculation is going on.
>>>>>>>>
>>>>>>>>Now it might not be a hashtable - but maybe a combination of a bunch
>>
>> of
>>
>>>>>>>>techniques.
>>>>>>>>
>>>>>>>>- Sahil Malik [MVP]
>>>>>>>>http://codebetter.com/blogs/sahil.malik/
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>"Frank Rizzo" <none@none.com> wrote in message
>>>>>>>>news:u3z4ilWYFHA.3836@TK2MSFTNGP10.phx.gbl...
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>Does ADO.NET internally sets up hashtables for the columns that are
>>>>>>>>>used
>>>>>>>>>to tie tables, so that later on hashtables can be used to quickly
>>>>>>>>>retrieve data? Or does it just loop through data to locate the
>>>>>>>>>ChildRows. For instance, in a line like this.
>>>>>>>>>
>>>>>>>>>ds.Relations.Add(
>>>>>>>>>new DataRelation(RELATION_BREAK_PRODUCT,
>>>>>>>>>tblBreak.Columns[FIELD_BREAK_ID],
>>>>>>>>>ds.Tables["Product"].Columns[FIELD_BREAK_ID]));
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>Thanks.
>>>>>>>>
>>>>>>>>
>>>>
>>

Top