Truncate And Update Sql Database Web From In ASP.NET 2.0

I have two very simple stored procedures that truncate (clear out) the rows of my 'Transactions' table, then import rows from another table into it, thus updating the table with the appropriate data.

I would like to call these two stored procedures from a web form - asp.net 2.0 web page, using 2 buttons or possibly 1 button if I could, but can't find any information on how to do this.

here is code for:

1.  my button for 'truncate'

<asp:Button ID="Truncate" runat="server" Text="Truncate" style="left: 45px; position: relative; top: -2px" Font-Size="8pt" /><br />

2.  my stored procedure for 'truncate'

ALTER PROCEDURE dbo.TruncateTrans

AS

SET NOCOUNT ON;

Truncate Table Transactions;

 

2.  my button click event and page load event handler for the web form;

 

Imports System.Data

Imports System.Data.SqlClientPartial Class Admin_Default

Inherits System.Web.UI.PageProtected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

End SubProtected Sub Truncate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Truncate.Click

End Sub

End Class

 

Also, here is my other stored procedure called updateTransact.  how can i execute these using the web form and buttons?  or is there another way to do this?

 

ALTER PROCEDURE [dbo].[UpdateTransAct]

AS

BEGIN

SET NOCOUNT ON;

SELECT *

FROM Transactions INNER JOIN

UpdateTrans ON Transactions.TransID = UpdateTrans.TransID

INSERT INTO Transactions (Account, TransID, TransType, Transkind, Status, Amount, Transdate, Note, Ticker, TickerType, BaseDate, BasePrice, UnitPrice, Shares, UnitsPerContract, Commission, StopTypes, FixedValue, Strategy, WithHolding, SavUnitPrice, SavCommis, ReInvestDividends, ReInvestCapGains, StrategyType, OrderID, ReferenceID, Fees)

SELECT Account, TransID, TransType, Transkind, Status, Amount, Transdate, Note, Ticker, TickerType, BaseDate, BasePrice, UnitPrice, Shares, UnitsPerContract, Commission, StopTypes, FixedValue, Strategy, WithHolding, SavUnitPrice, SavCommis, ReInvestDividends, ReInvestCapGains, StrategyType, OrderID, ReferenceID, Fees

FROM UpdateTrans

WHERE (TransType= 'C' OR TransType='O')

ORDER BY TransDate

END

 

Any help would be appreciated.

Craig