Hello everyone,
I'm looking at splitting a string which is generated and then inserting the values into a listview.
The string that I'm trying to split will look something like this;
The listview I want to input the values in looks like this;
The string is made up of 3 values which is grabbed from a php page which grabs all usernames (and their equivalent emails and ranks) from a MySQL db.
I've currently got it working slightly... and by that I mean it will split the string and insert them into ONLY the first column like above, the full code for this so far is:
Can anyone help me out?Code:Sub getUsers() Dim Str As Stream Dim srRead As StreamReader Dim req As WebRequest = WebRequest.Create(url) Dim resp As WebResponse = req.GetResponse Str = resp.GetResponseStream srRead = New StreamReader(Str) Dim readStr As String = srRead.ReadToEnd readStr = readStr.Replace("</table>", "") readStr = readStr.Replace("<table>", "") readStr = readStr.Replace("<tr>", "") readStr = readStr.Replace("<td>", "") readStr = readStr.Replace("</tr>", "") readStr = readStr.Replace("</td>", "#") MsgBox(readStr) Dim splitStr() As String = readStr.Split("#") Dim split2 As String For Each split2 In splitStr If split2 = "" Then Else userList.Items.Add(split2) End If Next End Sub
Thanks in advanced.




Reply With Quote