用Gridview做的投票系统(四种方法).

IF EXISTS (SELECT 1 FROM sys.databases WHERE name = N'WishVote') DROP DATABASE WishVote GO CREATE DATABASE WishVote GO use WishVote go IF exists (SELECT 1 FROM sys.objects WHERE name = N'title' AND type = 'U') DROP TABLE [dbo].title GO create table title ( titleid int identity primary key, title varchar(30) ) go IF exists (SELECT 1 FROM sys.objects WHERE name = N'candidate' AND type = 'U') DROP TABLE [dbo].candidate GO create table candidate ( candidateid int identity primary key, candidate varchar(30), quantity int, titleid int references title(titleid) ) --drop table candidate use wishvote go insert into title(title) values('2007年世界足球先生票选') insert into title(title) values('你喜欢的编程语言') insert into candidate(candidate, quantity, titleid) values('Ronaldinho',0,1) insert into candidate(candidate, quantity, titleid) values('Henry',0,1) insert into candidate(candidate, quantity, titleid) values('Kaka',0,1) insert into candidate(candidate, quantity, titleid) values('李毅',0,1) insert into candidate(candidate, quantity, titleid) values('C.Ronaldo',0,1) insert into candidate(candidate, quantity, titleid) values('C',0,2) insert into candidate(candidate, quantity, titleid) values('C#',0,2) insert into candidate(candidate, quantity, titleid) values('Java',0,2) select * from title select * from candidate select candidate, quantity, SumQuantity from candidate inner join (select titleid, sum(quantity) as SumQuantity from candidate group by titleid) as A on candidate.titleid = A.titleid