[MSSQL] 重設資料表自動遞增數字

重設資料表自動遞增數字

DBCC CHECKIDENT (MyTableName, RESEED, 0)


Reference:

• MS SQL resetting the auto increment
• How to restart the AUTOINCREMENT number for a table in Microsoft SQL 2008?

[Silverlight] 程式端控制 Domain Service 讀取

xxxDomainContext dc = new xxxDomainContext();
dc.Load(dc.xxxQuery());
myControl.ItemsSource = dc.EntityName;

參考文件: Project Turing: Beginning RIA Services

[Silverlight] 取得文件路徑/參數/檔案路徑

使用 HtmlPage 需匯入命名空間: System.Windows.Browser

取得網頁路徑: HtmlPage.Document.DocumentUri.ToString()

取得參數: HtmlPage.Document.QueryString["param"]



取得 Silverlight 應用程式路徑: Application.Current.Host.Source.AbsoluteUri.ToString()

[iPhone] How To Make An iPhone App.

iPhone 4 is coming up soon. Would you like to develope some iPhone apps on your own? Below is a useful resource I found recently~ Hope this helps!

Learn how to develop an iPhone app that people will buy even if you never programmed before!

[Silverlight 4] 列印功能

1. 引入 namespace
System.Windows.Printing

2. 建立 PrintDocument
3. 建立對應 Event

• BeginPrint
• EndPrint
• PrintPage - e.PrintVisual (指定列印目標物件), 確認 e.HasMorePages (是否有多頁)

4. 最後指定 PrintDocument 物件 Print 的文件名稱
Print("MyDocument")

[ASP.NET] 轉換 ArrayList 至字串陣列

VB:

Dim str() As String = arrList.ToArray(GetType(String))

C#:

string[] strings = (string[])arrList.ToArray(typeof(string));

[ASP.NET MVC] 在 View 中取得 Controller 名稱

ViewContext.RouteData.Values["controller"].ToString()

References:
ASP.NET MVC - Current Action