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

Page refresh

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="Scripts/jquery-2.1.1.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            setTimeout(function () {
                window.location.reload();
            }, 60 * 1 * 1000);
           
            //Page refresh after 40 min -
            //Example :- 60 * 40 * 1000
            //Format:-  60 * (minute) * 1000
        });
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
       <h1>Page refresh after 40 min </h1>
       <h2>
       Refresh Page 40 minute </h2>
       or
       <h3>Refresh Page for interval</h3>
       or
       <h4>Automatically reload a web page at a certain time</h4>
        <br />
       Or you can set value to refresh page
    </div>
    </form>
</body>
</html>

Continue reading


remove only html tags in a string 


var s = '<span>javascript</span> programming language'; 
var r = /<(\w+)[^>]*>.*<\/\1>/gi;
alert(s.replace(r,""))
Continue reading
Step 1:  Go to http://jquery.com/download/
Step 2:  Click the "Microsoft CDN"
Step 3:  Accrording to download your versinon like jquery version 1.10.0
Step 4:  Download the vsdoc file (jquery-1.10.0-vsdoc.js).
Step 5:  The -vsdoc.js or .debug.js file must be located in the same folder as the javascript library

Or you can download

http://archive.msdn.microsoft.com/KB958502/Release/ProjectReleases.aspx?ReleaseId=1736

Continue reading
Next PostNewer Posts Previous PostOlder Posts Home