import CSV file directly into a dataset

[darrel]

is that doable?

I have built a CSV string using a stringbuilder.

I now want to take this data and populate a DS.

How do I do that?

I've gotten this far:

dim ds as new dataset
Dim objOleDbAdapter As System.Data.OleDb.OleDbDataAdapter
Dim objConnect2 As New System.Data.OleDb.OleDbConnection("[THIS IS WHERE I'M
STUCK]'")
objOleDbAdapter.Fill(ds)

As you can see, I'm stumped on the actual connection string. I have examples
connecting to a physical file, but not a string.

-Darrel

[Jacob]

You probably need to loop through each line of your CSV and create a
DataRow from the data. Then add the DataRow to your DataTable.

[intrader]

On Wed, 08 Mar 2006 11:44:33 -0600, darrel wrote:

is that doable?

I have built a CSV string using a stringbuilder.

I now want to take this data and populate a DS.

How do I do that?

I've gotten this far:

dim ds as new dataset
Dim objOleDbAdapter As System.Data.OleDb.OleDbDataAdapter
Dim objConnect2 As New System.Data.OleDb.OleDbConnection("[THIS IS WHERE I'M
STUCK]'")
objOleDbAdapter.Fill(ds)

As you can see, I'm stumped on the actual connection string. I have examples
connecting to a physical file, but not a string.

-Darrel

Another way, write an XML schema to represent the CSV. Then load the XML
into the dataset.

[darrel]

You probably need to loop through each line of your CSV and create a
DataRow from the data. Then add the DataRow to your DataTable.

Well, in hindsight, that probably makes a lot more sense. Just go from DS to
new DS.

I'll give that a shot!

-Darrel

[sloan]

Here is another option, with Xml.

Also check this post I made a while back:
http://groups.google.com/group/micro...214c3bcca94224
(or search
http://groups.google.com/?hl=en for "xml to xml transformation" and
"spaces.msn.com"
)







"darrel" <no*****@nowhere.com> wrote in message
news:e1*************@TK2MSFTNGP15.phx.gbl...

is that doable?

I have built a CSV string using a stringbuilder.

I now want to take this data and populate a DS.

How do I do that?

I've gotten this far:

dim ds as new dataset
Dim objOleDbAdapter As System.Data.OleDb.OleDbDataAdapter
Dim objConnect2 As New System.Data.OleDb.OleDbConnection("[THIS IS WHERE I'M STUCK]'")
objOleDbAdapter.Fill(ds)

As you can see, I'm stumped on the actual connection string. I have examples connecting to a physical file, but not a string.

-Darrel

[Peter Bromberg [C# MVP]]

If you look around there are several implementations of "CSVDataReaders"
around.
With a file, its easy - just use a JET OleDb connection string to the folder
with the Text file provider nomenclature, and do "select * from mystuff.csv"
and it goes right into an OleDbDataReader.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"darrel" wrote:

is that doable?

I have built a CSV string using a stringbuilder.

I now want to take this data and populate a DS.

How do I do that?

I've gotten this far:

dim ds as new dataset
Dim objOleDbAdapter As System.Data.OleDb.OleDbDataAdapter
Dim objConnect2 As New System.Data.OleDb.OleDbConnection("[THIS IS WHERE I'M
STUCK]'")
objOleDbAdapter.Fill(ds)

As you can see, I'm stumped on the actual connection string. I have examples
connecting to a physical file, but not a string.

-Darrel

[darrel]

With a file, its easy

Right. But I don't have a file...just a string.

I suppose I could write the string to a file then reimport. In the end,
though, I tought it probably makes more sense just to go from DS to DS
instead of CSV in the middle.

-Darrel