[+/-] : 使用SmtpClient注意事項如果你不是使用.Net 4.0+

這個Bug源自於該功能不會自動Close or Dispose Session
只能等到自行Time out，這會造成有些e-mail不對而造成錯誤信息

解決方式其實很簡單，將MaxIdleTime設為0還有ConnectionLimit設為1就搞定囉!


SmtpClient.ServicePoint.MaxIdleTime = 0
SmtpClient.ServicePoint.ConnectionLimit = 1


如果想看官網回報可以看這裡
SmtpClient does not close session after sending message...
Read more.

[+/-] : Word 套版 With Office Word 2007 問題

網路上找的大部份都是這樣的範例，當成功執行之後[Name]會被換成Boss
一切都是這樣的美好，因為我們全公司都使用Office 2003

  Dim word As New Microsoft.Office.Interop.Word.Application
  Dim doc As Microsoft.Office.Interop.Word.Document
  Try
      doc = word.Documents.Open("C:\1.doc")
      doc.Activate()
      Dim myStoryRange As Microsoft.Office.Interop.Word.Range
      For Each myStoryRange In doc.StoryRanges

          With myStoryRange.Find
              .Text = "[Name]"
              .Replacement.Text = "Boss"
              .Wrap = Microsoft.Office.Interop.Word.WdFindWrap.wdFindContinue
              .Execute(Replace:=Microsoft.Office.Interop.Word.WdReplace.wdReplaceAll)
          End With
      Next myStoryRange
      word.Visible = True
  Catch ex As COMException
      MessageBox.Show("Error accessing Word document.")
  Finally
      doc = Nothing
      word = Nothing
  End Try

可是好景不常，噹噹噹~踢到了一個鐵板
---------------------------
System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at Word.Find.set_Text(String prop)
---------------------------
網路上眾說紛雲，
1.有人說是記憶體壞掉
2.也有說是因為Office 2003和Office 2007同時安裝的關係

嗯~發生問題的User真的是使用Office 2007
長話短說，為了這個問題在茫茫網海中花了二天半的時間
最後當然是找到了解決方式
原來只要改一個字
把Word.WdFindWrap.wdFindContinue改成Word.WdFindWrap.wdFindAsk
問題解決!

如果套板的文字只要換一次可以把wdReplaceAll改成wdReplaceOne
這樣可以節省一些時間喔!

Case close....
Read more.

[+/-] : Decimal.Round 產出的錯誤信息

Decimal.Round(CType(txt.ToString(), Decimal), 2).ToString

之前在VS2003 .NET 1.1 Run的好好的程式，因為昇級到了VS2005 .NET 2.0 Sp2的環境之後
產生的錯誤訊息，因為VS2005之後就可以使用Math.Round這個Function所以大概只有昇級完會碰到這個問題吧，而且在編譯時不會有任何的錯誤，是在Run Time才會發現，所以才頭痛啊，言歸正傳

Decimal.Round只接受傳入的值為Decimal所以轉型一下就ok囉
Dim txt As Decimal = Ctype(txt.Tostring(), Decimal)
Decimal.Round(txt, 2).ToString()


如需叫用 Just-In-Time (JIT) 偵錯的詳細資料，
請參閱本訊息結尾處 (而非這個對話方塊) 的資訊。

************** 例外狀況文字 **********
System.Reflection.AmbiguousMatchException: Overload resolution failed because no Public 'Round' can be called without a narrowing conversion:
'Public Shared Function Round(d As Decimal, mode As System.MidpointRounding) As Decimal':
Argument matching parameter 'd' narrows from 'String' to 'Decimal'.
Argument matching parameter 'mode' narrows from 'Integer' to 'MidpointRounding'.
'Public Shared Function Round(d As Decimal, decimals As Integer) As Decimal':
Argument matching parameter 'd' narrows from 'String' to 'Decimal'.
於 Microsoft.VisualBasic.CompilerServices.OverloadResolution.ResolveOverloadedCall(String MethodName, List`1 Candidates, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, BindingFlags LookupFlags, Boolean ReportErrors, ResolutionFailure& Failure)
於 Microsoft.VisualBasic.CompilerServices.OverloadResolution.ResolveOverloadedCall(String MethodName, MemberInfo[] Members, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, BindingFlags LookupFlags, Boolean ReportErrors, ResolutionFailure& Failure)
於 Microsoft.VisualBasic.CompilerServices.NewLateBinding.ResolveCall(Container BaseReference, String MethodName, MemberInfo[] Members, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, BindingFlags LookupFlags, Boolean ReportErrors, ResolutionFailure& Failure)
於 Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)
於 wsERP2004.fm_QC_Raw_Sampling_W.fm_QC_Raw_Sampling_W_Load(Object sender, EventArgs e)
於 System.Windows.Forms.Form.OnLoad(EventArgs e)
於 System.Windows.Forms.Form.OnCreateControl()
於 System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
於 System.Windows.Forms.Control.CreateControl()
於 System.Windows.Forms.Control.WmShowWindow(Message& m)
於 System.Windows.Forms.Control.WndProc(Message& m)
於 System.Windows.Forms.ScrollableControl.WndProc(Message& m)
於 System.Windows.Forms.ContainerControl.WndProc(Message& m)
於 System.Windows.Forms.Form.WmShowWindow(Message& m)
於 System.Windows.Forms.Form.WndProc(Message& m)
於 System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
於 System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
於 System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)...
Read more.

[+/-] : 如何利用表單檔名(字串)，動態叫出winform

先拜請了一下Goolge大神，得到一個網址
http://bauann-makeit.blogspot.com/2008/08/form.html


Dim myF As Form = _
CType(Activator.CreateInstance(System.Reflection.Assembly.GetExecutingAssembly.GetType("YourAssemblyName." & "YourFormName")), Form)
myF.ShowDialog()


其中YourAssemblyName就是你的專案名稱
YourFormName就是你的Form的名字

如果你新建專案是用預設的名稱那就會是WindowsApplication1
表單是Form1
組合起來就是WindowsApplication1.Form1
看懂了嗎?...
Read more.

[+/-] : 如何於VS2005使用RssToolkit

把RssToolkit.dll放到專案Bin目錄
下載檔案

在專案中引用此DLL


再來就可以在專案中用到這二個Controls, RssDataSource, RssHyperLink
RssDataSource用法
加入一個DataList和一個RssDataSource

到屬性RssDataSource內容更改
MaxItems要顯示的筆數，預設值為0，表示無限大
Url就是rss的位置或是Atom
這裡要注意一下，一般rss都有一個叫rss.xml的檔案
可是google的blog是用atom原本給的網址是
http://lovetoknowgoogleandmstech.blogspot.com/feeds/posts/default
不知為何，一定要改成下面這一個才可以成功被rsstoolkit control引用
http://lovetoknowgoogleandmstech.blogspot.com/feeds/posts/default?alt=rss

DataList裡面編輯樣板加入一個超連結
Text連繫到title, NavigateUrl連繫到link

完成圖

...
Read more.

[+/-] : 一些關於Silverlight 的新消息

微軟在2007/04/30更新了Silverlight官方網站，其網址如下：
http://silverlight.net/

Sliverlight 1.0 & 1.1下載網址：
http://www.microsoft.com/silverlight/downloads.aspx

雖然1.0和1.1版都還不是正式版，但是建議還是要漸進式學習，不要用跳躍式學習，因為中間斷層太多了，學起來也辛苦。簡單的說就是別再等了！...
Read more.

[+/-] : ASP.NET 2.0 圖片驗證

使用方法：
在需要它的頁面html裡添加
＜img src="identifyingcode.aspx" /＞
後端CS
HttpCookieCollection cookies = Request.Cookies;
string tmp = cookies["ImageV"].Value;
然後比tmp與獲取的較驗證碼文本框中的值是否相同
後端VB
Dim cookies As HttpCookieCollection = Request.Cookies
Dim tmp As String = cookies("ImageV").Value

此寫法雖然是cs寫法，但是用在vb專案直接叫用此頁面即可

identifyingcode.aspx

直接寫到identifyingcode.aspx.cs即可，前端不做任何事

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Drawing;
using System.Drawing.Imaging;
using System.IO;
public partial class identifyingcode : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string tmp = RndNum(4);
HttpCookie a = new HttpCookie("ImageV", tmp);
Response.Cookies.Add(a);
this.ValidateCode(tmp);

}
private void ValidateCode(string VNum)
{
Bitmap Img = null;
Graphics g = null;
MemoryStream ms = null;

int gheight = VNum.Length * 12;
Img = new Bitmap(gheight, 25);
g = Graphics.FromImage(Img);
//背景颜色
g.Clear(Color.LightSteelBlue);
//文字字体
Font f = new Font("Arial Black", 10);
//文字颜色
SolidBrush s = new SolidBrush(Color.RoyalBlue);
g.DrawString(VNum, f, s, 3, 3);
ms = new MemoryStream();
Img.Save(ms, ImageFormat.Jpeg);
Response.ClearContent();
Response.ContentType = "images/Jpeg";
Response.BinaryWrite(ms.ToArray());
g.Dispose();
Img.Dispose();
Response.End();
}

private string RndNum(int VcodeNum)
{
string Vchar = "0,1,2,3,4,5,6,7,8,9,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p" +
",q,r,s,t,u,v,w,x,y,z";
string[] VcArray = Vchar.Split(new Char[] { ',' });
string VNum = "";
int temp = -1;

Random rand = new Random();

for (int i = 1; i < rand =" new">

int t = rand.Next(35);
if (temp != -1 &&amp;amp;amp;amp;amp;amp; temp == t)
{
return RndNum(VcodeNum);
}
temp = t;
VNum += VcArray[t];
}
return VNum;
}

}

...
Read more.

[+/-] : 刪除IIS無用的ASP.NET 瀏覽時期產生的DLL暫存檔

刪除IIS無用的ASP.NET 瀏覽時期產生的DLL暫存檔

請於C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files 內的檔案刪除.

此資料夾是把ASP.NET於第一次瀏覽時產生之暫存DLL檔.

未避免暫存過多，佔用磁碟空間，請自行檢查與維護。

經筆者實際刪除結果，刪了200多M的空間，酷吧!


...
Read more.

[+/-] : VS2005專案同時使用C#與VB類別程式

步驟1:

在App_Code建立cs與vb資料夾

步驟2:

vb目錄裡面建立vbobj.vb內容如下
Imports Microsoft.VisualBasic

Public Class VBObject
Public Function Hello() As String
Return "Hi...VB"
End Function
End Class

cs目錄裡面建立csobj.cs內容如下
using System;

public class CSharpObject
{
public string Hello()
{
return "Hi...C#";
}
}

步驟3:

Web.config設定

步驟4:

前端頁面叫用
VB用法
'呼叫C#類別
Protected Sub btnCSharp_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnCSharp.Click
Dim myCSharpObject As New CSharpObject
txtMsg1.Text = myCSharpObject.Hello()
End Sub
'呼叫VB類別
Protected Sub btnVB_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnVB.Click
Dim myVBObject As New VBObject
txtMsg2.Text = myVBObject.Hello()
End Sub

CS用法　
//呼叫C#類別
protected void btnCSharp_Click(object sender, EventArgs e)
{
CSharpObject myCSharpObject = new CSharpObject();
txtMsg1.Text = myCSharpObject.Hello();
}
//呼叫VB類別
protected void btnVB_Click(object sender, EventArgs e)
{
VBObject myVBObject = new VBObject();
txtMsg2.Text = myVBObject.Hello();
}

...
Read more.

[+/-] : 如何為VS2005舊專案加上AJAX功能，修改Web.config就可以達成喔

步驟1:
首先為您的IIS SERVER安裝ASP.NET AJAX (Free Framework)，目前為v1.0的版本。
安裝很簡單，而且不用重新開機

步驟2:
打開vs2005舊專案的web.config

依照下面網頁的步驟即可

注意黑色大字的標籤不要copy到就行囉...
Read more.

[+/-] : Custom Paging in ASP.NET 2.0 with SQL Server 2005

比較50000筆資料1頁顯示10筆
1.使用一般的寫法
2.把用一般的寫法把cache打勾
3.用Custom Paging的寫法
每個寫法各跑5次並用ASP.NET Trace Results 看結果。

結論:
Custom Paging居然還比Cached快，因為Cached第1次為了要儲存資料到記憶體關係
Custom Paging會快要歸功於ROW_NUMBER()這個東東，而這個東東Oracle裡面也有
所以說，搭配VS2005內的ObjectDataSource和Oracle也可以做到一樣的效果囉!

原英文教學網址

筆者實作後中文詳細教學網址

...
Read more.

[+/-] : ASP.NET 2.0 如何使用標籤雲 Label Cloud

下載C#範例程式碼

你可以參考範例程式碼，或是依你現有的資料庫及網頁操作
我將示範如何使用VS2005客製化

1.首先將範例程式碼內Bin目錄下VRK.Controls.dll複制到你的專案Bin內

2.在Default.aspx頁面原始碼於<%@ Page Language 下方加上一行 如此才能使用Cloud Control <%@ Register Namespace="VRK.Controls" TagPrefix="vrk" Assembly="VRK.Controls" %>

3.使用Cloud Control和SqlDataSource1


SqlDataSource1我使用View，SQL語法如下
Select A.AlbumID
,B.Caption
,A.Weight
From
(
Select AlbumID,Count(PhotoID) Weight
From Photos Group by AlbumID
) A
inner join
(
Select * From Albums Where IsPublic = 1
) B ON A.AlbumID = B.AlbumID

搜尋出的資料內容如圖


頁面展示如下


如遇操作問題歡迎來問

...
Read more.

[+/-] : ASP.NET AJAX Video

ASP.NET AJAX is a free framework for quickly creating a new generation of more efficient, more interactive and highly-personalized Web experiences that work across all the most popular browsers.

With ASP.NET AJAX, you can:

• Create next-generation interfaces with reusable AJAX components.
• Enhance existing Web pages using powerful AJAX controls with support for all modern browsers.
• Continue using Visual Studio 2005 to take your ASP.NET 2.0 sites to the next level.
• Access remote services and data directly from the browser without writing a ton of complicated script.
• Enjoy the benefits of a free framework with technical support provided by Microsoft.

...
Read more.

[+/-] : Silverlight Light Up The WEB

Silverlight is a cross-browser, cross-platform plug-in for delivering the next generation of media experiences and rich interactive applications (RIAs) for the Web.

Limelight Networks
"High-performance is integral to our success and ongoing leadership as a content delivery network. With Microsoft Silverlight we're supporting a platform that will revolutionize the capabilities and experiences we can provide, using scalable and recognized technologies already deployed by our customers."...
Read more.