asp.net中gridview的查询、分页、编辑更新、删除的实例代码

use master
go
if exists(select * from sysdatabases where name=’db1′)
begin
    drop database db1
end
go
create database db1
go
use db1
go
— ================================
— ylb:1,类别表
— ================================
create table category
(
    categoryid int identity(1,1) primary key,    –编号【PK】
    categoryname varchar(20) not null            –名称
)

 

insert into category(categoryname) values(‘饮料’)
insert into category(categoryname) values(‘主食’)
insert into category(categoryname) values(‘副食’)
insert into category(categoryname) values(‘蔬菜’)

— ================================
— ylb:2,产品表
— ================================
create table product
(
    productid int identity(1001,1) primary key,    –编号【PK】
    productname varchar(20),        –名称
    unitprice numeric(7,2),            –单价
    special varchar(10) check(special in(‘特价’,’非特价’)),    –是否特价【C】
    categoryid int foreign key references category(categoryid)    –类别编号【FK】
)

insert into product(productname,unitprice,special,categoryid) values(‘可乐1′,12.6,’特价’,1)
insert into product(productname,unitprice,special,categoryid) values(‘可乐2′,12.6,’非特价’,1)
insert into product(productname,unitprice,special,categoryid) values(‘可乐3′,12.6,’非特价’,1)
insert into product(productname,unitprice,special,categoryid) values(‘可乐4′,12.6,’非特价’,1)
insert into product(productname,unitprice,special,categoryid) values(‘可乐5′,12.6,’特价’,1)
insert into product(productname,unitprice,special,categoryid) values(‘可乐6′,12.6,’特价’,1)
insert into product(productname,unitprice,special,categoryid) values(‘可乐7′,12.6,’特价’,1)
insert into product(productname,unitprice,special,categoryid) values(‘可乐8′,12.6,’特价’,1)
insert into product(productname,unitprice,special,categoryid) values(‘馒头1′,12.6,’特价’,2)
insert into product(productname,unitprice,special,categoryid) values(‘豆腐1′,12.6,’特价’,3)
insert into product(productname,unitprice,special,categoryid) values(‘冬瓜1′,12.6,’特价’,4)

select * from category
select productid,productname,unitprice,special,categoryid from product