Loading data into an array from sql db

[Orcblood]

So I have this hangman type game written in visual basic and I would like to get data from a database from sql dbms called 'WordLibrary'. I created a datset in visual stuido called Words that is linked to the WordLibrary. The question is, is how do I go further to get data into an array in my forms code? Besides advice and questions for me, any videos or links would also be great that may help to accomplish what I need. Thanks in advance! I know this is now easy question. Only answer if you are willing

 

 

I know a txt file probably makes more sense for this project but this is for my advance vb class's final project where I have to make a program in vb. I said I would use a sql database to store my words so I would like to stick to that so i wouldn't loose points.

 

If you would like to see the game files of my project please message me and I can send them to you. 

 

[madknight3]

This might help. See the last example where it gets the tables from the data set. You can then get the information out of the data table.

 

Alternatively, you might find it better to work with an ORM like Entity Framework, Dapper, or sqlite-net.