VB. NET, Question?

19 Jun 2006 3:41 PM

robdken

I'm new to VB .NET and am just trying to get to grips with the
capability of the software. I am trying to create a program that is
able to import 3 different .csv files at a time, manipulate them in a
way similar to Excel, and then save them. What is the easiest way to go
about it? I was thinking DataTables?

I was also wondering when creating programmes using lots of data
sources in VB .NET is it better to store the data in databases. The
reason i ask this is because of all the manuals i've seen all refer to
SQL servers and the Server Explorer in their importing data sections.
Also the tools like DataGrids and DataTables seem to all have been
designed for use with databases?.... Whats the best way for data to be
organised?

Thanks in advance.

19 Jun 2006 4:48 PM

IdleBrain

Hai:
Look into how to implement File IO and then look at String.Split
Function. You could use a ',' character in the Split() function to
split a row into columns.

Use SQL if the amount of data is enormous and grows continuously. But
for regular applications .csv file or .mdb files should good I guess..

Hope it helps.

robdken wrote:
Show quoteHide quote

> I'm new to VB .NET and am just trying to get to grips with the
> capability of the software. I am trying to create a program that is
> able to import 3 different .csv files at a time, manipulate them in a
> way similar to Excel, and then save them. What is the easiest way to go
> about it? I was thinking DataTables?
>
> I was also wondering when creating programmes using lots of data
> sources in VB .NET is it better to store the data in databases. The
> reason i ask this is because of all the manuals i've seen all refer to
> SQL servers and the Server Explorer in their importing data sections.
> Also the tools like DataGrids and DataTables seem to all have been
> designed for use with databases?.... Whats the best way for data to be
> organised?
>
> Thanks in advance.