vb.net array from sql server table

I have until now avoided using arrays, but I now need to an anyone offer some assistance on how to load the followig type of array froma sql server table? I'm not sure how many products will be in the table.
tblProducts ProdID, ProdName
Dim arrData(7, 3) As String
        'Store Name of Products
        arrData(0, 1) = "Hat"
        arrData(1, 1) = "Coat"
        arrData(2, 1) = "Shoes"
        arrData(3, 1) = "Pants"
        arrData(4, 1) = "Shirt"
        arrData(5, 1) = "Vest"
        arrData(6, 1) = "Belt" 
...