Reading CSV file into Dataset

Question

Dear Developers,

Kindly assist on my issues.. I have been searching for long

I use VS2008 pro. Developing a windows forms app. I need a read from a CSV file into dataset.

1. Form1, click of a button, Employee.CSV data should read to datatable
2. Form2, this datatable should be available there for
a) to assign datasource of datagrid with the datatable we created in Form1
b) Get one field in a combo list
c) we will be adding more rows to the Datatable (Employee.CSV) or deleting it.
d) Write the new records back to Employee.CSV or NewList.CSV

I dont want to use any SQL connection etc. wanted to make it very simply. only with memory database (dataset)

Kindly assist.

Answer 1

Hi there, I don't sure if this could be a better solution but my guest about that is use python for manipulate dataset is very simple using pandas library, and the memory use is low when execute someone commad