〔ASP.NET〕利用按鈕Command呼叫特定程式 / CommandName&CommandArgument Code Behind OnClick

不管是Button or LinkButton...皆有CommandName & CommandArgument屬性，可產生各別Click事件去傳遞值

若同一頁面上之Button皆有相同的行為，則可設定其OnCommand屬性來連結後端觸發事件，並利用CommandName & CommandArgument來傳遞設定值

例如：

前端程式碼

<asp: LinkButton ID ="lkb01" runat ="server" OnCommand ="FuncGo" CommandName="R1_001"></asp :LinkButton>

後端程式碼

Protected Sub FuncGo(sender As Object, e As CommandEventArgs)

    Select Case e.CommandName

        Case "R1_001"

            'do somthing

        Case Else

    End Select

End Sub

Read More

〔ASP.NET〕Page事件發生先後順序 / Page.Load,Master.Load

• ●一般情況下：
• 
  

Page.PreInit
Page.Init
Page.InitComplete
Page.PreLoad 

Page.Load 

控制項事件(例如：Button.Click、TextBox.TextChanged...)

Page.LoadComplete 

Page.PreRender 

Page.PreRenderComplete

Page.Render

Page.Unload

• ●使用了 MasterPage 情況， MasterPage 與 ContentPage 事件順序：
• 
  

ContentPage.PreInit
Master.Init 
ContentPage.Init
ContentPage.InitComplete
ContentPage.PreLoad
ContentPage.Load Master.Load 
ContentPage.LoadComplete
ContentPage.PreRender
Master.PreRender 

ContentPage.PreRenderComplete

參考：ASP.NET 網頁生命週期概觀

Read More

〔ASP.NET〕Convert sqlDataReader to DataTable / 將DataReader資料轉入DataTable

Dim dt As New DataTable

dt.Load(dr)        




範例：
        Dim Conn As SqlConnection = DBLink .setConn("ConnectionString" )

        Dim strSQL As String = ""

        Dim cmd As SqlCommand = Nothing

        Dim dr As SqlDataReader = Nothing

        Try

           

             strSQL = "SELECT * FROM Table"

            cmd = New SqlCommand(strSQL, Conn)

            dr = cmd.ExecuteReader

            If dr.HasRows Then

                Dim dt As New DataTable

                dt.Load(dr)

                Return dt

            Else

                Return Nothing

            End If

        Catch ex As Exception

            Return Nothing

        Finally

            PublicFunction.iniDispose(cmd, dr, Conn)

        End Try

Read More