5:13 AM

Use of var

posted by Web tricksin defaultvar0 comments

 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 [.....]

Continue reading

4:06 AM

Override element.style or change element.style

posted by Web tricksin CSS0 comments

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

3:29 AM

Jquery Autocomplete close button (close function)

posted by Web tricksin javascriptjQuery0 comments

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 [.....]

Continue reading

6:08 AM

last executed stored procedure in sql server

posted by Web tricksin Sql Server0 comments

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