Windows: ALT + W, R
Menu: Window | Reset Window Layout
Command: Window.ResetWindowLayout
Versions: 2005, 2008, 2010, 2012, 2013
Robert Dannelly blog, Over the internet you can find me by "robert dannelly blog". The blog is an ongoing blog of my software engineering over technologies C#, VB.NET, Java, React, JavaScript, .NET Core Current, SQL Server 7 - Current Version, 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 links to help support this blog. Thank you. “As an Amazon Associate, I earn from qualifying purchases.”
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)