I have found that if my textbox control is set to ReadOnly= True at design time, I can change the forecolor programmatically without a hitch.
If my textbox control is set to ReadOnly = False at design time, and then …
Author: James
Creating a system image of your hard drive for Windows 8
1) Attach an external USB hard drive to your computer.
2) Bring up Windows Explorer.
3) Copy and the paste the following into the Windows Explorer address bar and Control PanelAll Control Panel ItemsWindows 7 File Recovery
4) Then click …
SQL Server – How to copy data value in column from one table to another
update a
set a.some_column = b.some_column
from some_database.dbo.some_table a
JOIN some_database.dbo.some_table b ON
a.some_column = b.some_column
where a.some_column = 'some_value'… SQL Server Reporting Services (SSRS) – Convert string into Proper (Camel/Pascal) Case (Capitalize each word in string)
=StrConv("JOHN DOE", vbProperCase)
This now becomes John Doe…
SQL Server – Case-Sensitive search in SQL
If your sql server is installed with the default collation of case-insensitive, you can accomplish this in sql instead.
You can determine if your installation collation is case-insensitive by running this query:
SELECT SERVERPROPERTY ('Collation')
GO
If the result is …
SQL Server Reporting Services (SSRS) – Alternate row colors with no group, 1 group, or multiple groups
In order to do alternate row coloring for an SSRS report that has grouping, you need an expression for your BackgroundColor property different than the typical:
=iif(rownumber (nothing) mod 2 = 0, "LightGrey", "White")
You can use the following expression …
SQL Server – Turning a Comma Separated string into individual rows
Let’s say you have a column in a table that is comma delimited. The value in the column is ‘APPLE, ORANGE, GRAPE’. You want to break down this string value into individual rows. You may also want to create an …
FileSeek – Clear LastUsed data in registry
In Regedit:
HKEY_CURRENT_USERSoftwareMicrosoftBinary Fortress SoftwareFileSeek
Remove all the data inside the Multi-String values that start with LastUsed.
…
Microsoft Visual Studio – Clear Find and Replace window history
In Regedit:
HKEY_CURRENT_USERSoftwareMicrosoftVisualStudio[Version Number}Find
Remove all keys that starts with Find and Replace, like Find1, Find2, Replace1, etc. You can remove history for Findonly or Replace only, or remove only particular Find…
SQL Server Management Studio – Clear Find and Replace window history
In Regedit:
For SQL Server 2005 :
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\Find
For SQL Server 2008 :
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\Find
For SQL Server 2012 :
HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0\Find
Remove the Find and Replace items.…