/// <summary>
/// 获得表中数据
/// </summary>
/// <returns></returns>
private DataTable GetData()
{
Manage manage = new Manage();
string dbName = Request.QueryString["db"];
string tableName = Request.QueryString["table"];
findConn ();
return manage.ShowTableData(dbName, connInfo, tableName);
//--测试jqGrid
//DataTable dt = new DataTable();
//dt.Columns.Add(new DataColumn("Name", typeof(string)));
//dt.Columns.Add(new DataColumn("Typestring", typeof(string)));
//dt.Columns.Add(new DataColumn("Isnullable", typeof(string)));
//DataRow dr = dt.NewRow();
//dr["Name"] = "hai";
//dr["Typestring"] = "int";
//dr["Isnullable"] = "true";
//dt.Rows.Add(dr);
//return dt;
}
/// <summary>
/// 备份数据库
/// </summary>
/// <param name="dbName">数据库名</param>
public void Backup(string dbName)
{
Manage manage = new Manage();
ConnectionInfo conn = this.getConnInfo();
if (manage.IsExistDataBase(dbName, conn))
{
StringBuilder fileFullName = new StringBuilder();
fileFullName.Append(Server.MapPath(@"~\Backupfolder\"));//备份文件的路径
string name = System.DateTime.Now.ToString("yyyyMMdd_HHmmss", DateTimeFormatInfo.InvariantInfo) + ".bak";
fileFullName.Append(name);//备份文件的文件名
manage.BackupDataBase(dbName, this.getConnInfo(), fileFullName.ToString());
this.DownLoad(fileFullName.ToString());
}
else
{
Response.Write("<script>alert('该数据库不存在！')</script>");
}
}