Member Avatar for DaveD3
DaveD3 0 Newbie Poster

I am new to .NET and have been unable to get data from a CSV file to a dataset. Most examples are VB and C# which need to be converted. The code below compiles clean but does not fill the dataset. I have been unable to set a watch on the dataset to be sure of this. Any help with eithor problem would be greatly appreciated.

String* strFileName = "c:\\TestCSV\\HandoffNYC.csv";
String* strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\TestCSV; Extended Properties='Text;HDR=YES;FMT=Delimited'";
System::Data::OleDb::OleDbConnection* conText = new System::Data::OleDb::OleDbConnection(strConnectionString);
conText->Open();
System::Data::OleDb::OleDbDataAdapter* adap = new System::Data::OleDb::OleDbDataAdapter("SELECT * FROM __Box(fileName)", conText);
adap->Fill(atcf);

atcf is a dataset that is created for the application elsewhere.

  • 1 Contributor
  • 0 Replies
  • 58 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.