function

  • MSSQL User Defined Functions vs Stored Procedures

    I received this question earlier today, and thought it was a valid question often misunderstood, and deserving of a small write-up: “Should a User Defined Function be your first choice instead of a Stored Procedure?” While there are many pros… Continue reading

  • mssql aes function encrypt decrypt in microsoft sql

    Simple symmetric encryption in MSSQL. Copied from MS references below: References: http://msdn.microsoft.com/en-us/library/bb669072.aspx http://msdn.microsoft.com/en-us/library/ms179331.aspx Continue reading

  • Non-static method requires a target

    In my specific situation where I received this error, I was able to resolve it by simply changing “null” to the object containing the method which needed to be call. This error indicates a use of reflections that can easily… Continue reading

  • call parent page from user control to invoke page methods

    To illustrate how we will accomplish this using Reflections, we will be using repeater in a user control within a page. Your repeater loads data easily within the user control code behind, but you want to utilize the “ItemCommand” event… Continue reading

  • Lambda Functions in .Net

    Lambda expressions in .Net are denoted by the ‘=>’ symbol. These powerful operators can be used to create sleek, optimized loops that perform much faster. The usage below condenses the equivalent of at least 20 lines of two loops. (Sorry… Continue reading