晚会人员管理系统asp.net sql sever c#

USE [master] GO /****** 对象: Database [chekuguanli] 脚本日期: 05/02/2011 19:28:13 ******/ CREATE DATABASE [chekuguanli] ON PRIMARY ( NAME = N'chekuguanli', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\chekuguanli.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'chekuguanli_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\chekuguanli_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO EXEC dbo.sp_dbcmptlevel @dbname=N'chekuguanli', @new_cmptlevel=90 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [chekuguanli].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [chekuguanli] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [chekuguanli] SET ANSI_NULLS OFF GO ALTER DATABASE [chekuguanli] SET ANSI_PADDING OFF GO ALTER DATABASE [chekuguanli] SET ANSI_WARNINGS OFF GO ALTER DATABASE [chekuguanli] SET ARITHABORT OFF GO ALTER DATABASE [chekuguanli] SET AUTO_CLOSE ON GO ALTER DATABASE [chekuguanli] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [chekuguanli] SET AUTO_SHRINK OFF GO ALTER DATABASE [chekuguanli] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [chekuguanli] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [chekuguanli] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [chekuguanli] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [chekuguanli] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [chekuguanli] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [chekuguanli] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [chekuguanli] SET ENABLE_BROKER GO ALTER DATABASE [chekuguanli] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [chekuguanli] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [chekuguanli] SET TRUSTWORTHY OFF GO ALTER DATABASE [chekuguanli] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [chekuguanli] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [chekuguanli] SET READ_WRITE GO ALTER DATABASE [chekuguanli] SET RECOVERY SIMPLE GO ALTER DATABASE [chekuguanli] SET MULTI_USER GO ALTER DATABASE [chekuguanli] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [chekuguanli] SET DB_CHAINING OFF USE [chekuguanli] GO /****** 对象: Table [dbo].[guanliyuan] 脚本日期: 05/02/2011 19:28:45 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[guanliyuan]( [ID] [int] IDENTITY(1,1) NOT NULL, [guanName] [nvarchar](12) NULL, [guanPassword] [nvarchar](12) NULL, CONSTRAINT [PK_chekuguanli] 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] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[jilu]( [dengjiID] [int] IDENTITY(1,1) NOT NULL, [guanName] [nchar](12) NULL, [currenttime] [nchar](50) NULL, [xingming] [nchar](20) NULL, [bianhao] [nchar](20) NULL, [renyuanchuru] [nchar](10) NULL, [xingbie] [nchar](12) NULL, [danwei] [nchar](12) NULL, CONSTRAINT [PK_jilu] PRIMARY KEY CLUSTERED ( [dengjiID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]