Partial Methods in C#

All of us know that partial type allows us to split definition of type across multiple files but do you know C# also provides supports for partial methods too. Partial methods are used when your code is auto generated by code generation tool. The tool will write only method definition and leave the implementation of for developer if they want to customize.

OnClientClickevent and AJAX is not working for telerik RadControls

One may need to provide a confirmation dialog or check some validation to the users and initiate an AJAX request if confirmation accepted or validation perform successful. Confirmation using standard post backs often looks like this: 

<asp:Button ID="btnSaveComplaint" runat="server" Text="Save" OnClick="btnSaveComplaint_Click" OnClientClick="return ValidateMacroText();" /> 

 Note: ValidateMacroText() is javascript function which returns true if validation perform successfully.

SQl Server Tricks-Part2

Get list of all procedures created on a particular date in a database

To get the list of all the procedures created on a particular date in a data base, you can use this query.

Use YourDBName
Go
select name from sys.objects
where type = 'P'
and create_date=@yourdate
Go

SQl Server Tricks-Part1

Getting the List of all databases on a server

To get list of all database on a server, you can use this query.

USE master
GO
SELECT *
FROM sys.Databases
GO

OR you can use the sp_helpdb procedure for this.

Getting Information About Object's Type

You can get the information of type of the any object by calling the GetType method of System.Object. Because every type in .Net inherits directly or indirectly from System.Object, every object will have access to the GetType method.

GetType returns an instance of a Type object, which can be queried to learn all about the type of the original object.