I want to create an array from a column in a dataset. Basicaly I want to put all the Zipcodes from the ueZip field into an array. Is that possible? My goal is to use what I learned on this thread Question about Array with an array created from a dataset instead of a hardcoded one as I do there.
VB Code:
Dim strSelect2 As String = _ "Select ueStore, ueAddress, ueCity, ueState, " & _ "ueZip From queUncEdsZCodes " & _ "Where Latitude <=" & HighLatitude & _ "And Latitude >=" & LowLatitude & _ "And Longitude <=" & HighLongitude & _ "And Longitude >=" & LowLongitude Dim Cmd2 As New OleDbDataAdapter(strSelect2, conn) Dim ds As New DataSet Cmd2.Fill(ds, "ZipCodes") Return ds End Function ......Snip..... Dim myDS As DataSet = GetUE_ZipRadius(tbZip.Text, CInt(tbRadius.Text)) DataGrid1.DataSource = myDS DataGrid1.DataMember = "ZipCodes"




Reply With Quote