Tag: tricks
How to Disable Browser Link in Visual Studio 2015 ?
Browser Link is one of the cool features in Visual Studio for the ASP.NET Developers. Sometimes , the web developers might want to disable this feature for various reasons. How to Disable Browser Link in Visual Studio 2015 ? There are 2 ways in which you can disable the Browser link in Visual Studio 2015. 1. Using Web.config file Just set the property vs:EnableBrowserLink value…
How to get the total number of items in a Enum in C# ?
If you want to get the total number of items that is defined in an enum using C# , you can use the Enum.GetNames static method combined with the Length property. How to get the total number of items in a Enum in C# ? Here’s a code sample demonstrating how to do it. This would display 3 in the console.
How to Declare and Define an double data type variable in F# ?
How to Declare and Define an double data type variable in F# ?
Deleting all the hidden rows and columns in the active worksheet using VBA
Do you want to delete all the hidden rows and columns in the active worksheet in Microsoft Excel using VBA ?. Here’s the code snippet that helps you to do it. How to delete all the hidden rows and columns in Active Worksheet using VBA in Microsoft Excel ?
FSharp Interactive Commands
FSharp Interactive UI includes few good number of commands which can be used by the F# Developers . Below are some of the FSI Commands which can be used by the developers. FSharp Interactive Commands Cancel Interactive Evaluation – This option cancels the execution of the FSI . Reset Interactive Session – This option resets the execution of the current FSI . Cut – This…
How to get specific columns from a Table in SQL Query ?
If you want to get the data from the specific columns from a table in your database , you can specify them in the query. For example, This would return the data of all the columns available in the Department table. If you want to get the data of the specific columns from the Department table , you can specify the column names in the…
How to Get the List of Appointments from the Calendar App in Windows Phone using C# ?
If you want to programmatically get the list of appointments from the calendar application of your Windows Phone device programmatically , you can use the Microsoft.Phone.UserData.Appointments. How to Get the List of Appointments from the Calender App in Windows Phone using C# ? Enable the ID_CAP_APPOINTMENTS in the WMAppManifest file and then create an instance of the Appointments class and call the SearchAsync method with…
How to get the table structure in SQL Server ?
To get the details of the table structure along with the indexes and the constraints , you can use the sp_help command as demonstrated in this blog post. How to get the table structure in SQL Server ?
UPDATE from SELECT query in SQL Server
Assume a scenario where you have a temporary table contains the data and would like to update a table using the values from the temporary table. Here’s an query demonstrating how to do it in SQL Server.
How to display Row Numbers in the results in SQL Query ?
If you want to return the row number as a part of your results in the SQL Query , you can use the ROW_NUMBER function and specify the ORDER BY clause to it as shown in this blog post. How to display Row Numbers in the results in SQL Query ?
How to Declare and Define an Long data type variable in F# ?
How to Declare and Define an Long data type variable in F# ?
Verify if the variable is a non-empty string in JavaScript
If you want to test if a variable that is defined is a non-empty string in JavaScript , you can use the typeof keyword to find if the type is a sring as well as check for the length of the string as shown below. How to verify if the variable is a non-empty string in JavaScript ? This will cause the else part to…