文件名称:database-manage
- 所属分类:
- WEB源码
- 资源属性:
- [Windows] [Visual.Net] [Basic/ASP] [源码]
- 上传时间:
- 2014-05-08
- 文件大小:
- 3.79mb
- 下载次数:
- 0次
- 提 供 者:
- 小**
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
系统说明
在运行系统之前,用户必须配置连接数据库的字符串,配置连接数据库的字符串存放在Web.config文件中,Web.config文件中的配置连接数据库的字符串如以下代码所示:
<add key="ConnectionString" value="Data Source=localhost POOLING=FALSE database=databasemanage User ID=sa Password=sa"/>
<add key="AdminTable" value="admintable"/>
用户可以管理其他数据标,但是必须在要管理的数据库添加一个数据库管理员的表,如以下代码所示:
CREATE TABLE [dbo].[admintable] (
[ID] [int] NULL ,
[username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[firstname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[lastname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[permission] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[dateadded] [datetime] NULL
) ON [PRIMARY]
GO
-Before running the system described in the system, the user must configure the database connection string, the configuration is stored in the database connection string in the Web.config file, the string in the Web.config file to configure the database connection as shown in the following code: <add key="ConnectionString" value="Data Source=localhost POOLING=FALSE database=databasemanage User ID=sa Password=sa"/><add key="AdminTable" value="admintable"/> Users can manage other data standard, but must be added to the database managed by a database administrator' s table, as shown in the following code: CREATE TABLE [dbo] [admintable] ([ID] [int] NULL, [username] [. nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL, [password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL, [firstname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL, [lastname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL, [permission ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL, [dateadded] [datetime] NULL)
在运行系统之前,用户必须配置连接数据库的字符串,配置连接数据库的字符串存放在Web.config文件中,Web.config文件中的配置连接数据库的字符串如以下代码所示:
<add key="ConnectionString" value="Data Source=localhost POOLING=FALSE database=databasemanage User ID=sa Password=sa"/>
<add key="AdminTable" value="admintable"/>
用户可以管理其他数据标,但是必须在要管理的数据库添加一个数据库管理员的表,如以下代码所示:
CREATE TABLE [dbo].[admintable] (
[ID] [int] NULL ,
[username] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[firstname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[lastname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[permission] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[dateadded] [datetime] NULL
) ON [PRIMARY]
GO
-Before running the system described in the system, the user must configure the database connection string, the configuration is stored in the database connection string in the Web.config file, the string in the Web.config file to configure the database connection as shown in the following code: <add key="ConnectionString" value="Data Source=localhost POOLING=FALSE database=databasemanage User ID=sa Password=sa"/><add key="AdminTable" value="admintable"/> Users can manage other data standard, but must be added to the database managed by a database administrator' s table, as shown in the following code: CREATE TABLE [dbo] [admintable] ([ID] [int] NULL, [username] [. nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL, [password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL, [firstname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL, [lastname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL, [permission ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL, [dateadded] [datetime] NULL)
(系统自动生成,下载前可以参看下载内容)
下载文件列表
数据库管理系统
..............\Admin2005
..............\.........\Adddata.aspx
..............\.........\Adddata.aspx.cs
..............\.........\App_Code
..............\.........\........\AssemblyInfo.cs
..............\.........\........\ClassDiagram.cd
..............\.........\........\Global.asax.cs
..............\.........\........\Migrated
..............\.........\........\........\db_aspx_cs_DataGridTemplate.cs
..............\.........\........\classes
..............\.........\........\.......\clsDataAccess.cs
..............\.........\........\.......\clsPhotoManager.cs
..............\.........\Deletedata.aspx
..............\.........\Deletedata.aspx.cs
..............\.........\Editdata.aspx
..............\.........\Editdata.aspx.cs
..............\.........\Global.asax
..............\.........\Image.aspx
..............\.........\Image.aspx.cs
..............\.........\Index.aspx
..............\.........\Index.aspx.cs
..............\.........\Logout.aspx
..............\.........\Logout.aspx.cs
..............\.........\TestImage.aspx
..............\.........\TestImage.aspx.cs
..............\.........\ViewData.aspx
..............\.........\Viewdata.aspx.cs
..............\.........\Web.config
..............\.........\bin
..............\.........\...\Admin.dll
..............\.........\classes
..............\.........\.......\Adddata.aspx.cs
..............\.........\datatype.htm
..............\.........\date
..............\.........\....\databasemanage.mdf
..............\.........\....\databasemanage_log.LDF
..............\.........\db.aspx
..............\.........\db.aspx.cs
..............\.........\dbMain.aspx.cs
..............\.........\dbmain.aspx
..............\.........\images
..............\.........\......\Admin.gif
..............\.........\......\CreateTable.jpg
..............\.........\......\Delete.jpg
..............\.........\......\DeleteTable.JPG
..............\.........\......\Edit.jpg
..............\.........\......\Editfield.jpg
..............\.........\......\InAction.jpg
..............\.........\......\TableDetails.jpg
..............\.........\......\Tables.jpg
..............\.........\......\Thumbs.db
..............\.........\......\View.jpg
..............\.........\......\admindb.jpg
..............\.........\......\admindetails.jpg
..............\.........\......\custom.jpg
..............\.........\......\dataAccess.jpg
..............\.........\......\login.jpg
..............\.........\......\placeholder-100.jpg
..............\.........\......\placeholder-200.jpg
..............\.........\......\placeholder-600.jpg
..............\.........\......\readtable.jpg
..............\.........\includes
..............\.........\........\bot.htm
..............\系统说明.txt