asked on
Friend Function GetStatusHistory(sStatus1 As String, dtStatusTime1 As Nullable(Of DateTime), sStatus2 As String, dtStatusTime2 As Nullable(Of DateTime), sStatus3 As String, dtStatusTime3 As Nullable(Of DateTime)) As String
Dim sResult As String = ""
Dim lstStatus As New System.Collections.Generic.SortedList(Of DateTime, String)
If Not IsNothing(dtStatusTime1) Then
lstStatus.Add(dtStatusTime1, sStatus1)
End If
If Not IsNothing(dtStatusTime2) Then
lstStatus.Add(dtStatusTime2, sStatus2)
End If
If Not IsNothing(dtStatusTime3) Then
lstStatus.Add(dtStatusTime3, sStatus3)
End If
For Each pair As System.Collections.Generic.KeyValuePair(Of DateTime, String) In lstStatus
If String.IsNullOrEmpty(sResult) Then
sResult = pair.Value + " @ " + pair.Key.ToString("dd/MM/yy HH:mm")
Else
sResult = sResult + ", " + pair.Value + " @ " + pair.Key.ToString("dd/MM/yy HH:mm")
End If
Next
Return sResult
End Function
ASKER
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
TRUSTED BY
ASKER