TSQL –all tables and rowcount (in descending order by count) select ‘[‘+SCHEMA_NAME(t.[SCHEMA_ID])+’].[‘+t.NAME+’]’ AS [fulltable_name], SCHEMA_NAME(t.[SCHEMA_ID]) as [schema_name],t.NAME as [table_name] ,i.rows from sys.tables t INNER JOIN sysindexes i ON (t.object_id = …
Sort an array of objects by date Given the class below: public class MyClass { public int id; …
In C# you can draw a shape on any control. For example: System.Drawing.SolidBrush b = new System.Drawing.SolidBrush(Color.Blue); System.Drawing.Graphics g = System.Drawing.Graphics.FromHwnd(control.Handle); float width = 50; float height = 25; g.FillRectangle(b, …
Generate a random integer in C# private static readonly Random random = new Random(); private static readonly object lock_random = new object(); public static int GetRandomNumber(int min, int max) { …
To change the oil in a 2009 Ford F-150 you need: Oil filter removal wrench 5/8 inch socket 7 quarts 5w-20 engine oil Oil Filter Oil catch pan Rags Funnel …
To replace the starter on a 1995 Honda TRX300 4 Wheeler you will need: Starter 10 MM socket Two large screw drivers (for gently prying) A phillips screwdriver A long …
Various serialization functions public static string SerializeObject(object obj) { if (obj == null) { return string.Empty; } System.Xml.Serialization.XmlSerializer serializer = new System.Xml.Serialization.XmlSerializer(obj.GetType()); string s …
