Tag: tips

How to Get the List of Appointments from the Calendar App in Windows Phone using C# ?

AbundantCode 1 year ago in C# 0

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…

Anonymous Types are read-only in C#

AbundantCode 1 year ago in C# 0

If you try to set a value to the anonymous type in C# , you will receive an compiler error . The properties within the anonymous types are read-only properties. Anonymous Types are read-only in C# In the above code snippet , you will receive an compiler error “Error    CS0200    Property or indexer ‘<anonymous type: string FirstName, string Last>.FirstName’ cannot be assigned to — it…

Undefined reference to `pow’ when compiling C program

AbundantCode 1 year ago in C 0

When trying to make a simple program in C and compiling it , there are times when you might get an error that you are missing the pow function when you have used them inspite of including the math.h header file. The error message looks like this. undefined reference to ‘pow’ collect2: error: ld returned 1 exit status How to fix the error undefined reference…

Verify if the variable is a non-empty string in JavaScript

AbundantCode 1 year ago in JavaScript 0

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…

How to handle Null Column values of SQLDataReader in C# ?

AbundantCode 1 year ago in C# 0

If you want to handle the Null column values of the sqldatareader object in C#, you can use the SqlReader.IsDBNull method to validate for it. If the SqlReader.IsDBNull returns true then , the value is considered to be a null value and you can take the ction accordingly. How to handle Null Column values of SQLDataReader in C# ?

How to Get a value to a Variable in SQL Server ?

AbundantCode 1 year ago in SQL Server 0

When you use the declare a variable using the DECLARE statement. The same variable can be used to store a value retrieved from the database and later can be used in your SQL Query. How to Get a value to a Variable in SQL Server ? For example , you want to retreive the value of the column JobTitle and store it in the variable…

How to return the SHA1 hash value of a string in SQL Server ?

AbundantCode 1 year ago in SQL Server 1

SQL Server provides a function HashBytes function that returns the SHA1 , MD2 , MD4 and few other hash value of the specified input. How to return the SHA1 hash value of a string in SQL Server ? Just pass the ‘SHA1’ as the first parameter and the input as second parameter value to the HashBytes function to get the SHA1 hash value.