C#_ member Management System (user login)

First create the database:

[Vip]

Create three tables:

respectively:

[Vipinformation] ( member Information )

[Log] ( log )

[Vipaccount] ( account Privileges )

Detailed statement:

1 --Create a database [Vip]2 Create DatabaseVip3  on Primary4 (5Name='Vip'6, filename='E:\vip\Vip.mdf'7, size=3MB8, maxsize=100MB9, filegrowth=Ten%Ten ) One Log  on A ( -Name='Vip_log' -, filename='E:\Vip\Vip_log.ldf' the, size=1MB -, maxsize=Unlimited -, filegrowth=1MB - ) + Go - --querying the database [Vip] +  UseVIP A --Create a table [Vipinformation] (member information) at Create Tablevipinformation - ( -VIdint Identity(1,1)Primary Key -, VNamenvarchar( -) -, Vgendernchar(2) -, Vageint in, vaddressnvarchar( -) -, Vphonevarchar( -) to ) + --enquiry Form [vipinformation] - Select *  fromvipinformation the --CREATE TABLE [log] (logs) * Create Table [Log] $ (Panax NotoginsengIdint Identity(1,1)Primary Key -, VNamenvarchar( -) the, Situationnchar(Ten) +,[ Time] datetime A, VTypenvarchar( -) the ) + --query table [Log] - Select *  from [Log] $ --CREATE TABLE [Vipaccount] (account permissions) $ Create TableVipaccount - ( -VIdint Identity(1,1)Primary Key the, vUserNamenvarchar( -) not NULL -, Vuserpwdnchar( -) not NULLWuyi, usertypenvarchar( -)NULL the ) - --enquiry Form [Vipaccount] Wu Select *  fromVipaccount - --Insert Table [Vipaccount] About Insert  intoVipaccount (Vusername,vuserpwd,usertype)Values('Admin','123','Administrator')

Cond...

C#_ member Management System (user login)