<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>FAQ Book &#187; ASP.NET</title>
	<atom:link href="https://blog.faq-book.com/?cat=14&#038;feed=rss2" rel="self" type="application/rss+xml" />
	<link>https://blog.faq-book.com</link>
	<description>Some SOP,Note,Learned Article of IT  關於IT資訊界的筆記和學習紀錄</description>
	<lastBuildDate>Sun, 27 Mar 2022 12:25:43 +0000</lastBuildDate>
	<language>zh-TW</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=</generator>
<xhtml:meta xmlns:xhtml="http://www.w3.org/1999/xhtml" name="robots" content="noindex" />
	<atom:link rel='hub' href='https://blog.faq-book.com/?pushpress=hub'/>
		<item>
		<title>Visual Studio Plugin &#8211; vsvim 設定指標顏色</title>
		<link>https://blog.faq-book.com/?p=5522</link>
		<comments>https://blog.faq-book.com/?p=5522#comments</comments>
		<pubDate>Mon, 20 Aug 2012 03:42:18 +0000</pubDate>
		<dc:creator>andy</dc:creator>
				<category><![CDATA[ASP.NET]]></category>
		<category><![CDATA[Cursor]]></category>
		<category><![CDATA[vi]]></category>
		<category><![CDATA[Vim]]></category>
		<category><![CDATA[Visual Studio 2008]]></category>
		<category><![CDATA[Visual Studio Plugin]]></category>
		<category><![CDATA[vsvim]]></category>

		<guid isPermaLink="false">http://blog.faq-book.com/?p=5522</guid>
		<description><![CDATA[<p>基於使用vim的習慣，在Visual Studio也有外掛可以使編輯器可以模擬vim的操作。</p>
<p>在Visual Studio 2008推薦使用<span style="color: #0000ff"><a href="http://www.viemu.com/" target="_blank"><span style="color: #0000ff">ViEmu</span></a></span> 而在2010擴充套件就有免費的vsvim。在預設的情況下，其實都沒有任何問題。</p>
<p>但是當您使用了黑底（Dark）背景的style之後會發現指標Cursor不見了，其實不是不見只是預設是黑色。</p>
<p>此時只要變更一些小小的設定即可如下圖：</p>
<p><a href="http://images.faq-book.com/photo/Book/Program/tools/vs-1.png" rel="lightbox[5522]"><img src="http://images.faq-book.com/photo/Book/Program/tools/vs-1.png" alt="" width="600" height="430" /></a></p>
<p>&nbsp;</p>
<p> <a href="https://blog.faq-book.com/?p=5522#more-5522" class="more-link">繼續閱讀 &raquo;</a></p>

<div class="wp_rp_wrap  wp_rp_pinterest" id="wp_rp_first"><div class="wp_rp_content"><h3 class="related_post_title">更多內容</h3><ul class="related_post wp_rp" style="visibility: visible"><li data-position="0" data-poid="in-3029" data-post-type="none" ><a href="https://blog.faq-book.com/?p=3029" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Vim 指令基本說明" /></a><a href="https://blog.faq-book.com/?p=3029" class="wp_rp_title">Vim 指令基本說明</a></li><li data-position="1" data-poid="in-1611" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1611" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/n0.jpg" alt="WebMatrix安裝&amp;資料庫簡易連線&amp;Wordpress安裝" /></a><a href="https://blog.faq-book.com/?p=1611" class="wp_rp_title">WebMatrix安裝&#038;資料庫簡易連線&#038;Wordpress安裝</a></li><li data-position="2" data-poid="in-3192" data-post-type="none" ><a href="https://blog.faq-book.com/?p=3192" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/17.png" alt="ASP.NET MVC 3 + AppHarbor 無痛進入新時代" /></a><a href="https://blog.faq-book.com/?p=3192" class="wp_rp_title">ASP.NET MVC 3 + AppHarbor 無痛進入新時代</a></li><li data-position="3" data-poid="in-32" data-post-type="none" ><a href="https://blog.faq-book.com/?p=32" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/011.jpg" alt="SSIS資料庫匯入匯出設定&amp; SQL Agent定期排程" /></a><a href="https://blog.faq-book.com/?p=32" class="wp_rp_title">SSIS資料庫匯入匯出設定&#038; SQL Agent定期排程</a></li><li data-position="4" data-poid="in-1943" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1943" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="ASP NET 匯出PDF" /></a><a href="https://blog.faq-book.com/?p=1943" class="wp_rp_title">ASP NET 匯出PDF</a></li><li data-position="5" data-poid="in-1577" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1577" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[ASP NET]連結動態輸出圖片,Response 圖片,資料繫結動態圖片" /></a><a href="https://blog.faq-book.com/?p=1577" class="wp_rp_title">[ASP NET]連結動態輸出圖片,Response 圖片,資料繫結動態圖片</a></li><li data-position="6" data-poid="in-1940" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1940" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="ASP.NET GridView,ListView 超連結 Get 兩個以上參數" /></a><a href="https://blog.faq-book.com/?p=1940" class="wp_rp_title">ASP.NET GridView,ListView 超連結 Get 兩個以上參數</a></li><li data-position="7" data-poid="in-2692" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2692" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="CKeditor in ASP.NET" /></a><a href="https://blog.faq-book.com/?p=2692" class="wp_rp_title">CKeditor in ASP.NET</a></li><li data-position="8" data-poid="in-2622" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2622" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt=" ASP.NET 應懂的相關基礎與簡答 " /></a><a href="https://blog.faq-book.com/?p=2622" class="wp_rp_title"> ASP.NET 應懂的相關基礎與簡答 </a></li><li data-position="9" data-poid="in-3086" data-post-type="none" ><a href="https://blog.faq-book.com/?p=3086" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="JSON與JSON NET" /></a><a href="https://blog.faq-book.com/?p=3086" class="wp_rp_title">JSON與JSON NET</a></li></ul></div></div>
<div class='yarpp-related-rss'>
<h3>相關文章:</h3>
<div class="yarpp-thumbnails-horizontal">
<a class='yarpp-thumbnail' href='https://blog.faq-book.com/?p=1825' title='Google +1 button for WordPress – plugin'>
<span class="yarpp-thumbnail-default"><img src="http://blog.faq-book.com/wp-content/plugins/yet-another-related-posts-plugin/default.png"/></span><span class="yarpp-thumbnail-title">Google +1 button for WordPress – plugin</span></a>
</div>
<img src='http://yarpp.org/pixels/96bfd12e93e905461749e105253e82f0'/>
</div>
]]></description>
		<wfw:commentRss>https://blog.faq-book.com/?feed=rss2&#038;p=5522</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ASP.NET MVC 3 + AppHarbor 無痛進入新時代</title>
		<link>https://blog.faq-book.com/?p=3192</link>
		<comments>https://blog.faq-book.com/?p=3192#comments</comments>
		<pubDate>Sat, 24 Sep 2011 14:46:46 +0000</pubDate>
		<dc:creator>andy</dc:creator>
				<category><![CDATA[ASP.NET]]></category>
		<category><![CDATA[.NET]]></category>
		<category><![CDATA[AppHarbor]]></category>
		<category><![CDATA[MVC 3]]></category>

		<guid isPermaLink="false">http://blog.faq-book.com/?p=3192</guid>
		<description><![CDATA[<p><img alt="" height="269" src="http://blog.faq-book.com/wp-content/uploads/1.PNG" width="600" /></p>
<p>今天分享這篇文章是希望可以有更多人來玩 ASP.NET MVC ！！</p>
<p>一直以來我覺得ASP.NET 對於一些原本是OpenSource 開發者轉進微軟Solution的人來說,最討厭的就是;一個可以讓自己開心測試玩樂的環境難求！在銀彈不足的情況下常常需要東找西找.至於找什麼大家心裡明白就好XD 外加大多數的公司老闆不太會因為你的好奇心就貿然用新版的軟體,Framework,所以很多時候是自己有心可是大環境有點無奈,更多的情況應該是就算Express版本和一些免費的SDK都可以玩.但是玩玩之後要分享給朋友真的是好麻煩.&nbsp;如果你又想使用MSSQL那就更討厭了今天發現了這個方便的服務配合整理一些前輩的文章希望大家也可以來玩。</p>
<p><strong>何謂AppHarbor ？</strong></p>
<p>&nbsp;<a href="https://appharbor.com">AppHarbor </a>是一個PaaS服務，如果你還不明白這是啥可以參考 <a href="http://zh.wikipedia.org/wiki/%E5%B9%B3%E5%8F%B0%E5%8D%B3%E6%9C%8D%E5%8A%A1">Wiki</a>&nbsp;<a href="http://eblog.cisanet.org.tw/80366493/article/content.aspx?ArticleID=996">簡單說明</a>&nbsp;! 如果你需要的是一些實例那可以<a href="http://www.inside.com.tw/2011/02/17/heroku-like">參考這篇</a></p>
<p>在稍微理解一些前因後果之後，馬上就可以先來註冊一下。</p>
<p><img alt="" height="449" src="http://blog.faq-book.com/wp-content/uploads/2.PNG" width="435" /></p>
<p>比起微軟本身的Azure我覺得這個服務實在是單純超多的。就是輸入資料註冊完之後建立一個App</p>
<p><img alt="" height="314" src="http://blog.faq-book.com/wp-content/uploads/4.PNG" width="710" /></p>
<p> <a href="https://blog.faq-book.com/?p=3192#more-3192" class="more-link">繼續閱讀 &raquo;</a></p>

<div class="wp_rp_wrap  wp_rp_pinterest" ><div class="wp_rp_content"><h3 class="related_post_title">更多內容</h3><ul class="related_post wp_rp" style="visibility: visible"><li data-position="0" data-poid="in-2692" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2692" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="CKeditor in ASP.NET" /></a><a href="https://blog.faq-book.com/?p=2692" class="wp_rp_title">CKeditor in ASP.NET</a></li><li data-position="1" data-poid="in-1940" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1940" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="ASP.NET GridView,ListView 超連結 Get 兩個以上參數" /></a><a href="https://blog.faq-book.com/?p=1940" class="wp_rp_title">ASP.NET GridView,ListView 超連結 Get 兩個以上參數</a></li><li data-position="2" data-poid="in-2622" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2622" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt=" ASP.NET 應懂的相關基礎與簡答 " /></a><a href="https://blog.faq-book.com/?p=2622" class="wp_rp_title"> ASP.NET 應懂的相關基礎與簡答 </a></li><li data-position="3" data-poid="in-1943" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1943" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="ASP NET 匯出PDF" /></a><a href="https://blog.faq-book.com/?p=1943" class="wp_rp_title">ASP NET 匯出PDF</a></li><li data-position="4" data-poid="in-912" data-post-type="none" ><a href="https://blog.faq-book.com/?p=912" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Windows 7 開啟及安裝 .NET Framework" /></a><a href="https://blog.faq-book.com/?p=912" class="wp_rp_title">Windows 7 開啟及安裝 .NET Framework</a></li><li data-position="5" data-poid="in-1611" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1611" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/n0.jpg" alt="WebMatrix安裝&amp;資料庫簡易連線&amp;Wordpress安裝" /></a><a href="https://blog.faq-book.com/?p=1611" class="wp_rp_title">WebMatrix安裝&#038;資料庫簡易連線&#038;Wordpress安裝</a></li><li data-position="6" data-poid="in-5522" data-post-type="none" ><a href="https://blog.faq-book.com/?p=5522" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2012/08/Visual-Studio-Plugin.png" alt="Visual Studio Plugin &#8211; vsvim 設定指標顏色" /></a><a href="https://blog.faq-book.com/?p=5522" class="wp_rp_title">Visual Studio Plugin &#8211; vsvim 設定指標顏色</a></li><li data-position="7" data-poid="in-1577" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1577" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[ASP NET]連結動態輸出圖片,Response 圖片,資料繫結動態圖片" /></a><a href="https://blog.faq-book.com/?p=1577" class="wp_rp_title">[ASP NET]連結動態輸出圖片,Response 圖片,資料繫結動態圖片</a></li><li data-position="8" data-poid="in-451" data-post-type="none" ><a href="https://blog.faq-book.com/?p=451" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="SQL Server Management Studio連線設定介紹" /></a><a href="https://blog.faq-book.com/?p=451" class="wp_rp_title">SQL Server Management Studio連線設定介紹</a></li><li data-position="9" data-poid="in-846" data-post-type="none" ><a href="https://blog.faq-book.com/?p=846" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Linux常見的壓縮打包指令" /></a><a href="https://blog.faq-book.com/?p=846" class="wp_rp_title">Linux常見的壓縮打包指令</a></li></ul></div></div>
<div class='yarpp-related-rss yarpp-related-none'>
<h3>相關文章:</h3>
<p>沒有相關文章</p>
<img src='http://yarpp.org/pixels/96bfd12e93e905461749e105253e82f0'/>
</div>
]]></description>
		<wfw:commentRss>https://blog.faq-book.com/?feed=rss2&#038;p=3192</wfw:commentRss>
		<slash:comments>4</slash:comments>
		</item>
		<item>
		<title>JSON與JSON NET</title>
		<link>https://blog.faq-book.com/?p=3086</link>
		<comments>https://blog.faq-book.com/?p=3086#comments</comments>
		<pubDate>Thu, 15 Sep 2011 01:39:27 +0000</pubDate>
		<dc:creator>andy</dc:creator>
				<category><![CDATA[ASP.NET]]></category>
		<category><![CDATA[JSON]]></category>
		<category><![CDATA[JSON NET]]></category>

		<guid isPermaLink="false">http://blog.faq-book.com/?p=3086</guid>
		<description><![CDATA[<p>何謂JSON</p>
<p>JSON(JavaScript Object Nonation) 是一種輕量級的[資料交換語言],以純文字為基底儲存和傳送的資料格式.說的白話一點是一種定義好用來做資料交換的格式(還是很饒舌),那就是一種功能上類似XML的東西.還無法參透的話請<a href="http://blog.wu-boy.com/2011/04/%E4%BD%A0%E4%B8%8D%E5%8F%AF%E4%B8%8D%E7%9F%A5%E7%9A%84-json-%E5%9F%BA%E6%9C%AC%E4%BB%8B%E7%B4%B9/">參考這篇</a>。而JSONNET講的粗淺一點就是一隻用來把NET物件轉成JSON字串或者把JSON字串轉成物件的DLL</p>
<p>官方介紹:</p>
<p><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: verdana, arial, sans-serif; ">Json.NET makes working with JSON formatted data in .NET simple. Quickly read and write JSON using LINQ to JSON or serialize your .NET objects with a single method call using the JsonSerializer.</span></p>
<p>這個組件使.NET可以更簡單快速的使用JSON格式的資料,並且使用LINQ去撈資料或者序列化(產生JSON字串)您的.NET物件</p>
<p><a href="http://james.newtonking.com/projects/json/help/">官方手冊</a></p>
<p><a href="http://json.codeplex.com/">下載</a></p>
<p><strong>整理使用筆記 :&nbsp;</strong></p>
<p>1. 下載後直接將/bin底下的dll加入參考,目前4版有對應2.0 3.5 後面沒有版號的目錄是4.0</p>
<p>2. 匯入命名空間</p>
<p>&nbsp;</p>
<p>using Newtonsoft.Json;</p>
<p>using Newtonsoft.Json.Linq;</p>
<p>&nbsp;</p>
<p>3. 物件轉JSON</p>
<p><strong>第一種:傳統強型別直接轉</strong></p>
<p><span style="color:#008000;">//實踐一個書本類別並帶入資料</span></p>
<p>&nbsp;</p>
<p>TradtionBook tbook = new TradtionBook { Name = &quot;OlderBook&quot;, Author = &quot;AndyYou&quot;, ISBN = 123456, PubDate = new DateTime(2011,9,9) };</p>
<p>Console.WriteLine(<span style="color:#00f;">JsonConvert.SerializeObject(tbook)</span>);<span style="color:#008000;"> // 這樣就轉好了</span></p>
<p> <a href="https://blog.faq-book.com/?p=3086#more-3086" class="more-link">繼續閱讀 &raquo;</a></p>

<div class="wp_rp_wrap  wp_rp_pinterest" ><div class="wp_rp_content"><h3 class="related_post_title">更多內容</h3><ul class="related_post wp_rp" style="visibility: visible"><li data-position="0" data-poid="in-2622" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2622" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt=" ASP.NET 應懂的相關基礎與簡答 " /></a><a href="https://blog.faq-book.com/?p=2622" class="wp_rp_title"> ASP.NET 應懂的相關基礎與簡答 </a></li><li data-position="1" data-poid="in-1943" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1943" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="ASP NET 匯出PDF" /></a><a href="https://blog.faq-book.com/?p=1943" class="wp_rp_title">ASP NET 匯出PDF</a></li><li data-position="2" data-poid="in-1611" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1611" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/n0.jpg" alt="WebMatrix安裝&amp;資料庫簡易連線&amp;Wordpress安裝" /></a><a href="https://blog.faq-book.com/?p=1611" class="wp_rp_title">WebMatrix安裝&#038;資料庫簡易連線&#038;Wordpress安裝</a></li><li data-position="3" data-poid="in-2939" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2939" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="監測MSSQL執行的效能與時間" /></a><a href="https://blog.faq-book.com/?p=2939" class="wp_rp_title">監測MSSQL執行的效能與時間</a></li><li data-position="4" data-poid="in-2692" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2692" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="CKeditor in ASP.NET" /></a><a href="https://blog.faq-book.com/?p=2692" class="wp_rp_title">CKeditor in ASP.NET</a></li><li data-position="5" data-poid="in-5522" data-post-type="none" ><a href="https://blog.faq-book.com/?p=5522" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2012/08/Visual-Studio-Plugin.png" alt="Visual Studio Plugin &#8211; vsvim 設定指標顏色" /></a><a href="https://blog.faq-book.com/?p=5522" class="wp_rp_title">Visual Studio Plugin &#8211; vsvim 設定指標顏色</a></li><li data-position="6" data-poid="in-1577" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1577" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[ASP NET]連結動態輸出圖片,Response 圖片,資料繫結動態圖片" /></a><a href="https://blog.faq-book.com/?p=1577" class="wp_rp_title">[ASP NET]連結動態輸出圖片,Response 圖片,資料繫結動態圖片</a></li><li data-position="7" data-poid="in-1940" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1940" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="ASP.NET GridView,ListView 超連結 Get 兩個以上參數" /></a><a href="https://blog.faq-book.com/?p=1940" class="wp_rp_title">ASP.NET GridView,ListView 超連結 Get 兩個以上參數</a></li><li data-position="8" data-poid="in-3192" data-post-type="none" ><a href="https://blog.faq-book.com/?p=3192" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/17.png" alt="ASP.NET MVC 3 + AppHarbor 無痛進入新時代" /></a><a href="https://blog.faq-book.com/?p=3192" class="wp_rp_title">ASP.NET MVC 3 + AppHarbor 無痛進入新時代</a></li><li data-position="9" data-poid="in-1712" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1712" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[問題紀錄]Ruby安裝dbi錯誤 on Mac" /></a><a href="https://blog.faq-book.com/?p=1712" class="wp_rp_title">[問題紀錄]Ruby安裝dbi錯誤 on Mac</a></li></ul></div></div>
<div class='yarpp-related-rss yarpp-related-none'>
<h3>相關文章:</h3>
<p>沒有相關文章</p>
<img src='http://yarpp.org/pixels/96bfd12e93e905461749e105253e82f0'/>
</div>
]]></description>
		<wfw:commentRss>https://blog.faq-book.com/?feed=rss2&#038;p=3086</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>監測MSSQL執行的效能與時間</title>
		<link>https://blog.faq-book.com/?p=2939</link>
		<comments>https://blog.faq-book.com/?p=2939#comments</comments>
		<pubDate>Thu, 01 Sep 2011 13:29:10 +0000</pubDate>
		<dc:creator>andy</dc:creator>
				<category><![CDATA[ASP.NET]]></category>
		<category><![CDATA[MSSQL]]></category>

		<guid isPermaLink="false">http://blog.faq-book.com/?p=2939</guid>
		<description><![CDATA[<p>&nbsp;</p>
<div><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: arial, sans-serif; font-size: 13px; ">SQL端測試</span></div>
<div><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: arial, sans-serif; font-size: 13px; "><br />
	</span></div>
<div><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: arial, sans-serif; font-size: 13px; "><span style="color:#696969;">DECLARE @Begin DATETIME</span></span></div>
<div><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: arial, sans-serif; font-size: 13px; "><span style="color:#696969;">DECLARE @End DATETIME</span></span></div>
<div><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: arial, sans-serif; font-size: 13px; "><span style="color:#696969;">SET @Begin = GETDATE()</span></span></div>
<div><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: arial, sans-serif; font-size: 13px; "><span style="color:#696969;"><br />
	</span></span></div>
<div><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: arial, sans-serif; font-size: 13px; "><span style="color:#008000;">&#8211;執行SQL CmdStart</span></span></div>
<div><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: arial, sans-serif; font-size: 13px; "><span style="color:#696969;">Select name,sum(payment)as pay From member group by name having sum(payment)&gt;40&nbsp;</span></span></div>
<div><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: arial, sans-serif; font-size: 13px; "><span style="color:#008000;">&#8211;SQL CmdEnd</span></span></div>
<div><span style="color:#696969;"><br />
	</span></div>
<div><span style="color:#696969;">SET @End = GETDATE()</span></div>
<div><span style="color:#696969;">SELECT &nbsp;DATEDIFF(millisecond, @Begin, @End) AS ExecutionTime</span></div>
<div>&nbsp;</div>
<div>C# 程式端測試</div>
<div>
<div><span style="color:#008000;">&nbsp; &nbsp; &nbsp; &nbsp; //宣告觀察物件 提供一組方法和屬性 (Property)，您可以使用這些方法和屬性，精確地測量已耗用時間。</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();</span></div>
<div><span style="color:#808080;"><br />
		</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; cmd.Connection = cn;</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; cmd.CommandType = CommandType.StoredProcedure;</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; cmd.CommandText = &quot;SP_UpdateMember&quot;;</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; SqlParameter Name = new SqlParameter(&quot;@Name&quot;,TboxName.Text.Trim().ToString());</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; SqlParameter Id = new SqlParameter(&quot;@ID&quot;, Convert.ToInt32(TboxId.Text.Trim()));</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.Add(Name);</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; cmd.Parameters.Add(Id);</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; try</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; {</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; watch.Start();</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cn.Open();</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cmd.ExecuteNonQuery();</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; }</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; catch (Exception ex)</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; {</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Response.Write(ex.Message);</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; }</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; watch.Stop();</span></div>
<div><span style="color:#808080;">&nbsp; &nbsp; &nbsp; &nbsp; Response.Write(watch.ElapsedMilliseconds); <span style="color:#008000;">//單位毫秒</span></span></div>
</div>

<div class="wp_rp_wrap  wp_rp_pinterest" ><div class="wp_rp_content"><h3 class="related_post_title">更多內容</h3><ul class="related_post wp_rp" style="visibility: visible"><li data-position="0" data-poid="in-2692" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2692" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="CKeditor in ASP.NET" /></a><a href="https://blog.faq-book.com/?p=2692" class="wp_rp_title">CKeditor in ASP.NET</a></li><li data-position="1" data-poid="in-1943" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1943" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="ASP NET 匯出PDF" /></a><a href="https://blog.faq-book.com/?p=1943" class="wp_rp_title">ASP NET 匯出PDF</a></li><li data-position="2" data-poid="in-1611" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1611" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/n0.jpg" alt="WebMatrix安裝&amp;資料庫簡易連線&amp;Wordpress安裝" /></a><a href="https://blog.faq-book.com/?p=1611" class="wp_rp_title">WebMatrix安裝&#038;資料庫簡易連線&#038;Wordpress安裝</a></li><li data-position="3" data-poid="in-3086" data-post-type="none" ><a href="https://blog.faq-book.com/?p=3086" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="JSON與JSON NET" /></a><a href="https://blog.faq-book.com/?p=3086" class="wp_rp_title">JSON與JSON NET</a></li><li data-position="4" data-poid="in-1940" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1940" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="ASP.NET GridView,ListView 超連結 Get 兩個以上參數" /></a><a href="https://blog.faq-book.com/?p=1940" class="wp_rp_title">ASP.NET GridView,ListView 超連結 Get 兩個以上參數</a></li><li data-position="5" data-poid="in-3192" data-post-type="none" ><a href="https://blog.faq-book.com/?p=3192" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/17.png" alt="ASP.NET MVC 3 + AppHarbor 無痛進入新時代" /></a><a href="https://blog.faq-book.com/?p=3192" class="wp_rp_title">ASP.NET MVC 3 + AppHarbor 無痛進入新時代</a></li><li data-position="6" data-poid="in-1577" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1577" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="[ASP NET]連結動態輸出圖片,Response 圖片,資料繫結動態圖片" /></a><a href="https://blog.faq-book.com/?p=1577" class="wp_rp_title">[ASP NET]連結動態輸出圖片,Response 圖片,資料繫結動態圖片</a></li><li data-position="7" data-poid="in-2622" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2622" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt=" ASP.NET 應懂的相關基礎與簡答 " /></a><a href="https://blog.faq-book.com/?p=2622" class="wp_rp_title"> ASP.NET 應懂的相關基礎與簡答 </a></li><li data-position="8" data-poid="in-5522" data-post-type="none" ><a href="https://blog.faq-book.com/?p=5522" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2012/08/Visual-Studio-Plugin.png" alt="Visual Studio Plugin &#8211; vsvim 設定指標顏色" /></a><a href="https://blog.faq-book.com/?p=5522" class="wp_rp_title">Visual Studio Plugin &#8211; vsvim 設定指標顏色</a></li><li data-position="9" data-poid="in-3140" data-post-type="none" ><a href="https://blog.faq-book.com/?p=3140" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="RSS 錯誤訊息 Extra content at the end of the document" /></a><a href="https://blog.faq-book.com/?p=3140" class="wp_rp_title">RSS 錯誤訊息 Extra content at the end of the document</a></li></ul></div></div>
<div class='yarpp-related-rss yarpp-related-none'>
<h3>相關文章:</h3>
<p>沒有相關文章</p>
<img src='http://yarpp.org/pixels/96bfd12e93e905461749e105253e82f0'/>
</div>
]]></description>
		<wfw:commentRss>https://blog.faq-book.com/?feed=rss2&#038;p=2939</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>CKeditor in ASP.NET</title>
		<link>https://blog.faq-book.com/?p=2692</link>
		<comments>https://blog.faq-book.com/?p=2692#comments</comments>
		<pubDate>Fri, 29 Jul 2011 08:00:43 +0000</pubDate>
		<dc:creator>andy</dc:creator>
				<category><![CDATA[ASP.NET]]></category>
		<category><![CDATA[.NET]]></category>
		<category><![CDATA[CKeditor in ASP.NET]]></category>

		<guid isPermaLink="false">http://blog.faq-book.com/?p=2692</guid>
		<description><![CDATA[<p><meta charset="utf-8" /><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; color: rgb(0, 0, 0); "><span style="font-family: 'courier new', monospace; color: rgb(0, 0, 255); ">CKeditor in&nbsp;</span><a href="http://asp.net/" style="font-family: 'courier new', monospace; color: rgb(0, 0, 255); ">ASP.NET</a><br style="font-family: 'courier new', monospace; " /><br />
	<br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">1. 至官方下載&nbsp;</span><a href="http://ckeditor.com/download" style="font-family: 'courier new', monospace; ">http://ckeditor.com/download</a>&nbsp;<br style="font-family: 'courier new', monospace; " /><br />
	<br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">2. 解開壓鎖檔後刪除不必要的檔案 _samples _source 目錄以減少檔案容量。</span><br style="font-family: 'courier new', monospace; " /><br />
	<br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">3.&nbsp;<a href="http://xn--lduo00cbja898anriyb41ns70a.net/">複製該目錄至您的.NET</a>專案底下</span><br style="font-family: 'courier new', monospace; " /><br />
	<br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">4. 在&lt;head&gt;&lt;/head&gt;中間引入Ckeditor 的JS 核心 ：&nbsp;</span><span style="color: rgb(61, 133, 198); font-family: 'courier new', monospace; "><br />
	&lt;script type=&quot;text/javascript&quot; src=&quot;ckeditor/ckeditor.js&quot;&gt;&lt;/script&gt;</span><br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; "><br />
	在HEAD中如下:</span><br />
	<br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">&lt;head runat=&quot;server&quot;&gt;</span><br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">&nbsp;&nbsp;&nbsp; &lt;title&gt;HTML Editor&lt;/title&gt;</span><br style="font-family: 'courier new', monospace; " /><br />
	<span style="color: rgb(61, 133, 198); font-family: 'courier new', monospace; ">&lt;script type=&quot;text/javascript&quot; src=&quot;ckeditor/ckeditor.js&quot;&gt;&lt;/script&gt;</span><br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">&lt;/head&gt;</span><br style="font-family: 'courier new', monospace; " /><br />
	<br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">5. 在Form中間插入Textbox物件 或切換到原始碼頁面插入&nbsp;&nbsp;<span style="color: rgb(204, 0, 0); ">注意: ID可以自行設定</span></span><br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">&lt;asp:TextBox ID=&quot;<span style="color: rgb(204, 0, 0); ">tbContent</span>&quot; name=&quot;tbContent&quot; runat=&quot;server&quot; TextMode=&quot;MultiLine&quot;&gt;&lt;/asp:TextBox&gt;</span><br style="font-family: 'courier new', monospace; " /><br />
	<br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">6. 接著在上面那段程式碼下方插入下面這段JS</span><br style="font-family: 'courier new', monospace; " /><br />
	<br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">&lt;script type=&quot;text/javascript&quot;&gt;</span><br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">&nbsp;&nbsp;&nbsp;&nbsp; //CKEDITOR.replace(&#39;tbContent&#39;);</span><br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">&nbsp;&nbsp;&nbsp;&nbsp; CKEDITOR.replace(&#39;&lt;%=tbContent.ClientID.Replace(&quot;_&quot;,&quot;$&quot;) %&gt;&#39;,{toolbar:&#39;Andybar&#39;});</span><br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; ">&lt;/script&gt;</span><br />
	<br style="font-family: 'courier new', monospace; " /><br />
	<span style="font-family: 'courier new', monospace; color: rgb(61, 133, 198); ">重點程式註解 :&nbsp;</span><br style="font-family: 'courier new', monospace; color: rgb(61, 133, 198); " /><br />
	<span style="font-family: 'courier new', monospace; color: rgb(61, 133, 198); ">CKEDITOR.replace(&#39;&lt;%=[物件ID].ClientID.Replace(&quot;_&quot;,&quot;$&quot;) %&gt;&#39;,{toolbar:&#39;[ 工具列的屬性 可設定 Basic 或 Full ]});</span><br style="font-family: 'courier new', monospace; " /><br />
	 <a href="https://blog.faq-book.com/?p=2692#more-2692" class="more-link">繼續閱讀 &raquo;</a></span></p>

<div class="wp_rp_wrap  wp_rp_pinterest" ><div class="wp_rp_content"><h3 class="related_post_title">更多內容</h3><ul class="related_post wp_rp" style="visibility: visible"><li data-position="0" data-poid="in-3192" data-post-type="none" ><a href="https://blog.faq-book.com/?p=3192" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/17.png" alt="ASP.NET MVC 3 + AppHarbor 無痛進入新時代" /></a><a href="https://blog.faq-book.com/?p=3192" class="wp_rp_title">ASP.NET MVC 3 + AppHarbor 無痛進入新時代</a></li><li data-position="1" data-poid="in-2622" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2622" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt=" ASP.NET 應懂的相關基礎與簡答 " /></a><a href="https://blog.faq-book.com/?p=2622" class="wp_rp_title"> ASP.NET 應懂的相關基礎與簡答 </a></li><li data-position="2" data-poid="in-1943" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1943" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="ASP NET 匯出PDF" /></a><a href="https://blog.faq-book.com/?p=1943" class="wp_rp_title">ASP NET 匯出PDF</a></li><li data-position="3" data-poid="in-1940" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1940" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="ASP.NET GridView,ListView 超連結 Get 兩個以上參數" /></a><a href="https://blog.faq-book.com/?p=1940" class="wp_rp_title">ASP.NET GridView,ListView 超連結 Get 兩個以上參數</a></li><li data-position="4" data-poid="in-912" data-post-type="none" ><a href="https://blog.faq-book.com/?p=912" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="Windows 7 開啟及安裝 .NET Framework" /></a><a href="https://blog.faq-book.com/?p=912" class="wp_rp_title">Windows 7 開啟及安裝 .NET Framework</a></li><li data-position="5" data-poid="in-1611" data-post-type="none" ><a href="https://blog.faq-book.com/?p=1611" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/n0.jpg" alt="WebMatrix安裝&amp;資料庫簡易連線&amp;Wordpress安裝" /></a><a href="https://blog.faq-book.com/?p=1611" class="wp_rp_title">WebMatrix安裝&#038;資料庫簡易連線&#038;Wordpress安裝</a></li><li data-position="6" data-poid="in-2939" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2939" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="監測MSSQL執行的效能與時間" /></a><a href="https://blog.faq-book.com/?p=2939" class="wp_rp_title">監測MSSQL執行的效能與時間</a></li><li data-position="7" data-poid="in-3086" data-post-type="none" ><a href="https://blog.faq-book.com/?p=3086" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="JSON與JSON NET" /></a><a href="https://blog.faq-book.com/?p=3086" class="wp_rp_title">JSON與JSON NET</a></li><li data-position="8" data-poid="in-2476" data-post-type="none" ><a href="https://blog.faq-book.com/?p=2476" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2013/02/default-150x150.png" alt="W3C 網頁相關的狀態碼說明" /></a><a href="https://blog.faq-book.com/?p=2476" class="wp_rp_title">W3C 網頁相關的狀態碼說明</a></li><li data-position="9" data-poid="in-7393" data-post-type="none" ><a href="https://blog.faq-book.com/?p=7393" class="wp_rp_thumbnail"><img src="http://blog.faq-book.com/wp-content/uploads/2014/05/tcpping.jpg" alt="Install Tcpping on Linux" /></a><a href="https://blog.faq-book.com/?p=7393" class="wp_rp_title">Install Tcpping on Linux</a></li></ul></div></div>
<div class='yarpp-related-rss yarpp-related-none'>
<h3>相關文章:</h3>
<p>沒有相關文章</p>
<img src='http://yarpp.org/pixels/96bfd12e93e905461749e105253e82f0'/>
</div>
]]></description>
		<wfw:commentRss>https://blog.faq-book.com/?feed=rss2&#038;p=2692</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
