IF EXISTS (SELECT 1 FROM sys.databases WHERE name = N'Wish')
DROP DATABASE [Wish]
GO
CREATE DATABASE [Wish]
GO
--论坛
--表
--Users表存储论坛注册成员的信息
USE Wish
GO
IF exists (SELECT 1 FROM sys.objects WHERE name = 'Users' AND type = 'U')
DROP TABLE [dbo].[Users]
GO
CREATE TABLE [dbo].[Users] (
[UserID] INT IDENTITY PRIMARY KEY CLUSTERED,
[UserName] [varchar](16) NOT NULL UNIQUE ,
[Nickname] [nvarchar](16) NOT NULL,
[Password] [varchar] (60) NOT NULL,
[Email] [varchar] (255) NOT NULL default '',
[Question] [nvarchar] (60) NOT NULL default '',
[Answer] [nvarchar](60) NOT NULL default '',
[Sex] [varchar](1) NOT NULL DEFAULT 'M',
[ShowEmail] [bit] NOT NULL DEFAULT (1),
[Signature] [nvarchar] (1000) NOT NULL default '',
[ImageUrl] [varchar] (100) NOT NULL default '',
[AddedDate] [datetime] NOT NULL DEFAULT (getdate()),
[Type][tinyint] NOT NULL DEFAULT (0)
)
GO
--数据
--密码为wishwish
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('admin','admin','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','admin@wish-edu.com','admin','admin','M','images/faces/image1.gif',getdate(), 9)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('amandag','高歌','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','amandag@vip.sina.com','amandag','amandag','M','images/faces/image2.gif',getdate(), 1)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('moon','月亮之上','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','moon@wish-edu.com','moon','moon','F','images/faces/image3.gif',getdate(), 1)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('rebecca','雪儿','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','rebecca@wish-edu.com','rebecca','rebecca','F','images/faces/image4.gif',getdate(), 0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('Mickey','馨','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','Mickey@wish-edu.com','Mickey','Mickey','F','images/faces/image5.gif',getdate(),0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('Jia','佳佳','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','M','images/faces/image6.gif',getdate(),0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('aaa','aaa','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','F','images/faces/image7.gif',getdate(), 0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('bbb','bbb','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','F','images/faces/image8.gif',getdate(),0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('ccc','ccc','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','M','images/faces/image9.gif',getdate(),0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('ddd','ddd','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','F','images/faces/image10.gif',getdate(), 0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('eee','eee','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','F','images/faces/image11.gif',getdate(),0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('fff','fff','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','M','images/faces/image12.gif',getdate(),0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('ggg','ggg','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','F','images/faces/image13.gif',getdate(), 0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('hhh','hhh','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','F','images/faces/image14.gif',getdate(),0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('iii','iii','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','M','images/faces/image15.gif',getdate(),0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('jjj','jjj','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','F','images/faces/image16.gif',getdate(), 0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('kkk','kkk','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','F','images/faces/image17.gif',getdate(),0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('lll','lll','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','M','images/faces/image18.gif',getdate(),0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('mmm','mmm','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','F','images/faces/image19.gif',getdate(), 0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('nnn','nnn','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','F','images/faces/image20.gif',getdate(),0)
INSERT INTO Users([UserName], [NickName], [Password], [Email], [Question], [Answer], [Sex], [ImageUrl], [AddedDate],[Type])
VALUES('ooo','ooo','D7-63-C1-D4-53-8E-21-6A-34-1F-70-29-1B-4F-94-1E-9B-BB-FB-AE','test@wish-edu.com','test','test','M','images/faces/image21.gif',getdate(),0)
--返回所有可用用户信息
if exists (select 1 from sys.objects where name = 'GetUserList' and
type = 'P')
drop procedure [dbo].GetUserList
GO
CREATE PROCEDURE [dbo].GetUserList
AS
SELECT UserID, UserName, Nickname, Email, Question, Answer, Sex, ShowEmail, Signature, ImageUrl, AddedDate, [Type]
FROM Users
GO
--删除用户
if exists (select 1 from sys.objects where name = 'DeleteUser' and
type = 'P')
drop procedure [dbo].[DeleteUser]
GO
CREATE PROCEDURE DeleteUser
@UserID int
AS
DELETE FROM Users WHERE UserID = @UserID
GO
--更新用户Type
if exists (select 1 from sys.objects where name = 'UpdateType' and
type = 'P')
drop procedure [dbo].UpdateType
GO
CREATE PROCEDURE UpdateType
@UserID int ,
@Type varchar(255)
AS
UPDATE Users
Set [Type] = @Type
Where UserID = @UserID
GO
用Gridview做的一个小程序 （215个子文件） 
Default.aspx 5KB Details.aspx 2KB
Wishlogo.bmp 81KB 112.bmp 6KB 110.bmp 6KB 107.bmp 6KB 108.bmp 6KB 106.bmp 6KB 111.bmp 6KB 109.bmp 6KB 65.bmp 5KB 9.bmp 5KB 56.bmp 5KB 97.bmp 5KB 3.bmp 5KB 50.bmp 5KB 37.bmp 5KB 82.bmp 5KB 26.bmp 5KB 100.bmp 5KB 114.bmp 5KB 52.bmp 5KB 11.bmp 5KB 79.bmp 5KB 63.bmp 5KB 30.bmp 5KB 29.bmp 5KB 41.bmp 5KB 60.bmp 5KB 16.bmp 5KB 2.bmp 5KB 93.bmp 5KB 98.bmp 5KB 12.bmp 5KB 78.bmp 5KB 19.bmp 5KB 14.bmp 5KB 89.bmp 5KB 73.bmp 5KB 86.bmp 5KB 8.bmp 5KB 81.bmp 5KB 69.bmp 5KB 57.bmp 5KB 38.bmp 5KB 22.bmp 5KB 15.bmp 5KB 35.bmp 5KB 75.bmp 5KB 10.bmp 5KB 85.bmp 5KB 99.bmp 5KB 46.bmp 5KB 31.bmp 5KB 44.bmp 5KB 25.bmp 5KB 28.bmp 5KB 58.bmp 5KB 77.bmp 5KB 23.bmp 5KB 51.bmp 5KB 96.bmp 5KB 94.bmp 5KB 21.bmp 5KB 64.bmp 5KB 49.bmp 5KB 7.bmp 5KB 83.bmp 5KB 4.bmp 5KB 95.bmp 5KB 36.bmp 5KB 47.bmp 5KB 90.bmp 5KB 45.bmp 5KB 17.bmp 5KB 42.bmp 5KB 80.bmp 5KB 113.bmp 5KB 55.bmp 5KB 87.bmp 5KB 18.bmp 5KB 88.bmp 5KB 33.bmp 5KB 66.bmp 5KB 59.bmp 5KB 24.bmp 5KB 48.bmp 5KB 70.bmp 5KB 20.bmp 5KB 61.bmp 5KB 54.bmp 5KB 71.bmp 5KB 72.bmp 5KB 116.bmp 5KB 53.bmp 5KB 6.bmp 5KB 67.bmp 5KB 5.bmp 5KB 13.bmp 5KB 34.bmp 5KB共 215 条
- 1
- 2
- 3
资源评论
