command.Connection = connection;
command.CommandText = "select * from Cards where CardID_PK = '" + cardId + "'";
Which basically grabs the card with the matching id.
My question is rather simple how would I get this data back as a collection / dataset so I can manipulate it?
More importantly say I am getting back multiple cards or multiple accounts how do I then handle these? I am most likely just missing a container step for handling?