摘要:
C# 跳转新页面判断URL文件是不是在于在。C# 指定物理目录下载文件,Response.End导致“正在中止线程”异常的问题public class FileHandler { public static bool DownLoadFile(string path, string fileName) { bool result = false; if (!string.IsNullOrEmpty(path)) { if (path.StartsWith("http... 阅读全文
摘要:
System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. at System.Data.DataTable.EnableConstraints() at System.Data.DataTable.set_EnforceConstraints(Boolean value) at System.Data.DataTable.EndLoadDat... 阅读全文
摘要:
SELECT * FROM aspnet_RolesGODECLARE @role varchar(50) DECLARE CusCursor CURSOR FOR select RoleName from aspnet_Roles OPEN CusCursor FETCH NEXT FROM CusCursor INTO @role WHILE (@@FETCH_STATUS = 0) BEGIN SELECT @role --这里写SQL语句 FETCH NEXT FROM CusCursor INTO @role ... 阅读全文
摘要:
1. install all features in IIS2. Try the following steps to register it.run %windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i或运行,跳出如下错误:开发环境是Window Server2008, Visual Studio2010。出现原因:在安装开发环境时有关模块的安装顺序不太正确引起。(如先安装.NetFramework v4.0后安装IIS)解决方法:一、修复 .NET Framework 4.0.针对 32 bit or 64 bit 阅读全文
摘要:
前一段时间,老大给了个需求,就是对部分表进行了分库,所以,原库里面的存储过程、视图和函数里的表名等信息也要跟着更新,刚开始尝试手动检查了几个存储过程,可发现存储过程太多,检查起来效率很低,还容易出错,况且还有视图和函数,所以就想到了 Sql Server 内置的目录视图,找了一下,果然找到了解决办法:use ReportServer$SQLSERVER select a.name,a.[type],b.[definition] from sys.all_objects a,sys.sql_modules b where a.is_ms_shipped=0 and a.object_id = b 阅读全文