Wednesday, March 26, 2014

Reset Visual Studio Windows if Windows Start opening in different panes

Windows:  ALT + W, R 
Menu:   Window | Reset Window Layout 
Command:  Window.ResetWindowLayout 
Versions:  2005, 2008, 2010, 2012, 2013 

Monday, March 10, 2014

LINQ Queries OR SQL checking Nothing or Null Values

You need to check if it's Nothing first and use the AndAlso keyword to stop it from evaluating the latter statement. Also, when checking if the and object is null, you should use the Is or IsNotoperator rather than =. This should work

Dim otherRecords As List(Of Objects) = listOf.Where(Function(x) _
                                                        (x.ID_NUM = newID) AndAlso _
                                                        (x.Codes IsNot Nothing) AndAlso _
                                                        (x.Codes.Contains(ddlPrimaryCode.SelectedItem.Text.Trim()))).ToList()

Tuesday, March 04, 2014

Stored Proc Place holder to be filled later example

SELECT

Field1,
Field2,
Field3,
' ' AS FieldName,
FROM tbl_name
WHERE field = @param


Later fill this with the data you need.