using csvdatareader in asp.net

See more:

ASP.NET

I want to import data from csv file to sql database table using csvdatareader and bulkcopy. I know I have to import a dll but dont know the actual one and how to add that reference

this is my code below which gives this error (csvdatareader not defined)

Protected Sub uploadButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles uploadButton.Click
Using csvData = New CsvDataReader(new StreamReader(fileUpload.PostedFile.InputStream, True))        
        csvData.Settings.HasHeaders = True
        csvData.Columns.Add("varchar") 
        csvData.Columns.Add("varchar") 
        csvData.Columns.Add("datetime") 
        csvData.Columns.Add("money") 
        Using bulkCopy = New SqlBulkCopy(conn)
            
            bulkCopy.DestinationTableName = "Customer"           
            bulkCopy.ColumnMappings.Add("First", "first_name") 
            bulkCopy.ColumnMappings.Add("Last", "last_name") 
            bulkCopy.ColumnMappings.Add("Date", "first_sale")             bulkCopy.ColumnMappings.Add("Amount", "sale_amount")

            bulkCopy.WriteToServer(csvData)

        End Using

    End Using

End Sub