2013年8月10日

Troubleshooting on TransactionScope

摘要: We often met several kinds of errors when using TransactionScope in our applications and some settings are not proper.Here are some tips on how to resolve these issues.My scenario is, web application is running on server A, and database used by the web app is running on server B, both servers have f 阅读全文

posted @ 2013-08-10 19:08 shcity 阅读(605) 评论(0) 推荐(0) 编辑

2013年7月13日

Parse string to JSON object

摘要: 阅读全文

posted @ 2013-07-13 00:30 shcity 阅读(238) 评论(0) 推荐(0) 编辑

2013年7月9日

Parse date in js

摘要: 阅读全文

posted @ 2013-07-09 16:40 shcity 阅读(379) 评论(0) 推荐(0) 编辑

2013年5月23日

blockUI doesn't close when download file in asp.net

摘要: solution:document.attachEvent("onreadystatechange", function () { if (document.readyState == "loading") { $.unblockUI(); } }); 阅读全文

posted @ 2013-05-23 22:05 shcity 阅读(484) 评论(0) 推荐(0) 编辑

2013年5月11日

define namespace in JS

摘要: function regNamespace(namespace) { var parts = namespace.split("."); var root = "window"; for (var i = 0; i < parts.length; i++) { var part = parts[i]; root = root + "." + part; if (eval(root) == undefined) { eval(root + "= {};") } }}... 阅读全文

posted @ 2013-05-11 01:35 shcity 阅读(275) 评论(0) 推荐(0) 编辑

2013年5月1日

Dense_Rank(), Row_Number(), Rank() in sql server

摘要: select id,number,name ,DENSE_RANK() over(partition by number order by name ) as dense,row_number() over(partition by number order by name ) as rownumber,rank() over(partition by number order by name ) as ranksfrom dbo.dense_demoselect * from dbo.dense_demoget the below result: 阅读全文

posted @ 2013-05-01 00:23 shcity 阅读(192) 评论(0) 推荐(0) 编辑

2013年3月3日

reading and writing variable through lock in SSIS script task

摘要: why we need lock to read or write variables, if we don't use lock, sometimes a deadlock will occur.writing variable:private void WriteValue(string name,object value) { Variables variables = Dts.Variables; try { Dts.VariableDispenser.LockOneForWr... 阅读全文

posted @ 2013-03-03 16:55 shcity 阅读(497) 评论(0) 推荐(0) 编辑

Fix the issue that cannot open SSIS in BIDS

摘要: Getting error below:Microsoft Visual Studio""An error prevented the view from loading.""Additional information:""Specified Module cannot be Found. (Exception from HRESULT: 0x8007007E)""(System.Windows.Forms)"How to fix this:deleting the whole folder " 阅读全文

posted @ 2013-03-03 15:04 shcity 阅读(241) 评论(0) 推荐(0) 编辑

three ways creating custom helpers to show RadioButtonList in MVC

摘要: first way is using the extension method to build the helper: public class ListOption { public string Text { get; set; } public object Value { get; set; } } public static class CustomHelperExtensions { public static MvcHtmlString RadioButtonList(this HtmlHelper helper... 阅读全文

posted @ 2013-03-03 01:39 shcity 阅读(427) 评论(0) 推荐(0) 编辑

2012年11月21日

using JavaScriptSerializer to serialize object to json

摘要: <scriptsrc="http://www.cnblogs.com/Scripts/MicrosoftAjax.js"type="text/javascript"></script><scriptsrc="http://www.cnblogs.com/Scripts/jquery-1.5.1.js"type="text/javascript"></script><scripttype="text/javascript">functio 阅读全文

posted @ 2012-11-21 23:52 shcity 阅读(339) 评论(0) 推荐(0) 编辑

导航