Cannot Drag Windows Explorer to Another Monitor

Problem: Windows Explorer window cannot be dragged to another monitor.

Solution:  Turning Snap feature off and then back on solved the issue.   

• Right-click on your desktop
• Select Display Settings > Multitasking > Snap
• Slide Snap to off and then back on again. I have the remaining three options turned on also. 

Turn Snap feature off if that doesn't work. 

Visit www.BlueCanyonSoftware.com if you need custom software development.

RadWindowManager in User Control Can Cause Confusion

I had a RadWindowManager in a user control that was loaded dynamically in an aspx page which also had it's own RadWindowManager.   So now there are two RadWindowManagers on the page after the user control was loaded. 

The following comes from a post at a Telerik forum:

1. the radopen() function can be used only when a RadWindowManager is declared on the page.
2. If there are multiple RadWindowManagers on the page, radopen() will use the first rendered manager. 

Visit www.BlueCanyonSoftware.com if you need custom software development for your business. 

C# Language Specification

The C# language specification is available online and may even be on your hard drive right now. 

Visit www.BlueCanyonSoftware.com if you need custom software development.

RadGrid NoRecordsTemplate Not Showing

Add a NoRecordsTemplate setting to the MasterTableView of your Telerik RadGrid to provide an informative display when your grid DataSource has no records.
The NoRecordsTemplate will only show when your grid DataSource indicates there are no records.

I prefer to initialize the grid DataSource to empty at the start of the NeedDataSource event handler and replace the DataSource value if data is available for the grid.

For example, I use the following line to set myGrid DataSource to indicate no records.
     myGrid.DataSource = new object[0]{};




Contact Blue Canyon Software if you need custom software development for your business.

Performance Tuning for ASP.NET

Found a good article at c-sharpcorner.com  with lots of suggestions for improving performance of an ASP.NET web site.      Click this link to see the article. 

Visit www.BlueCanyonSoftware.com if your business needs custom software development.

Case Insensitive SQL Search for Missing Values in Another Table

Problem: 

You need to compare two tables to find values in one table that are missing in the other table.   SQL server default is case insensitive so if "Dog" is in table A and "DOG" is in table B there is a match.    

Solution:  

You need to set the COLLATE value to get your desired result of a case sensitive comparison. 

We will compare two tables,  The graniteRequested table has a 'Color' column.  The colorGranite table has a 'color' column.   

This SQL query will look for colors that are in the graniteRequested table but not in the colorGranite table. 

SELECT DISTINCT gR.Color   

  FROM graniteRequested gR

  WHERE gR.Color NOT IN 

  (SELECT colorGranite.color   Collate SQL_Latin1_General_CP1_CS_AS   FROM colorGranite)

 Collate SQL_Latin1_General_CP1_CS_AS   makes this a case sensitive search. 

Visit www.BlueCanyonSoftware.com if you need custom software development for your business.

List SQL Server Database Tables and Columns

Query for Showing All Tables and Columns in Your Database

Do you need a list of all the tables in your database and their columns?

Use SQL Server Management Studio to connect to your database.   Execute this query, substituting your database name in the USE statement.


USE YOUR_DATABASE_NAME;
SELECT OBJECT_SCHEMA_NAME(T.[object_id],DB_ID()) AS [Schema],
        T.[name] AS [table_name], AC.[name] AS [column_name],
        TY.[name] AS system_data_type, AC.[max_length],
        AC.[precision], AC.[scale], AC.[is_nullable], AC.[is_ansi_padded]
FROM sys.[tables] AS T
  INNER JOIN sys.[all_columns] AC ON T.[object_id] = AC.[object_id]
 INNER JOIN sys.[types] TY ON AC.[system_type_id] = TY.[system_type_id] AND AC.[user_type_id] = TY.[user_type_id]
WHERE T.[is_ms_shipped] = 0
ORDER BY T.[name], AC.[column_id]


Right-click on the query results grid and select "Save Results As..."
Choose the .csv file format so you can open the file in Excel.

---

Visit www.BlueCanyonSoftware.com if you need custom software development for your business.