新手必看留言本采用sql server2005+asp.net(C#)编写

create database myBoard go use myBoard create table guest ( ID int identity(1,1) primary key, userName varchar(20) not null, sex varchar(10) not null, url varchar(20), qq varchar(20), email varchar(20), content varchar(1000) not null, reply varchar(1000), postTime datetime default(getdate()), imageUrl varchar(20) not null, faceUrl varchar(20) not null ) drop table guest insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic1.gif','face1.gif') insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','女','我是帅哥','pic2.gif','face2.gif') insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic3.gif','face3.gif') insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','女','我是帅哥','pic4.gif','face4.gif') insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic5.gif','face5.gif') insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','女','我是帅哥','pic6.gif','face6.gif') insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic7.gif','face7.gif') insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic8.gif','face8.gif') select * from guest drop table admin create table admin ( adminName varchar(20) not null, adminPwd varchar(20) not null, total varchar(20) )