Update SQL databace from CSV file

Update SQL databace from CSV file UpdateSQLdatabacefromCSVfile Update SQL databace from CSV file [VB.NET] Mischa Princ /PreviewSnippet.aspx?SnippetID=9bd89501-1b8d-4771-8190-0cffc02fec79 SurroundsWith

 0 Then
                    Dim prikaz As String
                    Dim pole() As String
                    pole = radek.Split(";")
                    Dim c As Integer = 1
                    Dim max As Integer = promenne.Length
                    While c < max
                        If pole(c) <> "" And promenne(c).ToString <> "" Then

                            prikaz = "UPDATE table SET " & "`" & RTrim(LTrim(promenne(c))) & "`='" & pole(c) & "'" & " WHERE `" & RTrim(LTrim(promenne(0))) & "`='" & pole(0) & "'"

                            Dim update As New System.Data.OleDb.OleDbCommand(prikaz, connect)
                            Try
                                update.ExecuteNonQuery()
                                Console.ForegroundColor = ConsoleColor.Red
                                Console.Write("-")
                                Console.ForegroundColor = ConsoleColor.Gray
                            Catch ex As Exception
                                Console.ForegroundColor = ConsoleColor.Red
                                Console.Write("*")
                                Console.ForegroundColor = ConsoleColor.Gray
                            End Try
                        End If
                        c += 1
                    End While

                End If
                a += 1
            Next
            Console.Read()

        End Using
    End Sub
End Module]]>