Update Record Upper / Lower Case
Upper Case Lower Case
-
-
-
Code | CSharp | JavaScript | PHP | PowerShell | VB | VB.NET
New Line
Often we forget what code we need to use to create a new line (line break), hopefully this will help. n = CR (Carriage Return) Used as a new line character in Unix r = LF (Line Feed) Used as a new line character in Mac OS nr = CR + LF Used as a…
-
Filter Datagrid
If you already have a data grid and want to search it you can create a textbox and do a textbox.textchanged control to run something like below:
-
Check For Valid Date
Recently I had to validate dates in a form specifically the date of visit and date of birth This function will now check both for future date and do more checks for the date of visit, debug/helper information left in to better understand the function. Function Code: Function Use:
-
-
Visual Studio Oracle Tools
When working with Visual Studio and Oracle you will need to download Oracle’s Visual Studio Tools. Code Samples: http://www.oracle.com/technetwork/articles/dotnet/cook-dotnet-101788.html If I thought I could legally host the file I would. Official Page: http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html If the link fails to work do a search on http://www.oracle.com/ for Visual Studio ODAC 11.2 Release 5 and Oracle Developer Tools…
-
Show Duplicate Records
These two queries run under different schools of thought and purpose but will help in finding duplicate records. First, if you only want to see the records that are duplicates and the amount of times they appear in the table you could run this code: Second, if you want to see all duplicate records along…
-
-
Column Name Search
An extension of Table/View Column Information In the event that you need to find a table that has a specific column name.