import file in dataset problem

[Eric Caron]

Hi

I try to import file in a dataset. How I can do this ?

[Frank Eller [MVP]]

Hi ERic,

Hi

I try to import file in a dataset. How I can do this ?

First you need a DataTable to put the stuff in. If you want to import a
CSV-file, you can separate the different items using the
String.Split()-method. For example (from scratch):
=============== =============== =
// Create dynamic Table
DataTable dt = new DataTable();

// Create Row Data - in this case 3 columns which means
// That in your CSV-file are also only 3 items per row
dt.Columns.Add( "ComputerID ", System.Type.Get Type("System.St ring"));
dt.Columns.Add( "Computerna me", System.Type.Get Type("System.St ring"));
dt.Columns.Add( "Active", System.Type.Get Type("System.St ring"));

// Read the Textfile
StreamReader sr = new StreamReader(yo urfilename);

string datStr;
do {
datStr = sr.ReadLine();
if ( datStr != null ) {
string[] rowData = sr.Split(',');

// CreateRow
DataRow dr = dt.NewRow();
// Fill Row
dr["ComputerID "] = rowData[0];
dr["Computerna me"] = rowData[1];
dr["Active"] = rowData[2];
// Add Row
dt.Rows.Add( dr );
}
} while ( datStr != null );

DataSet ds = new DataSet();
// Insert Table
ds.Tables.Add( dt );

=============== =============== =

Remember, this is not proved, I just wrote it down from scratch ... but this
is the way to go, I suppose.

Regards,

--
Frank Eller [.NET MVP]
www.frankeller.de
..NET Developers Group Munich- www.munichdot.net

[Dino Chiesa [Microsoft]]

see my other reply to your similar query in this same newsgroup.

"Eric Caron" <ec****@pgsyste m.com> wrote in message
news:av******** *************** *********@4ax.c om...

Hi

I try to import file in a dataset. How I can do this ?