📄 default.aspx.cs
字号:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
TextBox1.Text = DateTime.Now.ToShortDateString()+DateTime.Now.Hour.ToString() + "H.mdb";
this.DataBindList();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (!File.Exists(Server.MapPath(@"~\bakDataBase\" + TextBox1.Text)))
{
File.Copy(Server.MapPath(@"~\App_Data\Test.mdb"), Server.MapPath(@"~\bakDataBase\" + TextBox1.Text));
this.DataBindList();
Response.Write("数据备份成功!");
}
else
{
Response.Write("备份文件已经存在,请重新命名!!!");
}
}
public void DataBindList()
{
DropDownList1.Items.Clear();
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("fileName", typeof(string)));
DirectoryInfo dir = new DirectoryInfo(Server.MapPath(@"~\bakDataBase\"));
foreach (FileInfo file in dir.GetFiles())
{
DataRow dr = dt.NewRow();
dr[0] = file;
dt.Rows.Add(dr);
}
DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "fileName";
DropDownList1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
File.Copy(Server.MapPath(@"~\bakDataBase\" + DropDownList1.SelectedItem.Text), Server.MapPath(@"~\App_Data\Test.mdb"), true);
Response.Write("数据恢复成功!");
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -