[MSSQL]ALTER TABLE 新增修改刪除欄位語法
新增欄位: ALTER TABLE table_name ADD column_name datatype 刪除欄位: ALTER TABLE table_name DROP COLUMN column_name 修改欄位型態： ALTER TABLE table_name ALTER column_name datatype
發表文章
目前顯示的是 9月, 2014的文章
[ASP.NET] 繁簡直接轉換
- 取得連結
- 以電子郵件傳送
- 其他應用程式
繁轉簡 ''' ''' 覆寫 Render 方法做繁轉簡的動作。 ''' Protected Overrides Sub Render(ByVal writer As System.Web.UI.HtmlTextWriter) Dim HtmlStr As String Dim oStringWriter As New StringWriter() Dim oHtmlWriter As New HtmlTextWriter(oStringWriter) MyBase.Render(oHtmlWriter) oHtmlWriter.Flush() oHtmlWriter.Close() '取得網頁的輸出內容做繁體中文轉簡體中文的動作 HtmlStr = StrConv(oStringWriter.ToString(), VbStrConv.SimplifiedChinese, 2052) Response.Write(HtmlStr) End Sub 簡轉繁 VbStrConv.TraditionalChinese, 2052
[ASP.NET] ashx(泛型處理常式)中存取Session(工作階段變數)
- 取得連結
- 以電子郵件傳送
- 其他應用程式
原本的ashx Imports System <%@ WebHandler Language="VB" Class="Handler" %> Imports System Imports System.Web Public Class Handler : Implements IHttpHandler Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest context.Response.ContentType = "text/plain" context.Response.Write("Hello World") End Sub Public ReadOnly Property IsReusable() As Boolean Implements IHttpHandler.IsReusable Get Return False End Get End Property End Class