剛用ASP.net做完一套使用者和新聞管理系統
來源:互聯網
上載者:User
在運行之初,先進行web.config檔案的配置
<add key="connString" value="Persist Security Info=False;server=(local);database=資料庫名;uid=使用者名稱;pwd=密碼" />
<add key="LocalPath" value="虛擬目錄的實體路徑" />
資料庫指令碼如下:
/****** Object: Table [dbo].[AdminUser] Script Date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AdminUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[AdminUser]GO
/****** Object: Table [dbo].[Article] Script Date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Article]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Article]
GO
/****** Object: Table [dbo].[ArticleGroup] Script Date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ArticleGroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ArticleGroup]
GO
/****** Object: Table [dbo].[GroupPurview] Script Date: 2005-6-12 16:26:46 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GroupPurview]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GroupPurview]
GO
/****** Object: Table [dbo].[ImageArticle] Script Date: 2005-6-12 16:26:46 ******/