Index: TAOR-rework-bugfixing/TAOR rework/databases/Ardis/ArdisMapper.vb
===================================================================
diff -u -r1609 -r1614
--- TAOR-rework-bugfixing/TAOR rework/databases/Ardis/ArdisMapper.vb (.../ArdisMapper.vb) (revision 1609)
+++ TAOR-rework-bugfixing/TAOR rework/databases/Ardis/ArdisMapper.vb (.../ArdisMapper.vb) (revision 1614)
@@ -50,6 +50,9 @@
data.Add(dr.GetValue(0).ToString)
End While
+ 'Connectie met data reader sluiten.
+ dr.Close()
+
'De lijst retourneren.
Return data
Catch ex As Exception
@@ -63,12 +66,11 @@
''' te converteren naar 'ArdisData'.
''' De gevulde ArdisData
Private Function ExecuteIntoResultset(query As String) As ArdisData
- Dim ardisData As ArdisData = Nothing
'Data reader opvragen.
Dim dr = ExecuteIntoDataReader(query)
'Datareader lezen, eerste record ophalen en retourneren als Ardis data.
dr.Read()
- ardisData = New ArdisData With {
+ Dim ardisData = New ArdisData With {
.PartId = CStr(dr.Item("PartId")),
.OrderId = CStr(dr.Item("OrderId")),
.PartRef = CStr(dr.Item("PartRef")),
@@ -101,6 +103,10 @@
.PartExt10 = If(IsDBNull(dr.Item("PartExt10")), Nothing, CStr(dr.Item("PartExt10"))),
.PartExt11 = If(IsDBNull(dr.Item("PartExt11")), Nothing, CStr(dr.Item("PartExt11")))
}
+
+ 'Connectie met data reader sluiten.
+ dr.Close()
+
Return ardisData
End Function