<div>
And Bob's way works very wel, particularly if you have no interest in writing anything back to the table.
</div>


And Bob's way works very wel, particularly if you have no interest in writing anything back to the table.

<div>
<div class="content wysiwyg-content">
I Have:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; command.Connection = connection;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; command.CommandText = &quot;select * from Cards where CardID_PK = '&quot; + cardId + &quot;'&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; command.ExecuteNonQuery();<wbr /><br />
<br />
Which basically grabs the card with the matching id.<br />
<br />
My question is rather simple how would I get this data back as a collection / dataset so I can manipulate it?<br />
<br />
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?<br />

</div>
</div>


I Have:

            command.Connection = connection;
            command.CommandText = "select * from Cards where CardID_PK = '" + cardId + "'";
            command.ExecuteNonQuery();

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?


SQL Query &amp; C# Objects

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

SQL Query &amp; C# Objects

SQL Query & C# Objects