var List1 = (IEnumerable<XElement>)null;

 var List2 = (IEnumerable<XElement>)null;

 var List3 = (IEnumerable<XElement>)null;

 var List4 = (IEnumerable<XElement>)null;

  

 var List1 = default(null);

 var List2 = default(null);

 var List3 = default(null);

 var List4 = default(null);

 var List1 = (string)null;
 var List2 = (string)null;
 var List3 = (string)null;
 var List4 = (string)null;

We can define var as null , with  typecasting when we already know the type of object which we want to store  further in our code, or when we are not sure of the object we want to store we can use default(null) to define the that variable.

 XmlNodeList List2 = default(XmlNodeList);
 XmlNodeList List3 = default(XmlNodeList);
 XmlNodeList List4 = default(XmlNodeList);
 XmlNodeList List5 = default(XmlNodeList);

Continue reading

Override element.style or change element.style

if you display like this:

element.style 
{
display:none;
}

you can apply !important

display: inline !important;

Continue reading

Step 1:

 <div>
           <label for="tags">Tags: </label>
            <input id="tags" />
 </div>

Step 2:

<script>

var sourcedata = [
    "asp.net",
    "Asp",
    "BASIC",
    "C",
    "C++",  
    "COBOL",
    "Fortran",
    "Java",
    "JavaScript",
    "Lisp",
    "Perl",
    "PHP",
    "Python",
    "Ruby",
    "Scala",
    "Scheme"
    ];
$("#tags").autocomplete({
    source: sourcedata,
    open: function (event, ui) {

            var adddiv = $("<div style=\"width: auto; background: #f5f5f5;border-top: 1px solid #c7c7c7;margin-top: 0.92307692em; padding: 0 0.46153846em;overflow: hidden;\"> Close</div>", {

            });
        adddiv.click(function () {
            $(event.target).autocomplete("close");
        });
        $(this).autocomplete("widget").append(adddiv);
    }  
   
});

</script>

Continue reading

Hi,

very useful procedure help of  sys.dm_exec_procedure_stats.

SELECT TOP 10 d.object_id, d.database_id, OBJECT_NAME(object_id, database_id) 'proc name',
    d.cached_time, d.last_execution_time, d.total_elapsed_time,
    d.total_elapsed_time/d.execution_count AS [avg_elapsed_time],
    d.last_elapsed_time, d.execution_count
FROM sys.dm_exec_procedure_stats AS d
ORDER BY [total_worker_time] DESC;
--------------------------------------------------------------------------------------------

Step 1:

SELECT DB_ID(N'yourdatabaseName') AS [Database ID];

Step 2:

SELECT TOP 10 d.object_id, d.database_id, OBJECT_NAME(object_id, database_id) 'proc name',
    d.cached_time, d.last_execution_time, d.total_elapsed_time,
    d.total_elapsed_time/d.execution_count AS [avg_elapsed_time],
    d.last_elapsed_time, d.execution_count
FROM sys.dm_exec_procedure_stats AS d
where database_id= DB_ID(N'yourdatabaseName')
ORDER BY [total_worker_time] DESC;


more help :-
https://msdn.microsoft.com/en-us/library/cc280701.aspx

Continue reading