基于.net的C＃＋SQL学生选课系统

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_sco_csee]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[sco] DROP CONSTRAINT FK_sco_csee GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_sco_stu]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[sco] DROP CONSTRAINT FK_sco_stu GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_csee_tea]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[csee] DROP CONSTRAINT FK_csee_tea GO /****** Object: Table [dbo].[csee] Script Date: 2002-5-26 22:23:17 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[csee]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[csee] GO /****** Object: Table [dbo].[dept] Script Date: 2002-5-26 22:23:17 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dept]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dept] GO /****** Object: Table [dbo].[sco] Script Date: 2002-5-26 22:23:17 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sco]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[sco] GO /****** Object: Table [dbo].[stu] Script Date: 2002-5-26 22:23:17 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[stu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[stu] GO /****** Object: Table [dbo].[tea] Script Date: 2002-5-26 22:23:17 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tea]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tea] GO /****** Object: Table [dbo].[csee] Script Date: 2002-5-26 22:23:18 ******/ CREATE TABLE [dbo].[csee] ( [tno] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [cno] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [cname] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [ckind] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [ccredit] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL , [ccount] [int] NOT NULL , [cmon] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [cadr] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [ctur] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [cwen] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [csat] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [cfri] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [cpeo] [int] NOT NULL , [cdept] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[dept] Script Date: 2002-5-26 22:23:19 ******/ CREATE TABLE [dbo].[dept] ( [deptno] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [deptname] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[sco] Script Date: 2002-5-26 22:23:20 ******/ CREATE TABLE [dbo].[sco] ( [cno] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [sno] [char] (9) COLLATE Chinese_PRC_CI_AS NOT NULL , [score] [decimal](18, 0) NOT NULL , [ckind] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [id] [int] IDENTITY (0, 1) NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[stu] Script Date: 2002-5-26 22:23:20 ******/ CREATE TABLE [dbo].[stu] ( [sno] [char] (9) COLLATE Chinese_PRC_CI_AS NOT NULL , [sname] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [sdept] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [ssex] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , [sdate] [datetime] NULL , [spas] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[tea] Script Date: 2002-5-26 22:23:21 ******/ CREATE TABLE [dbo].[tea] ( [tno] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [tname] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [tdept] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [tpost] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL , [tpas�