Blog Archives

Visual Studio String Functions-CSharp

string sHold = “”; int nIndex = 0; //Replaces a string with a specified string. sHold = “String Test”; sHold = sHold.Replace(“String”, “Replace”); //Returns “Replace Test” //Removes a specified number of characters from a string //The first number is the

Tagged with: , , , , ,
Posted in Visual Studio Code Examples

SQL NULLIF Function

NULLIF FUNCTION: Compares two values and does the following: Returns null if both values are the same. Returns the first value if both values are different. SQL Server: Select NULLIF(FIELD1, FIELD2) AS FIELD3 FROM TABLE; Oracle: Select NULLIF(FIELD1, FIELD2) AS

Tagged with: , , , , ,
Posted in Oracle, SQL Server

Reading from a Text File In Visual Studio C#

Create a new Windows Application Add a New form Add a textbox to the form; use the default name for the textbox. Make sure to change the Multiline Property of the textbox to True. After changing the Multiline Property of

Tagged with: , , , , , ,
Posted in Visual Studio Code Examples