Dim LineOfText As String
        Dim i As Integer
        Dim aryTextFile() As String

        LineOfText = txtname.Text
        aryTextFile = LineOfText.Split(", ")

myconn.open

            For i = 0 To UBound(aryTextFile)
                sql =String.Format("UPDATE  tablename SET name = '" & aryTextFile(i) & _
                    "' WHERE nameid = '" & txtid.Text & "';"))

cmd = New MySqlCommand(sql, myconn)
        cmd.ExecuteNonQuery()

            Next

myconn.close

' I CAN ONLY UPDATE THE SECOND ITEM IN THE TEXTBOX WHEN IT IS SPLIT!!!...

• Edited by Avandeth 7 hours 0 minutes ago

Please ask your question in the Visual Basic forums:

http://social.msdn.microsoft.com/Forums/en-US/home?forum=vbgeneral&filter=alltypes&sort=lastpostdesc