/// <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>"); } }