Windows: ALT + W, R
Menu: Window | Reset Window Layout
Command: Window.ResetWindowLayout
Versions: 2005, 2008, 2010, 2012, 2013
This blog is about my history as a software engineer utilizing technologies C#, Java, React, JavaScript, .NET Core, SQL Server , Oracle, GIT, GitHub, Jira, Azure, AWS and HTML5. “I have not failed. I've just found 10,000 ways that won't work.” Thomas A. Edison. Please click on all my ADVERTISING links to help support this blog. Thank you.
Wednesday, March 26, 2014
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 IsNot
operator rather than =
. This should workDim 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.
Field1,
Field2,
Field3,
' ' AS FieldName,
FROM tbl_name
WHERE field = @param
Later fill this with the data you need.
Subscribe to:
Posts (Atom)