Mouce over in certin button

Buttaon1.Attributes.Add("onMouseOver","someClientCode();");

now you can add the code inside the JavaScript function of someClientCode()

Asp.net timer control

Asp.net timer control
Asp.net timer control sample
http://forums.asp.net/t/1330209.aspx

ChangeApprovalStatus in sqlserver

USE [TEMPDB]
GO
/****** Object: StoredProcedure [dbo].[ChangeApprovalStatus] Script Date: 11/25/2008 09:55:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[ChangeApprovalStatus]
@strCompanyXML xml
AS
SET NOCOUNT ON

DECLARE @XMLDocPointer INT
DECLARE @RowCount INT
DECLARE @Error INT
DECLARE @Msg VARCHAR(100)

IF EXISTS ( SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[#tmpCompaniesXML]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].#tmpCompaniesXML

CREATE TABLE #tmpCompaniesXML(CompanyID VARCHAR(10))

IF @strCompanyXML IS NOT NULL
BEGIN
EXEC sp_xml_preparedocument @XMLDocPointer OUTPUT, @strCompanyXML
INSERT INTO #tmpCompaniesXML
SELECT * FROM OPENXML(@XMLDocPointer,'/root/company')
WITH (
[id] [varchar](10)
)
EXEC sp_xml_removedocument @XMLDocPointer
END

BEGIN TRANSACTION TRAN_UPD_TRKG

UPDATE T_Tracking
SET IsSFE=0,IsSynchronised=0
WHERE CompanyID IN (SELECT CompanyID FROM #tmpCompaniesXML)

SELECT @RowCount=@@ROWCOUNT,@Error=@@ERROR

IF @Error != 0 OR @Rowcount = 0
BEGIN
ROLLBACK TRANSACTION TRAN_UPD_TRKG
SET @Msg = 'Unable to update entry in T_Tracking'
RAISERROR(@Msg,16,1)
RETURN 0
END

SELECT @RowCount

COMMIT TRANSACTION TRAN_UPD_TRKG

IF EXISTS ( SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[#tmpCompaniesXML]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].#tmpCompaniesXML

RETURN 1

delete with stored procedure in sqlserver

USE [RICH]
GO
/****** Object: StoredProcedure [dbo].[sp_deleteCohort] Script Date: 11/25/2008 09:53:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

CREATE PROCEDURE [dbo].[sp_deleteCohort]
@cohort as varchar(50)
AS
BEGIN
DELETE FROM RICHS2K8
WHERE
Cohort=@cohort
END

Opening a an aspx page in a new window.

Button1.Attributes.Add("onclick","window.open('Popup.aspx');return false");

or

Page.ClientScript.RegisterStartupScript(this.GetType(),"open","window.open('Popup.aspx');",true);