EugeneChiang.com

C# Patch String

C# Format DateTime

Format Result .ToString(“MMMM dd, yyyy”) June 10, 2011 .ToString(“MM/dd/yyyy”) 05/09/2019 .ToString(“hh:mmtt”) 12:00AM .ToString(“hh:mm:ss tt”) 6:09:01 PM Format Result DateTime.Now.ToString(“MM/dd/yyyy”) 05/29/2015 DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 05:50 DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015 05:50 AM DateTime.Now.ToString(“dddd, dd MMMM yyyy”) Friday, 29 May 2015... » read more

SQL Server Type: money vs smallmoney

Data type Range Storage money -922,337,203,685,477.5808 to 922,337,203,685,477.5807 (-922,337,203,685,477.58to 922,337,203,685,477.58 for Informatica. Informatica only supports two decimals, not four.) 8 bytes smallmoney – 214,748.3648 to 214,748.3647 4 bytes The money and smallmoney data types are accurate to a ten-thousandth of the monetary units that they represent. For Informatica, the money and smallmoney data types are accurate to a one-hundredth of the monetary units... » read more

Power BI: Show Items With No Data

To enable the Show items with no data feature select a visual, then in the Fields well, right-click the field and select Show items with no data from the menu that appears, as shown in the following image: Sources: https://docs.microsoft.com/en-us/power-bi/desktop-show-items-no-data

C# Format Decimal

Mask Format .ToString(“0.00”) X.XX .ToString(“C2”) $X,XXX.XX Source: https://docs.microsoft.com/en-us/dotnet/api/system.decimal.tostring?view=netframework-4.8

TransactionScope

Makes a code block transactional. Source: https://docs.microsoft.com/en-us/dotnet/api/system.transactions.transactionscope?view=netframework-4.8

Sum of DataTable Column

Power BI: Disable Filter Panel

Disable Filter Panel from displaying on the reports. File -> Options & Settings In report edit, you will now see this panel…

Adding Error Handling and Transaction to Stored Procedure

Error Handling Error Handling with Transaction

Passing Table Type to Stored Procedure

User-Defined Table Types Stored Procedure Code Note: Need to make sure the type type has the right access permissions.