VB.NET 呼叫不傳參的 Stored Procedure

Public Function ExeSpFtripDays()

        Dim Conn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))

        Dim Comm As SqlCommand



        Comm = New SqlCommand("sp_FtripDays", Conn)   /** sp_FtripDays 為Stored Procedure的名稱 **/

        Conn.Open()

        Comm.ExecuteNonQuery()

        Comm.Connection.Close()

        Conn.Close()

End Function





要執行Stored Procedure時，宣告個 clsData 物件去呼叫該函式

Dim obj As New clsData

obj.ExeSpFtripDays()

Read More