Techie's Diary

There have been requirements where we need to bind ListControl from enum (with enum Description as Text and enum value as Value). For example I have an enum of Countries as follows: public enum TestCountries {     [ Description ( "India" )] India = 1     ,     [ Description ( "United State Of America" )] UnitedStateOfAmerica = 2     ,     [ Description ( "United Kingdom" )] UnitedKingdom = 3 } And I want to bind this enum’s description and value to any list control. Here I am writing a static method “LoadListForListControls<T>”, which will take Enum as T, and then return list of ListItem. // We need to use following namespaces for this method: using System; using System.Collections.Generic; using System.ComponentModel; using System.Linq; using System.Reflection; using System.Web.UI.WebControls; public static List < L...

$(document).ready():- Jquery $(document).ready()  function called once the DOM (Document object model) is loaded on your page. DOM means the entire html tags/script (i.e. div, table, paragraph etc.). If your web page has large images, it will not wait for loading of images completely. This method is used when we want to initialize our jQuery codes after the DOM is ready. $(document).ready( function (){   // method called as soon as DOM is ready }); window.onload()/load() method:- The load event fires when all the content on your page loaded including the DOM (document object model) and images. This method gets called when images and all associated resources including the DOM (document object model) of the page have been fully loaded. Suppose your web page has large size images then until all the images are not fully loaded on the page, this method will not called. $(window).load( function () {     //this method called a...

Following are the differences between DELETE and TRUNCATE: TRUNCATE DELETE TRUNCATE is DDL Statement DELETE is a DML command TRUNCATE cannot have WHERE Conditions DELETE can have WHERE conditions TRUNCATE does not fire trigger DELETE Fires TRIGGER TRUNCATE reset the identity to 0 (if table have any) DELETE does not RESET Identity TRUNCATE Release the table’s spaces to System DELETE removes the records but will not release the space to the system TRUNCATE cannot be used against the table that is referenced by a FOREIGN KEY constraint. DELETE can be used in tables reference by a Foreign Key and tables involved in Indexed view TRUNCATE cannot be used against the table used in Indexed view DELETE can be used against the table used in Indexed view TRUNCATE apply Fewer table locks DELETE apply more locks to the table TRUNCATE cannot be...

If you have Guid values in a string separated by a comma and want to convert all comma-separated GUIDs to a list of GUID then here is a single line code that will do the trick. private List < Guid > GetSelectedIdList( String selectedIds) {     return Array .ConvertAll(selectedIds.Split( ',' ),  delegate ( string s) { return new Guid (s); }).ToList(); } Or you can rewrite the same method with the help of lambda expression as: private List < Guid > GetSelectedIdList( String selectedIds) {     return Array .ConvertAll(selectedIds.Split( ',' ), s => new Guid (s)).ToList(); } Just pass the comma separated string and “GetSelectedIdList” method will return list of GUID.

Here I am writing some of coding standard and best practices one should follow while working with database. You can also check for Query Optimization and SQL Tunning ·          Use Pascal notation for SQL server Objects like Tables, Views, Stored Procedures. Also tables and views should have ending “s”. For example: UserDetails etc. Check naming convetion table given below for more details. ·          If “One Table” references “Another Table” than the column name used in reference should use the following rule: Column of another Table: <FirstTableName> Id ·          If you have big subset of table group than it makes sense to give prefix for this table group. Prefix should be separated by _. For example: meeting_Users, meeting_Attendee etc.       SQL Object      Pattern      Example ...

jQuery is an extremely powerful library that provides all the tools necessary to create beautiful interactions and animations in web pages, while empowering the developer to do so in an accessible and degradable manner. Here I'll write some of best practices one should use while working with client side scripting. ·          If you are registering script files through code behind, its good practice  to register all javascript/jquery files on page_init, and if you need to register on the fly scripts from code behind then register those scripts in PreRenderComplete event. ·           Use the jQuery shorthand $ where possible:     $( function () { ... }); instead of $(document).ready( function () { ... }); ·          Use a document ready event in place of window onload. The handler for the document ready event must be a...