multiline textbox to update 4 fields in a database

[honeypot]

HI
I have a multi-line textbox on my windows form, which should enable users to put in an address. The database that it will update has 4 address fields - address1, address2, address3 & address4. How do i write the code that will enable the textbox to update each field separately, assuming that the 1st line will update address1, the 2nd line will update address2 etc?

 

[Paszt]

Use the textBox.Lines collection.

If TextBox1.Lines.Length > 4 Then
    MessageBox.Show(Me, "Too many lines!")
End If
Dim ln As String
For Each ln In TextBox1.Lines
    MessageBox.Show(Me, ln)
Next

-Stephen Paszt

 

[honeypot]

that didn't work....thanx tho

 

[Paszt]

Why not? Works for me.