Copy MS-SQL table to local array

Guys!

Can anyone tell me what is the best approach in VB.NET to get the entire table from the Ms SQL 2008 R2 database and save it in the program (dynamic?) array or开发者_C百科 something which is easy to translate into bytes and send to other device via socket communication?

you can use DataSet to keep your Table and write that dataset to XML like bellow

Using Stream = New NetworkStream(socket)
    dataSet.WriteXml(Stream)
End Using