how pass sp perametrs in sqlhelper

           SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spname", new SqlParameter("@username", txtuname.Text.ToString().Trim()));

change gridview checkbox color using javascript

 <script type="text/javascript">
        function changecolor(Id) {
            if (document.getElementById(Id).checked == true) {
                document.getElementById(Id).parentNode.style.backgroundColor = 'green';
            }
            else {
                document.getElementById(Id).parentNode.style.backgroundColor = 'red';
            }


        }
    </script>
</head>

onclick="javascript:changecolor(this.id)"

how get database table and no of rows in table

SELECT Name, DCount("*", Name) AS NumberOfRows
FROM MSysObjects
WHERE TYPE IN (1, 4, 6)
AND Name NOT LIKE "MSys*"
ORDER BY Name

exeption handling in sql

 BEGIN TRANSACTION
        BEGIN TRY
            -- Generate a Constraint violation Error.
            DELETE FROM IRCContactDetails
                    WHERE id = 6
        END TRY
        BEGIN CATCH
            SELECT
                    ERROR_NUMBER() AS ErrorNumber,
                    ERROR_SEVERITY() AS ErrorSeverity,
                    ERROR_STATE() AS ErrorState,
                    ERROR_MESSAGE() AS ErrorMessage

            IF @@TRANCOUNT > 0
                    ROLLBACK TRANSACTION;                   
        END CATCH;
       
        IF @@TRANCOUNT > 0
            COMMIT TRANSACTION;

how get max id in sql

            SELECT ISNULL(MAX(ISNULL(id, 0)), 0) + 1 FROM temp2