I am attempting to create my first dataset and I need guidance because I don't know how to pick from the numerous bits of advice I am finding online.
I have a SQL table "Groups"; a dataset "ds" that uses this table (and others); class "Match" that uses the dataset; and code behind that is supposed to Insert, Update, and Delete the Groups data through Match class.
Groups Table:
CREATE TABLE [GROUPS]
(
[GROUP_ID] [int] IDENTITY(1,1) NOT NULL,
[MATCH_ID_FK] [int] NOT NULL,
[TYPE] [varchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IS_FULL] [bit] NULL
)
Here is the Class "Match" and Dataset "ds":
Public Class Match
'VARIABLE TO HOLD PROPERTY
Private tblGroups As DataTable = New DataTable
'PROPERTY
Public Property Groups() As DataTable
...
Go to the complete details ...