Many-To-Many Data

[Arthur.Net]

Sorry, I am a newbie...

I have two table joined by a cross ref table...

CREATE TABLE [dbo].[ParticipationRole](
[ParticipationRoleID] [int] IDENTITY(1,1) NOT NULL,
[ParticipationRoleStr] [nvarchar](50) )

CREATE TABLE [dbo].[DealCategory](
[DealCategoryID] [int] IDENTITY(1,1) NOT NULL,
[DealCategoryStr] [nvarchar](50))

CREATE TABLE [dbo].[xrefRoleDealCat](
[RoleID] [int] NOT NULL,
[DealCategoryID] [int] NOT NULL)

Real Simple... I need to create a grid with the Particpation Roles
down the left side, and the DealCategories across the top. For each
join there will be a checkbox populated by the xref table...

Any ideas?

 

[Mr. Arnold]

Sorry, I am a newbie...

I have two table joined by a cross ref table...

CREATE TABLE [dbo].[ParticipationRole](
[ParticipationRoleID] [int] IDENTITY(1,1) NOT NULL,
[ParticipationRoleStr] [nvarchar](50) )

You need to make a strong typed collection of objects or business objects,
representing the data.

CREATE TABLE [dbo].[DealCategory](
[DealCategoryID] [int] IDENTITY(1,1) NOT NULL,
[DealCategoryStr] [nvarchar](50))

You need to make a strong typed collection of objects or business objects,
representing the data.

CREATE TABLE [dbo].[xrefRoleDealCat](
[RoleID] [int] NOT NULL,
[DealCategoryID] [int] NOT NULL)

You need to make a strong typed collection of objects or business objects,
representing the data.

Real Simple... I need to create a grid with the Particpation Roles
down the left side, and the DealCategories across the top. For each
join there will be a checkbox populated by the xref table...

Any ideas?

You need to understand what a strong type collection of objects is about,
you need to know how to take the strong type collection of objects and
populate a grid with them.

<http://www.google.com/search?hl=en&...&cd=1&q=strong+typed+collections+.Net&spell=1>

If you're using VS 2005, then you can also look at examples using Generic
objects.

http://www.google.com/search?hl=en&q=using+Generic+objects+.Net&btnG=Google+Search


You may needed to know ADO.Net SQL Command Objects instead of using
dataadapter, dataset and datatable.

http://www.google.com/search?hl=en&q=ADO.Net+SQL+Command+Objects+&btnG=Google+Search


Some other things you may want to look at.

MODEL-VIEW-PRESENTER

http://www.polymorphicpodcast.com/

click 'Shows'

click 'Design Patterns Bootcamp: Model View * Patterns*

view parts 1-5

You can use Google to get more information about this or find books.

You should also understand an object's Public accessor properties of Get/Set
in C# or Let/Get in VB.Net.