using?System;
using?System.Collections;
using?System.Configuration;
using?System.Data;
using?System.Linq;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.HtmlControls;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.xml.Linq;
using?System.Data.SqlClient;

public?partial?class?beifen?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（!Page.IsPostBack）
????????{
????????????//在DropDownList中綁定所有數據庫?
????????????SqlConnection?con?=?new?SqlConnection（@“Integrated?Security=SSPI;database=teacher;server=20100401-0926\SQLEXPRESS2008“）;
????????????SqlCommand?cmd?=?new?SqlCommand（“sp_helpdb“?con）;
????????????cmd.CommandType?=?CommandType.StoredProcedure;
????????????con.Open（）;
????????????SqlDataReader?re?=?cmd.ExecuteReader（）;
????????????DropDownList1.DataSource?=?re;
????????????DropDownList1.DataTextField?=?“Name“;
????????????DropDownList1.DataBind（）;
????????????re.Close（）;
????????????con.Close（）;

????????}

????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????string?dbfilename?=?TextBox1.Text.Trim（）;
????????SqlConnection?con?=?new?SqlConnection（@“Integrated?Security=SSPI;database=teacher;server=20100401-0926\SQLEXPRESS2008“）;
????????string?str1?=?DropDownList1.SelectedValue.Trim（）;

????????if?（!dbfilename.EndsWith（“.dak“））
????????{
????????????dbfilename?+=?“.dak“;
????????}

????????SqlCommand?cmd?=?new?SqlCommand（“use?master;backup?database?@name?to?disk=@path;“?con）;
????????con.Open（）;
????????string?path?=?Server.MapPath（“~\\App_Data“）?+?“\\“?+?dbfilename;
????????cmd.Parameters.AddWithValue（“@name“?str1）;
????????cmd.Parameters.AddWithValue（“@path“?path）;
????????cmd.ExecuteNonQuery（）;
????????con.Close（）;
????????Page.RegisterStartupscript（“bbb“?“ript>alert（‘備份成功‘）;ript>“）;

????}
????protected?void?Button2_Click（object?sender?EventArgs?e）
????{
????????string?dbfilename?=?TextBox1.Text.Trim（）;
????????SqlConnection?con?=?new?SqlConnection（@“Integrated?Security=SSPI;database=teacher;server=20100401-0926\SQLEXPRESS2008“）;
????????string?str1?=?DropDownList1.SelectedValue.Trim（）;

????????if?（!dbfilename.EndsWith（“.dak“））
????????{
????????????dbfilename?+=?“.dak“;
????????}

????????SqlCommand?cmd?=?new?SqlCommand（“use?master;restore?database?@name?from?disk=@path;“?con）;
????????con.Open（）;
????????string?path?=?Server.MapPath（“~\\App_Data“）?+?“\\“?+?dbfilename;
????????cmd.Parameters.AddWithValue（“@name“?str1）;
????????cmd.Parameters.AddWithValue（“@path“?path）;
????????cmd.ExecuteNonQuery（）;
????????con.Close（）;
????????Page.RegisterStartupscript（“bbb“?“ript>alert（‘恢復成功‘）;ript>“）;
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1617??2006-11-07?18:38??畢業設計\App_Code\randomCode.cs

?????文件????3145728??2010-04-19?16:59??畢業設計\App_Data\teacher.mdf

?????文件????1048576??2010-04-19?16:59??畢業設計\App_Data\teacher_log.ldf

?????文件???????1591??2010-04-18?17:33??畢業設計\beifen.aspx

?????文件???????2838??2010-04-18?17:33??畢業設計\beifen.aspx.cs

?????文件????????476??2010-04-15?13:44??畢業設計\bottom.ascx

?????文件????????458??2010-04-15?13:16??畢業設計\bottom.ascx.cs

?????文件??????13874??2010-04-18?17:45??畢業設計\chaxun.aspx

?????文件???????2306??2010-04-18?17:48??畢業設計\chaxun.aspx.cs

?????文件????????435??2006-11-04?08:48??畢業設計\css\css.css

?????文件????????549??2009-12-12?15:44??畢業設計\css\styleSheet.css

?????文件??????90292??2006-11-13?10:54??畢業設計\Images\banner.jpg

?????文件??????11783??2006-11-10?16:51??畢業設計\Images\lonin.jpg

?????文件???????4992??2010-04-12?21:40??畢業設計\Images\lonin1.jpg

?????文件???????4978??2010-04-12?22:05??畢業設計\Images\lonin2.jpg

?????文件???????1199??2006-11-10?11:55??畢業設計\Images\修改資料.gif

?????文件??????55524??2006-11-13?10:56??畢業設計\Images\右側.jpg

?????文件??????23349??2006-11-08?15:41??畢業設計\Images\右側總標頭.jpg

?????文件??????46103??2006-11-13?10:55??畢業設計\Images\左側.jpg

?????文件??????23446??2006-11-08?15:39??畢業設計\Images\底部.jpg

?????文件???????1244??2006-11-10?11:54??畢業設計\Images\條件查詢.gif

?????文件???????1264??2006-11-10?11:55??畢業設計\Images\管理用戶.gif

?????文件???????1231??2006-11-10?11:53??畢業設計\Images\系統設置.gif

?????文件????????760??2006-11-10?11:54??畢業設計\Images\退出系統.gif

?????文件??????81566??2010-04-12?20:39??畢業設計\Images\高校教師檔案管理系統原稿.jpg

?????文件??????36385??2010-04-12?20:45??畢業設計\Images\高校教師檔案管理系統登錄界面.jpg

?????文件???????4048??2010-04-17?12:40??畢業設計\index.aspx

?????文件???????3204??2010-04-20?15:09??畢業設計\index.aspx.cs

?????文件??????15630??2010-04-19?16:27??畢業設計\information.aspx

?????文件??????10361??2010-04-19?16:25??畢業設計\information.aspx.cs

............此處省略32個文件信息