CREATE TABLE [dbo].[tbl_client]( [id] [INT] IDENTITY(1,1) NOT NULL, [client_name] [VARCHAR](150) NULL, [client_orgenization] [VARCHAR](150) NULL, [email] [VARCHAR](100) NULL, [telephone] [VARCHAR](100) NULL, CONSTRAINT [PK_tbl_client] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[tbl_project]( [id] [INT] IDENTITY(1,1) NOT NULL, [project_name] [VARCHAR](150) NULL, [start_date] [DATE] NULL, [end_date] [DATE] NULL, [client_id] [INT] NULL, CONSTRAINT [PK_tbl_project] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] THEN GO TO the visual studio AND CREATE NEW windows project called Test
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.
Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.