I have a requirement to create a DataTable that relates to information on a
particular web screen. This wouldn't be too difficult except that one of the
fields is a multi-select listbox.

What is the best way to do this with a Datatable?

Thanks.

STom

"STom" <(E-Mail Removed)> wrote
> I have a requirement to create a DataTable that relates to information on a
> particular web screen. This wouldn't be too difficult except that one of the
> fields is a multi-select listbox.
>
> What is the best way to do this with a Datatable?

Tom,
Sounds like a many-to-many relationship. How about using a intersection table?
e.g.
Entity1 table
Intersection table - contains the primary keys from both entity tables
Entity2 table

Then just fill in the multi-select listbox value(s) from Entity2 table using the
Intersection table.

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com

Carl,

Yes, it is a many-to-many relationship.

What I am trying to find out though is how, programmatically, while I'm
building my table of values in ado.net, do I include this relationship and
its records.

STom
"Carl Prothman [MVP]" <(E-Mail Removed)> wrote in message
news:OT0%(E-Mail Removed)...
> "STom" <(E-Mail Removed)> wrote
> > I have a requirement to create a DataTable that relates to information
on a
> > particular web screen. This wouldn't be too difficult except that one of
the
> > fields is a multi-select listbox.
> >
> > What is the best way to do this with a Datatable?
>
> Tom,
> Sounds like a many-to-many relationship. How about using a intersection
table?
> e.g.
> Entity1 table
> Intersection table - contains the primary keys from both entity
tables
> Entity2 table
>
> Then just fill in the multi-select listbox value(s) from Entity2 table
using the
> Intersection table.
>
> --
>
> Thanks,
> Carl Prothman
> Microsoft ASP.NET MVP
> http://www.able-consulting.com
>
>
>
>

"STom" <(E-Mail Removed)> wrote
> Yes, it is a many-to-many relationship.
> What I am trying to find out though is how, programmatically, while I'm
> building my table of values in ado.net, do I include this relationship and
> its records.
>

You can either find the corresponding record(s) manually by using the
DataTable.Rows Find method.
http://msdn.microsoft.com/library/en...sfindtopic.asp

Or you can create a DataRelation between the DataTables at runtime,
http://msdn.microsoft.com/library/de...classtopic.asp
then transverse the relationships using the DataRow GetChildRows methods
to get the corresponding record(s).
http://msdn.microsoft.com/library/en...drowstopic.asp

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com

Thanks Carl!

STom
"Carl Prothman [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "STom" <(E-Mail Removed)> wrote
> > Yes, it is a many-to-many relationship.
> > What I am trying to find out though is how, programmatically, while I'm
> > building my table of values in ado.net, do I include this relationship
and
> > its records.
> >
>
> You can either find the corresponding record(s) manually by using the
> DataTable.Rows Find method.
>
http://msdn.microsoft.com/library/en...sfindtopic.asp
>
> Or you can create a DataRelation between the DataTables at runtime,
>
http://msdn.microsoft.com/library/de...classtopic.asp
> then transverse the relationships using the DataRow GetChildRows methods
> to get the corresponding record(s).
>
http://msdn.microsoft.com/library/en...drowstopic.asp
>
> --
>
> Thanks,
> Carl Prothman
> Microsoft ASP.NET MVP
> http://www.able-consulting.com
>
>
>
>