Description: If exists(select name from sysobjects where name="Score" and type="U")
Drop table Score
go
create table Score(
UserName varchar(10) not null,
Subject varchar(15) not null,
Score int
)
go
If exists(select name from sysobjects where name="Subject" and type="U")
Drop table Subject
go
create table Subject(
UserName varchar(10) not null,
Subject varchar(15) not null,
Term varchar(10) not null
)
go
To Search:
File list (Check if you may need any files):
StdMis
......\AdmiAddTeach.aspx
......\AdmiAddTeach.aspx.cs
......\AdmiAddTeach.aspx.resx
......\AdmiAlterStd.aspx
......\AdmiAlterStd.aspx.cs
......\AdmiAlterStd.aspx.resx
......\AdmiAlterTchr.aspx
......\AdmiAlterTchr.aspx.cs
......\AdmiAlterTchr.aspx.resx
......\AdmiMain.aspx
......\AdmiMain.aspx.cs
......\AdmiMain.aspx.resx
......\AdmiManageTchr.aspx
......\AdmiManageTchr.aspx.cs
......\AdmiManageTchr.aspx.resx
......\AdminStdSreach.aspx
......\AdminStdSreach.aspx.cs
......\AdminStdSreach.aspx.resx
......\AdminTchrSreach.aspx
......\AdminTchrSreach.aspx.cs
......\AdminTchrSreach.aspx.resx
......\AdmiStdManage.aspx
......\AdmiStdManage.aspx.cs
......\AdmiStdManage.aspx.resx
......\AssemblyInfo.cs
......\bin
......\...\StdMis.dll
......\...\StdMis.pdb
......\Global.asax
......\Global.asax.cs
......\Global.asax.resx
......\Index.aspx
......\Index.aspx.cs
......\Index.aspx.resx
......\Registor.aspx
......\Registor.aspx.cs
......\Registor.aspx.resx
......\StdAlter.aspx
......\StdAlter.aspx.cs
......\StdAlter.aspx.resx
......\StdMain.aspx
......\StdMain.aspx.cs
......\StdMain.aspx.resx
......\StdMis.csproj
......\StdMis.csproj.webinfo
......\StdMis.sln
......\StdPassword.aspx
......\StdPassword.aspx.cs
......\StdPassword.aspx.resx
......\TchrAlter.aspx
......\TchrAlter.aspx.cs
......\TchrAlter.aspx.resx
......\TchrMain.aspx
......\TchrMain.aspx.cs
......\TchrMain.aspx.resx
......\TchrScore.aspx
......\TchrScore.aspx.cs
......\TchrScore.aspx.resx
......\Web.config