insert into yiyuan (keshi) values ('...')
select * from dbo.Article
delete from dbo.Article where ClassId='1'
page.response.redirect("~/module/admin/notice.aspx");
datalist数据绑定 用Eval函数绑定
以News_Data数据库为例
在查询分析器里输入
select * from dbo.Article查看表Article中的所有数据
delete from dbo.Article where ClassId='1'
就实现了,删除News_Data数据库里的表Article中所有ClassId为1的所有行的数据
工具》选项》文本编辑器》C#》行号;显示行号
F9为断点
Big_class表
CREATE DATABASE [dzjk_xm]
go
use [dzjk_xm]
go
CREATE TABLE [Big_Class] (
[BigClass_ID] [int] IDENTITY (1, 1) NOT NULL ,
[BigClass_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Enable] [bit] NULL ,
[Memo] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
collate是一个子句,定义排序
规则,Chinese_PRC_指针对大陆简体字UNICODE的排序规则。
_BIN 二进制排序
_CI(CS) 是否区分大小写,CI不区分,CS区分
_AI(AS) 是否区分重音,AI不区分,AS区分
_KI(KS) 是否区分假名类型,KI不区分,KS区分
_WI(WS) 是否区分宽度 WI不区分,WS区分
CONSTRAINT [PK_Big_Class] PRIMARY KEY CLUSTERED
(
[BigClass_ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
Small_Class表
CREATE TABLE [Small_Class] (
[SmallClass_ID] [int] IDENTITY (1, 1) NOT NULL ,
[BigClass_ID] [int] NULL ,
[SmallClass_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Enable] [bit] NULL ,----是否可用
[Memo] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_Small_Class] PRIMARY KEY CLUSTERED
(
[SmallClass_ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
News新闻CREATE TABLE [News] (
[News_ID] [int] IDENTITY (1, 1) NOT NULL ,
[Class_ID] [int] NOT NULL ,
[Title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Content] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Nkey] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DateTime] [datetime] NOT NULL CONSTRAINT [DF_News_DateTime] DEFAULT (getdate()),
[Hits] [int] NOT NULL CONSTRAINT [DF_Article_Hits] DEFAULT (0),
[ImgNews] [bit] NOT NULL ,--是否上传图片
[TitleImg] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Topicid] [int] NULL , ---图片路径名称
[MemberName] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
CONSTRAINT [PK_News_Class] PRIMARY KEY CLUSTERED
(
[News_ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
Link友情链接表
CREATE TABLE [Link] (
[LinkId] [int] IDENTITY (1, 1) NOT NULL ,
[LinkName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[LinkUrl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[AddDate] [datetime] NOT NULL CONSTRAINT [DF_Link_AddDate] DEFAULT (getdate()),
[MemberName] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
CONSTRAINT [PK_Link] PRIMARY KEY CLUSTERED
(
[LinkId]
) ON [PRIMARY]
) ON [PRIMARY]
go
以下为插入语句的实现方法
CREATE TABLE [yiyuan] (
[yiyuan_ID][int] identity(1,1) not null,
[yiyuan_Name][varchar](50)collate chinese_PRC_CI_AS NULL,
[Enable][bit]NULL,
[keshi] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
[doctor][varchar](20) collate chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_yiyuan] PRIMARY KEY CLUSTERED
(
[yiyuan_ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
insert into [yiyuan] ([keshi]) values ('内科')
insert into yiyuan (keshi) values ('外科')
以上两种方法均可以
以News_Data数据库为例
在查询分析器里输入
select * from dbo.Article查看表Article中的所有数据
删除语句
delete from dbo.Article where ClassId='1'
就实现了,删除News_Data数据库里的表Article中所有ClassId为1的所有行的数据