how to | Developer Publish

Json.NET How to #2 – Convert a simple JSON string to C# object a...

December 6, 2019 no comments

Problem: You want to convert a simple JSON string to a C# and vice versa object using Json.NET. Solution Use the JsonConvert class that is available as part of Json.NET library. The JsconConvert prov...

Fix – Sqllib error: OLEDB Error encountered calling IDBInitializ...

October 15, 2019 no comments

Are you facing the below error in SQL Server and looking for a fix ? Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17 Here&#...

How to get the List of AD Groups that a user is member of using PowerS...

August 28, 2018 no comments

Assume that you have a userid which is part of Active Directory and you would like to get the list of all the active directory groups in which the specified user is a member of. You can do this easil...

How to read the entire contents of a file to a string variable in C# ?...

March 10, 2017 no comments

There are several ways in which you can read a text file in to a string variable in C#. One of the simple ways to achieve it is using the ReadAllText method of the File class. How to read the entire ...

How to calculate difference between two dates in C# ?

March 10, 2017 no comments

There are times when you might to calculate the difference between two days in C# and get the number of days as result. How to calculate difference between two dates in C# ? Assuming both the start d...

C# Tips and Tricks #1 – Get the Total Number of Items in an Enum...

February 15, 2017 no comments

You can get the total number of items defined in an enum in C# using the combination of the Enum.GetNames method and the Length property. How to get the Total Number of Items in an Enum in C# ? The s...

How to disable the research task pane in Microsoft Excel?

January 25, 2017 1 comment

In Microsoft Excel 2016 , when you press the Alt Key and simultaneously click a cell in the worksheet , a research pane would appear at the right hand side of the sheet. There are times when you woul...

How to wrap text using Wrap Text Command in Excel ?

December 25, 2016 no comments

Microsoft Excel provides the Wrap Text command that lets the users to quickly wrap long sentences and lets the users view the full content of the cell easily. How to wrap text using Wrap Text Command...