Naime, dole navedena funkcija SendCompletedTransactions treba da vrati neku listu Transaction. Da bi to funkcionisalo ja sam definisao SingleTrans u koji addujem podatke iz svakog datarow-a ,a onda taj SingleTrans addujem u "trans" listu koju nameravam da vratim kao rezultat.
Međutim, problematika je u tome što lista "trans" na kraju dobije npr. 4 itema koliko bi i trebalo jer toliko recorda u bazi i postoji, ali kako se loopuje kroz "dr" sadržaj poslednjeg itema uvek pretaba sve pre njega. Tako da ja dobijem listu sa četiri itema koji su istog sadržaja kao i poslednji data row.
Evo ga i kod:
Code:
<WebMethod()> _
Public Function SendCompletedTransactions() As List(Of CIWS.Transaction)
Dim trans As New List(Of CIWS.Transaction)
Dim cnn As SqlConnection = New SqlConnection(conString)
Dim cmd As New SqlCommand("EXEC OnLine_LastGameTransactions ", cnn)
Dim dr As SqlDataReader
Dim CustomerID, TicketID As String
Dim SingleTrans As New CIWS.Transaction
cnn.Open()
dr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
While dr.Read()
CustomerID = dr("ID_Player")
TicketID = dr("TicketID")
SingleTrans.CustomerID = CustomerID
SingleTrans.TicketID = TicketID
trans.Add(SingleTrans)
End While
Return trans
End Function
<WebMethod()> _
Public Function SendCompletedTransactions() As List(Of CIWS.Transaction)
Dim trans As New List(Of CIWS.Transaction)
Dim cnn As SqlConnection = New SqlConnection(conString)
Dim cmd As New SqlCommand("EXEC OnLine_LastGameTransactions ", cnn)
Dim dr As SqlDataReader
Dim CustomerID, TicketID As String
Dim SingleTrans As New CIWS.Transaction
cnn.Open()
dr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
While dr.Read()
CustomerID = dr("ID_Player")
TicketID = dr("TicketID")
SingleTrans.CustomerID = CustomerID
SingleTrans.TicketID = TicketID
trans.Add(SingleTrans)
End While
Return trans
End Function
za slučaj da je bitno kako je definisan Transaction, u pitanju su samo dva stringa, ništa drugo...
Code:
public class Transaction
{
public string CustomerID;
public string TicketID;
}
public class Transaction
{
public string CustomerID;
public string TicketID;
}