How to combined multiple csv files into new csv file using DOS command?

[robinx1578]

In DOS Command I can combined multiple .csv file using this code.

COPY *.csv NewCSVFile.csv

I just write some code bt i dont know how to execute above command inside vb.net

Imports System.Windows.Forms
Imports System.IO
Public Class CombineCSV
    Private Sub btnBrowse_Click(sender As Object, e As EventArgs) Handles btnBrowse.Click
        If (LocateCSVFolder.ShowDialog() = DialogResult.OK) Then
            txtLocateCSV.Text = LocateCSVFolder.SelectedPath
        End If
    End Sub

    Private Sub btnNewCSVLocation_Click(sender As Object, e As EventArgs) Handles btnNewCSVLocation.Click
        If (LocateCSVFolder.ShowDialog() = Windows.Forms.DialogResult.OK) Then
            txtNewCSVLocation.Text = LocateCSVFolder.SelectedPath
        End If
    End Sub

    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim xLocation As String
        Dim xNewLocation As String
        Dim xNewFileName As String

        xLocation = txtLocateCSV.Text 'Directory of csv files
        xNewLocation = txtNewCSVLocation.Text 'Directory of combined CSV
        xNewFileName = txtNewCSV.Text 'New Filename for combined csv ex. School_Details.csv

        'in dos i can do 
        'copy xlocation\*.csv xNewlocation\xNewfileName

    End Sub


End Class

Thanks for your time.

[robinx1578]

any idea bout how its done?