SQL Server – Client 連接非 Default Protocol

當 SQL Server 使用的 Protocol 並不是預設時，在使用 UI 的 ConnectionString 需如何設定才能連接至此 Server 呢？ 在 IPAddress 之後加入 “,” 才接 Protocol 如下所示：

image

留言

張貼留言

這個網誌中的熱門文章

WPF - 窺探 Flow Diagram Designer 的設計

最近收到一個很好玩的 Requirement，提供 Data Sources, Charts, Filters 等組件可讓 User 隨意組合這些元件為一個 Flow 並執行取得結果, 這讓我回想到三年前 WPF 出來時在網路上看到有好心人士提供了其作法和 Source Code, 想不到現在有這 Requirement 需要它了, 真的是太感謝這些好心人士了，那在此記錄一下這些相關的文章, 以防之後還有類似的需求時, 好方便瀏覽. Part 1 – Drag, resize and rotate items on a canvas Part 2 – Toolbox, drag & drop, rubberband selection Part 3 – Connecting items Part 4 – Open/Save, Cut/Copy/Past/Delete and print
閱讀完整內容

EasyUI – datebox 中如何自定日期格式化

在 datebox 中提供了二個 method ，一個為 formatter，另一個為 parser，這二個 method 是用來自定日期格式化的. formatter 是在顯示時如何選擇日期後將其格式化為所需的格式. parser 是在選擇好日期後告訴控件如何去解析自定義的格式. 將日期格式化為 yyyy-mm-dd 的格式如下所示： $('$dd').datebox({ formatter: function(date){ return date.getFullYear()+'-'+(date.getMonth()+1)+'-'+date.getDate(); }, parser: function(date){ return new Date(Date.parse(date.replace(/-/g,"/"))); } });
閱讀完整內容

ASP.NET MVC In-Depth: The Life of an ASP.NET MVC Request

雖然這是一篇舊的文章，但確能了解 ASP.NET MVC 它的 Life Cycle 為何？ The purpose of this blog entry is to describe, in painful detail, each step in the life of an ASP.NET MVC request from birth to death. I want to understand everything that happens when you type a URL in a browser and hit the enter key when requesting a page from an ASP.NET MVC website. Why do I care? There are two reasons. First, one of the promises of ASP.NET MVC is that it will be a very extensible framework. For example, you’ll be able to plug in different view engines to control how your website content is rendered. You also will be able to manipulate how controllers get generated and assigned to particular requests. I want to walk through the steps involved in an ASP.NET MVC page request because I want to discover any and all of these extensibility points. Second, I’m interested in Test-Driven Development. In order to write unit tests for controllers, I need to understand all of the controller dependencies. When writing my tests, I n...
閱讀完整內容