其他

CREATE PROCEDURE ProductPromotion_Select@ProductID intASSELECTProductID,ProductName,SUBSTRING(Description, 1, 150) + '...'AS DescriptionFROM ProductsWHERE ProductID IN(SELECT TOP 5 details2.ProductIDFROM OrderDetails details1INNER JOIN OrderDetails

前幾天的網路上紛紛傳言windows live writer的beta版本出來了，是一個本地寫blog的好工具。原先用過delphibbs版主孫老師的一個blog寫作工具（抱歉名字忘記了），感覺很好，但是正式版本要收費，所以沒辦法只好棄用。既然有此等情結，所以很快找到並安裝了，但是因為無法配置到cnblogs，所以只好放棄。 今天看到了思歸囈語的這篇文章，欣喜若狂。我的配置步驟如下： 1。安裝運行Writer之後，開始會出現幾個dll找不到的警告，忽略它，等嚮導出來之後，在Weblog

Refer: http://cosier.wordpress.com/2006/7/3/moss-2007-upgrade-error/ If you receive the following error during a SPS 2003 -> MOSS 2007 upgrade: “Failed to start the database service MSSQL$OfficeServers. Repair this product using Add/Remove

YUI Style Glowing Buttons with the AjaxControlToolkit GlowButtonExtender ControlYUI recently added another button type to their control library - they call it the Glowing Button Control.  The Glowing Button Control allows you to add a glossy, glass

Supporting Multiple IIS Bindings Per SiteRef: http://blogs.msdn.com/rampo/archive/2007/06/15/supporting-multiple-iis-bindings-per-site.aspx If you see this error when you are hosting in IIS then most probably you have multiple IIS bindings per

摘要：　　本文解決使用Visual Studio 2008 Beta 2調試IIS7 (Vista)網站時發生的“Unable to start debugging on the web server. 強式名稱驗證失敗。”問題。（英文版提示文字：Unable to start debugging on the web server. Strong name validation failed.）環境：　　Vista Ultimate/Business、IIS 7.0、Visual

文章目錄 Strategy pattern Strategy patternFrom Wikipedia, the free encyclopediaJump to: navigation, search In computer programming, the strategy pattern is a particular software design pattern, whereby algorithms can be

Ref http://industriallogic.com/papers/learning.html#STUDY     Design Patterns Navigation l Factory MethodSession 1 Begin with Factory Method. This pattern is used by a number of patterns in the book and throughout the patterns literature. u

當時寫程式的時候，因為老闆非要一個PDF report,苦於crystal report deployment太麻煩了，所以就用了reportviewer,而且中間偷懶了一下，直接用typed dataset產生了dataset，問題就出現在，因為這次要把原來的project在重新做給其他公司一套，而且資料庫更換了名字，而當時用typed dataset的時候是直根據當時的ConnectionString名字產生的，結果就出現了Typed

    // Carry over profile property values from an anonymous to an authenticated state     void Profile_MigrateAnonymous(Object sender, ProfileMigrateEventArgs e) {        ProfileCommon anonProfile = Profile.GetProfile(e.AnonymousID);        // Merge 

文章目錄    This is a quite common question. It is usually asked by people arriving at SQL Server with a background in Microsoft Access. They either want to use SQL Server as a backend for their Access project, or they are

request.params for asp.net is the httprequest object, and this method gets a combined collection of querystring, cookies, form and servervars items...request. querystring just gets

Ref: http://aspnet.4guysfromrolla.com/demos/printPage.aspx?path=/articles/082504-1.aspxIntroductionThe ASP.NET data Web controls - the DataGrid, DataList, and Repeater - are highly versatile controls that can display arbitrary collections of data.

可填可選的DropDownList Server Control 前言： 學程式都是常學常忘，所以把思路和心得都記錄下來，那怕是很簡單的東西，所以就有了這篇文章需求： 因項目需要一個可填可寫的DropDownList ；原理： 任何ASP.NET Server

/**//// <summary>        /// 是否是數字型        /// </summary>        /// <param name="value"></param>        /// <returns></returns>        public static bool IsNumeric(string value)        ...{            return

在軟體開發中項目失敗是很正常的,大部分的項目都在延期的邊緣,但是為什麼會造成這樣的結果呢?我們有很強的工程師,對專案管理也很完善,為什麼還會造成這樣的結果呢?為什麼項目做到了一定的程度,客戶只要求一個小的修改我們都會帶出來一大堆的問題呢?一切的問題都在於你檢查過你寫的代碼了嗎?你對你的代碼重構了嗎?最近翻開我的一本老書,這本書已經在我的書架上睡了快兩年了,當時買的時候看了部分開頭,學了一小部分最近開始真的帶項目的時候使用了上面說的一部分方法後,才發現這本書真的很好,又一次翻開了.從這篇文章開始,

在Cnblog搜尋一下會有很多文章介紹關於Datalist 嵌套 Repeater, Repeater嵌套Repeater, DataList嵌套DataList的文章，概括起來也就那麼幾種方法，有興趣的朋友看了以後，如果有缺少的可以補上1. 微軟的方法，就是用一個dataset,把資料分別fill到這個dataset的兩個表格中，然後設定好關係。 DataSet ds=new DataSet();string sql1="select * from province";            

我用的是Theme的StyleSheet,其他的都style都可以應用，但是就是到了DataList裡面的連結怎麼都不能用頁面的DataList render出來的是這樣<a href="catalogs.aspx" class="discoun">BUMPER</a>            <asp:DataList ID="dlCatalogs" runat="server" RepeatColumns="4"  Width="500px" Height="80

ref: http://blogs.msdn.com/kcwalina/archive/2005/09/23/Collections.aspxPublished 23 September 05 08:10 PM | kcwalina Many people ask how the new.NET Framework 2.0 generic collections relate to the non-generic collections we shipped before. So, here

When you copy large files to or from earlier operating systems, the copy operation may be slower than expected on some Windows Vista-based computers  WORKAROUNDTo work around this problem, you may be able to use one of the following methods to