Vb.Net and SQL server(2 posts)
This is C# for getting data from a table. VB.Net will use the same objects so you should be able to look it up on MSDN and then figure out the rest.
SqlConnection conn = new SqlConnection("the conn string");
string query = "Select * From YourTableName"
DataTable dt = new dt("MyTable");
SqlCommand cmd = new SqlCommand(query, db);
cmd.CommandTimeout = 30;
SqlDataAdapter da = new SqlDataAdapter(cmd);