Oracle Managed Driver
1). Launch Visual Studio and install OMD – Click Tools > NuGet Package Manager > Package Manager Console – Type: Install-Package Oracle.ManagedDataAccess – Locate the dll Oracle.ManagedDataAccess.dll and copy it …
Parsing VSS History Files
Parse those nasty VSS history files. Put them in a format more suitable for Gource. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.IO; namespace ConsoleApplication2 { …
Customize XtraReport with C#
Use the scripts window of the report designer private void lblAccountName_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) { XRLabel l = (XRLabel)sender; string s = l.Text; s = TitleCaseString(s); l.Text = s; } …
Convert RTF data to unmarked up string
static public string ConvertToText(string rtf) { using(RichTextBox rtb = new RichTextBox()) { rtb.Rtf = rtf; return rtb.Text; } } Catch ArgumentException …
Parse Simple XML C#
string s @="<?xml version=""1.0"" encoding=""utf-8"" ?><Parent><Plate>ABC123</Plate></Parent>"; XmlDocument x = new XmlDocument(); x.LoadXml(s); XmlNode rootnode = x["Parent"]; if ((rootnode != null) && (rootnode.HasChildNodes)) { XmlNodeList nodes = rootnode.ChildNodes; …
VS2005 Build Warning “libbmt.pdb was not found”
Build Error in Visual Studio 2005: LIBCMT.lib(gshandler.obj) : warning LNK4099: PDB ‘libbmt.pdb’ was not found with ‘C:\Program Files\Microsoft Visual Studio 8\VC\ce\lib\ARMV4I\LIBCMT.lib’ or at ‘c:\Source\AIMS Ticketer 4\Release\libbmt.pdb’; linking object as if …
Serialization C#
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 …
SMTP email through Microsoft 365 via C#
An example of how to use the System.Net namespace to send emails (useful for ssl or tls mail servers). SmtpClient server = new SmtpClient("Smtp.mail.microsoftonline.com"); server.Port = 587; server.EnableSsl = true; …
C# convert string to enum
enum Colour { Red, Green, Blue } // … Colour c = (Colour) Enum.Parse(typeof(Colour), "Red", true); …
.Net special characters within strings cause Oracle problems
Without the string replaces, running this string against an Oracle database will result in the procedure getting created, but with a compile error. string s = @" create or replace …