ASP.NET结合数据库增删改查的简单示例

use master go if exists(select * from sysdatabases where name='db1') begin drop database db1 end go create database db1 go use db1 go create table category ( categoryid int identity(1,1) primary key, 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('蔬菜') create table product ( productid int identity(1001,1) primary key, productname varchar(20), unitprice numeric(7,2), special varchar(10) check(special in('特价','非特价')), categoryid int foreign key references category(categoryid) ) 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