C# (CSharp) DataAccess.SelectTableAccess示例

示例#1

文件： HomeController.cs 项目： pcstx/DataBaseReadOnly

        public ActionResult SelectTable(string sql, string dbName, string connectionStringName = "SqlServerHelper")
        {
            DataAccess.SelectTableAccess access = new DataAccess.SelectTableAccess();
            var dy = access.Select(sql, dbName, connectionStringName);

            return(PartialView(dy));
        }

示例#2

文件： HomeController.cs 项目： pcstx/DataBaseReadOnly

        public ActionResult ExportTable(string sql, string dbName, string connectionStringName = "SqlServerHelper")
        {
            DataAccess.SelectTableAccess access = new DataAccess.SelectTableAccess();
            var    dy     = access.Select(sql, dbName, connectionStringName);
            string path   = Server.MapPath(@"~/App_Data/Export/export.xls");
            bool   result = ExcelExport.ExportExcelWithAspose(dy, path);

            return(File(path, "application/ms-excel", "export.xls"));
        }

示例#3

文件： HomeController.cs 项目： pcstx/DataBaseReadOnly

 public ActionResult SelectTable(string sql,string dbName, string connectionStringName = "SqlServerHelper")
 {
     DataAccess.SelectTableAccess access = new DataAccess.SelectTableAccess();
      var dy = access.Select(sql, dbName, connectionStringName);
      return PartialView(dy);
 }

示例#4

文件： HomeController.cs 项目： pcstx/DataBaseReadOnly

        public ActionResult ExportTable(string sql, string dbName, string connectionStringName = "SqlServerHelper")
        {
            DataAccess.SelectTableAccess access = new DataAccess.SelectTableAccess();
            var dy = access.Select(sql, dbName, connectionStringName);
            string path = Server.MapPath(@"~/App_Data/Export/export.xls");
            bool result= ExcelExport.ExportExcelWithAspose(dy, path);

            return File(path, "application/ms-excel", "export.xls");
        }