reading from CSV

[Vicky S]

Thanks,
I could not find any reference to Jet Provider (I'm unfamiliar with this) on
the msft .net class library, can you explain how I can use this?

Thanks,
Vicky

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netRemuvThis> wrote in
message news:%23plvVQjSDHA.560@TK2MSFTNGP10.phx.gbl...

> For a driver, you have to go to the ODBC namespace (System.Data.ODBC). You
> can, however, open a CSV with the Jet Provider if you wish to use OLEDB.
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
> Author: ADO.NET and XML: ASP.NET on the Edge
>
>

************************************************** **************************

> ****
> Think Outside the Box!
>

************************************************** **************************

> ****
> "Vicky S" <rainstorms@comcast.net> wrote in message
> news:udqCdKjSDHA.1552@TK2MSFTNGP10.phx.gbl...

> > Hello,
> > before dot net I could open up a sqlconnection to a txt/csv file with

the

> > connection string =
> > Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=.
> >
> > how can I do that in dotnet?
> >
> > Thanks,
> > V
> >
> >

>
>

[Steve C. Orr, MCSD]

Perhaps you'll be able to find the connection string you need here:
[url]http://www.able-consulting.com/ADO_Conn.htm[/url]

--
I hope this helps,
Steve C. Orr, MCSD
[url]http://Steve.Orr.net[/url]


"Vicky S" <rainstorms@comcast.net> wrote in message
news:udqCdKjSDHA.1552@TK2MSFTNGP10.phx.gbl...

> Hello,
> before dot net I could open up a sqlconnection to a txt/csv file with the
> connection string =
> Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=.
>
> how can I do that in dotnet?
>
> Thanks,
> V
>
>

[Vicky S]

Thanks....
ok.... I'm halfway there...I think.
I have the below code... but it won't let me connect. Is this wrong?

Dim oOleDbConnection As OleDbConnection

Dim sConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;"

oOleDbConnection = New OleDb.OleDbConnection(sConnString)

oOleDbConnection.Open()



Dim oleCmd As OleDbCommand

With oleCmd

..Connection = oOleDbConnection

..CommandType = CommandType.Text

..CommandText = "SELECT * FROM FieldMappings.csv"

End With



Dim oleAdapter As New OleDbDataAdapter()

Dim dataset As DataSet

oleAdapter.SelectCommand = New OleDbCommand(oleCmd.CommandText,
oOleDbConnection)

oleAdapter.Fill(DataSet)




"Steve C. Orr, MCSD" <Steve@Orr.net> wrote in message
news:OU12IjjSDHA.3144@tk2msftngp13.phx.gbl...

> Perhaps you'll be able to find the connection string you need here:
> [url]http://www.able-consulting.com/ADO_Conn.htm[/url]
>
> --
> I hope this helps,
> Steve C. Orr, MCSD
> [url]http://Steve.Orr.net[/url]
>
>
> "Vicky S" <rainstorms@comcast.net> wrote in message
> news:udqCdKjSDHA.1552@TK2MSFTNGP10.phx.gbl...

> > Hello,
> > before dot net I could open up a sqlconnection to a txt/csv file with

the

> > connection string =
> > Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=.
> >
> > how can I do that in dotnet?
> >
> > Thanks,
> > V
> >
> >

>
>

[Kevin Spencer]

You're halfway AWAY there. You were closer when you started. The Connection
String would not change. You are still connecting to a comma-delimited text
file, so you would certainly NOT use the Jet OLE DB driver, which is for
Access databases. You would use the same Connection String you used before.
You are connecting via an ODBC driver, so you would use the System.Data.Odbc
Namespace, and the classes therein.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
[url]http://www.takempis.com[/url]
Big things are made up of
lots of little things.

"Vicky S" <rainstorms@comcast.net> wrote in message
news:e6LwQBkSDHA.3132@tk2msftngp13.phx.gbl...

>
> Thanks....
> ok.... I'm halfway there...I think.
> I have the below code... but it won't let me connect. Is this wrong?
>
> Dim oOleDbConnection As OleDbConnection
>
> Dim sConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
>
> oOleDbConnection = New OleDb.OleDbConnection(sConnString)
>
> oOleDbConnection.Open()
>
>
>
> Dim oleCmd As OleDbCommand
>
> With oleCmd
>
> .Connection = oOleDbConnection
>
> .CommandType = CommandType.Text
>
> .CommandText = "SELECT * FROM FieldMappings.csv"
>
> End With
>
>
>
> Dim oleAdapter As New OleDbDataAdapter()
>
> Dim dataset As DataSet
>
> oleAdapter.SelectCommand = New OleDbCommand(oleCmd.CommandText,
> oOleDbConnection)
>
> oleAdapter.Fill(DataSet)
>
>
>
>
> "Steve C. Orr, MCSD" <Steve@Orr.net> wrote in message
> news:OU12IjjSDHA.3144@tk2msftngp13.phx.gbl...

> > Perhaps you'll be able to find the connection string you need here:
> > [url]http://www.able-consulting.com/ADO_Conn.htm[/url]
> >
> > --
> > I hope this helps,
> > Steve C. Orr, MCSD
> > [url]http://Steve.Orr.net[/url]
> >
> >
> > "Vicky S" <rainstorms@comcast.net> wrote in message
> > news:udqCdKjSDHA.1552@TK2MSFTNGP10.phx.gbl...

> > > Hello,
> > > before dot net I could open up a sqlconnection to a txt/csv file with

> the

> > > connection string =
> > > Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=.
> > >
> > > how can I do that in dotnet?
> > >
> > > Thanks,
> > > V
> > >
> > >

> >
> >

>
>

[Vicky S]

Hrm.. I'm using .net framework 1.0 and I don't think odbc is supported
there.
is there another way?


"Kevin Spencer" <kevin@takempis.com> wrote in message
news:eD3sJ3sSDHA.1748@TK2MSFTNGP11.phx.gbl...

> You're halfway AWAY there. You were closer when you started. The

Connection

> String would not change. You are still connecting to a comma-delimited

text

> file, so you would certainly NOT use the Jet OLE DB driver, which is for
> Access databases. You would use the same Connection String you used

before.

> You are connecting via an ODBC driver, so you would use the

System.Data.Odbc

> Namespace, and the classes therein.
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> .Net Developer
> [url]http://www.takempis.com[/url]
> Big things are made up of
> lots of little things.
>
> "Vicky S" <rainstorms@comcast.net> wrote in message
> news:e6LwQBkSDHA.3132@tk2msftngp13.phx.gbl...

> >
> > Thanks....
> > ok.... I'm halfway there...I think.
> > I have the below code... but it won't let me connect. Is this wrong?
> >
> > Dim oOleDbConnection As OleDbConnection
> >
> > Dim sConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
> >
> > oOleDbConnection = New OleDb.OleDbConnection(sConnString)
> >
> > oOleDbConnection.Open()
> >
> >
> >
> > Dim oleCmd As OleDbCommand
> >
> > With oleCmd
> >
> > .Connection = oOleDbConnection
> >
> > .CommandType = CommandType.Text
> >
> > .CommandText = "SELECT * FROM FieldMappings.csv"
> >
> > End With
> >
> >
> >
> > Dim oleAdapter As New OleDbDataAdapter()
> >
> > Dim dataset As DataSet
> >
> > oleAdapter.SelectCommand = New OleDbCommand(oleCmd.CommandText,
> > oOleDbConnection)
> >
> > oleAdapter.Fill(DataSet)
> >
> >
> >
> >
> > "Steve C. Orr, MCSD" <Steve@Orr.net> wrote in message
> > news:OU12IjjSDHA.3144@tk2msftngp13.phx.gbl...

> > > Perhaps you'll be able to find the connection string you need here:
> > > [url]http://www.able-consulting.com/ADO_Conn.htm[/url]
> > >
> > > --
> > > I hope this helps,
> > > Steve C. Orr, MCSD
> > > [url]http://Steve.Orr.net[/url]
> > >
> > >
> > > "Vicky S" <rainstorms@comcast.net> wrote in message
> > > news:udqCdKjSDHA.1552@TK2MSFTNGP10.phx.gbl...
> > > > Hello,
> > > > before dot net I could open up a sqlconnection to a txt/csv file

with

> > the

> > > > connection string =
> > > > Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=.
> > > >
> > > > how can I do that in dotnet?
> > > >
> > > > Thanks,
> > > > V
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Kevin Spencer]

You can download the .NET Framework Data Provider for ODBC at
[url]http://msdn.microsoft.com/downloads[/url].

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
[url]http://www.takempis.com[/url]
Big things are made up of
lots of little things.

"Vicky S" <rainstorms@comcast.net> wrote in message
news:OB$FdstSDHA.1036@TK2MSFTNGP10.phx.gbl...

>
> Hrm.. I'm using .net framework 1.0 and I don't think odbc is supported
> there.
> is there another way?
>
>
> "Kevin Spencer" <kevin@takempis.com> wrote in message
> news:eD3sJ3sSDHA.1748@TK2MSFTNGP11.phx.gbl...

> > You're halfway AWAY there. You were closer when you started. The

> Connection

> > String would not change. You are still connecting to a comma-delimited

> text

> > file, so you would certainly NOT use the Jet OLE DB driver, which is for
> > Access databases. You would use the same Connection String you used

> before.

> > You are connecting via an ODBC driver, so you would use the

> System.Data.Odbc

> > Namespace, and the classes therein.
> >
> > --
> > HTH,
> >
> > Kevin Spencer
> > Microsoft MVP
> > .Net Developer
> > [url]http://www.takempis.com[/url]
> > Big things are made up of
> > lots of little things.
> >
> > "Vicky S" <rainstorms@comcast.net> wrote in message
> > news:e6LwQBkSDHA.3132@tk2msftngp13.phx.gbl...

> > >
> > > Thanks....
> > > ok.... I'm halfway there...I think.
> > > I have the below code... but it won't let me connect. Is this wrong?
> > >
> > > Dim oOleDbConnection As OleDbConnection
> > >
> > > Dim sConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
> > >
> > > oOleDbConnection = New OleDb.OleDbConnection(sConnString)
> > >
> > > oOleDbConnection.Open()
> > >
> > >
> > >
> > > Dim oleCmd As OleDbCommand
> > >
> > > With oleCmd
> > >
> > > .Connection = oOleDbConnection
> > >
> > > .CommandType = CommandType.Text
> > >
> > > .CommandText = "SELECT * FROM FieldMappings.csv"
> > >
> > > End With
> > >
> > >
> > >
> > > Dim oleAdapter As New OleDbDataAdapter()
> > >
> > > Dim dataset As DataSet
> > >
> > > oleAdapter.SelectCommand = New OleDbCommand(oleCmd.CommandText,
> > > oOleDbConnection)
> > >
> > > oleAdapter.Fill(DataSet)
> > >
> > >
> > >
> > >
> > > "Steve C. Orr, MCSD" <Steve@Orr.net> wrote in message
> > > news:OU12IjjSDHA.3144@tk2msftngp13.phx.gbl...
> > > > Perhaps you'll be able to find the connection string you need here:
> > > > [url]http://www.able-consulting.com/ADO_Conn.htm[/url]
> > > >
> > > > --
> > > > I hope this helps,
> > > > Steve C. Orr, MCSD
> > > > [url]http://Steve.Orr.net[/url]
> > > >
> > > >
> > > > "Vicky S" <rainstorms@comcast.net> wrote in message
> > > > news:udqCdKjSDHA.1552@TK2MSFTNGP10.phx.gbl...
> > > > > Hello,
> > > > > before dot net I could open up a sqlconnection to a txt/csv file

> with

> > > the
> > > > > connection string =
> > > > > Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=.
> > > > >
> > > > > how can I do that in dotnet?
> > > > >
> > > > > Thanks,
> > > > > V
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Steve C. Orr, MCSD]

There's more than one way to skin a cat.
If I were in your shoes, rather than messing around with all these drivers
and connection strings and whatnot, I'd just open the file directly and
parse through the values.
With a CSV the code should be trivial.
Here's more info:
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemiofileinfoclassopentopic3.asp[/url]
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemstringclasssplittopic.asp[/url]

--
I hope this helps,
Steve C. Orr, MCSD
[url]http://Steve.Orr.net[/url]


"Vicky S" <rainstorms@comcast.net> wrote in message
news:udqCdKjSDHA.1552@TK2MSFTNGP10.phx.gbl...

> Hello,
> before dot net I could open up a sqlconnection to a txt/csv file with the
> connection string =
> Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=.
>
> how can I do that in dotnet?
>
> Thanks,
> V
>
>

[Vicky S]

Thanks.
Now I can reference odbc through microsoft.data.odbc (not system.data.odbc -
is this correct?)

Also, in this line..
odbcAdapter.SelectCommand = New OdbcCommand("SELECT * FROM
AptusDLFieldMappings.csv", odbcConn)

does the file have to be in the same dir as the executable path? I'm getting
an error that value cannot be null on this line :
odbcAdapter.Fill(dataset)



"Kevin Spencer" <kevin@takempis.com> wrote in message
news:%237U6pkuSDHA.2128@TK2MSFTNGP12.phx.gbl...

> You can download the .NET Framework Data Provider for ODBC at
> [url]http://msdn.microsoft.com/downloads[/url].
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> .Net Developer
> [url]http://www.takempis.com[/url]
> Big things are made up of
> lots of little things.
>
> "Vicky S" <rainstorms@comcast.net> wrote in message
> news:OB$FdstSDHA.1036@TK2MSFTNGP10.phx.gbl...

> >
> > Hrm.. I'm using .net framework 1.0 and I don't think odbc is supported
> > there.
> > is there another way?
> >
> >
> > "Kevin Spencer" <kevin@takempis.com> wrote in message
> > news:eD3sJ3sSDHA.1748@TK2MSFTNGP11.phx.gbl...

> > > You're halfway AWAY there. You were closer when you started. The

> > Connection

> > > String would not change. You are still connecting to a comma-delimited

> > text

> > > file, so you would certainly NOT use the Jet OLE DB driver, which is

for

> > > Access databases. You would use the same Connection String you used

> > before.

> > > You are connecting via an ODBC driver, so you would use the

> > System.Data.Odbc

> > > Namespace, and the classes therein.
> > >
> > > --
> > > HTH,
> > >
> > > Kevin Spencer
> > > Microsoft MVP
> > > .Net Developer
> > > [url]http://www.takempis.com[/url]
> > > Big things are made up of
> > > lots of little things.
> > >
> > > "Vicky S" <rainstorms@comcast.net> wrote in message
> > > news:e6LwQBkSDHA.3132@tk2msftngp13.phx.gbl...
> > > >
> > > > Thanks....
> > > > ok.... I'm halfway there...I think.
> > > > I have the below code... but it won't let me connect. Is this wrong?
> > > >
> > > > Dim oOleDbConnection As OleDbConnection
> > > >
> > > > Dim sConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
> > > >
> > > > oOleDbConnection = New OleDb.OleDbConnection(sConnString)
> > > >
> > > > oOleDbConnection.Open()
> > > >
> > > >
> > > >
> > > > Dim oleCmd As OleDbCommand
> > > >
> > > > With oleCmd
> > > >
> > > > .Connection = oOleDbConnection
> > > >
> > > > .CommandType = CommandType.Text
> > > >
> > > > .CommandText = "SELECT * FROM FieldMappings.csv"
> > > >
> > > > End With
> > > >
> > > >
> > > >
> > > > Dim oleAdapter As New OleDbDataAdapter()
> > > >
> > > > Dim dataset As DataSet
> > > >
> > > > oleAdapter.SelectCommand = New OleDbCommand(oleCmd.CommandText,
> > > > oOleDbConnection)
> > > >
> > > > oleAdapter.Fill(DataSet)
> > > >
> > > >
> > > >
> > > >
> > > > "Steve C. Orr, MCSD" <Steve@Orr.net> wrote in message
> > > > news:OU12IjjSDHA.3144@tk2msftngp13.phx.gbl...
> > > > > Perhaps you'll be able to find the connection string you need

here:

> > > > > [url]http://www.able-consulting.com/ADO_Conn.htm[/url]
> > > > >
> > > > > --
> > > > > I hope this helps,
> > > > > Steve C. Orr, MCSD
> > > > > [url]http://Steve.Orr.net[/url]
> > > > >
> > > > >
> > > > > "Vicky S" <rainstorms@comcast.net> wrote in message
> > > > > news:udqCdKjSDHA.1552@TK2MSFTNGP10.phx.gbl...
> > > > > > Hello,
> > > > > > before dot net I could open up a sqlconnection to a txt/csv file

> > with

> > > > the
> > > > > > connection string =
> > > > > > Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=.
> > > > > >
> > > > > > how can I do that in dotnet?
> > > > > >
> > > > > > Thanks,
> > > > > > V
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >

> >
> >

>
>

[Kevin Spencer]

Well, now we're getting into an area that I'm not experienced in (using a
CSV as a data source). I can only suppose that your Connection String points
to the location of the CSV file. I'm not sure how you specify the table in
your SELECT statement.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
[url]http://www.takempis.com[/url]
Big things are made up of
lots of little things.

"Vicky S" <rainstorms@comcast.net> wrote in message
news:%236svXawSDHA.2276@TK2MSFTNGP10.phx.gbl...

>
> Thanks.
> Now I can reference odbc through microsoft.data.odbc (not

system.data.odbc -

> is this correct?)
>
> Also, in this line..
> odbcAdapter.SelectCommand = New OdbcCommand("SELECT * FROM
> AptusDLFieldMappings.csv", odbcConn)
>
> does the file have to be in the same dir as the executable path? I'm

getting

> an error that value cannot be null on this line :
> odbcAdapter.Fill(dataset)
>
>
>
> "Kevin Spencer" <kevin@takempis.com> wrote in message
> news:%237U6pkuSDHA.2128@TK2MSFTNGP12.phx.gbl...

> > You can download the .NET Framework Data Provider for ODBC at
> > [url]http://msdn.microsoft.com/downloads[/url].
> >
> > --
> > HTH,
> >
> > Kevin Spencer
> > Microsoft MVP
> > .Net Developer
> > [url]http://www.takempis.com[/url]
> > Big things are made up of
> > lots of little things.
> >
> > "Vicky S" <rainstorms@comcast.net> wrote in message
> > news:OB$FdstSDHA.1036@TK2MSFTNGP10.phx.gbl...

> > >
> > > Hrm.. I'm using .net framework 1.0 and I don't think odbc is supported
> > > there.
> > > is there another way?
> > >
> > >
> > > "Kevin Spencer" <kevin@takempis.com> wrote in message
> > > news:eD3sJ3sSDHA.1748@TK2MSFTNGP11.phx.gbl...
> > > > You're halfway AWAY there. You were closer when you started. The
> > > Connection
> > > > String would not change. You are still connecting to a

comma-delimited

> > > text
> > > > file, so you would certainly NOT use the Jet OLE DB driver, which is

> for

> > > > Access databases. You would use the same Connection String you used
> > > before.
> > > > You are connecting via an ODBC driver, so you would use the
> > > System.Data.Odbc
> > > > Namespace, and the classes therein.
> > > >
> > > > --
> > > > HTH,
> > > >
> > > > Kevin Spencer
> > > > Microsoft MVP
> > > > .Net Developer
> > > > [url]http://www.takempis.com[/url]
> > > > Big things are made up of
> > > > lots of little things.
> > > >
> > > > "Vicky S" <rainstorms@comcast.net> wrote in message
> > > > news:e6LwQBkSDHA.3132@tk2msftngp13.phx.gbl...
> > > > >
> > > > > Thanks....
> > > > > ok.... I'm halfway there...I think.
> > > > > I have the below code... but it won't let me connect. Is this

wrong?

> > > > >
> > > > > Dim oOleDbConnection As OleDbConnection
> > > > >
> > > > > Dim sConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
> > > > >
> > > > > oOleDbConnection = New OleDb.OleDbConnection(sConnString)
> > > > >
> > > > > oOleDbConnection.Open()
> > > > >
> > > > >
> > > > >
> > > > > Dim oleCmd As OleDbCommand
> > > > >
> > > > > With oleCmd
> > > > >
> > > > > .Connection = oOleDbConnection
> > > > >
> > > > > .CommandType = CommandType.Text
> > > > >
> > > > > .CommandText = "SELECT * FROM FieldMappings.csv"
> > > > >
> > > > > End With
> > > > >
> > > > >
> > > > >
> > > > > Dim oleAdapter As New OleDbDataAdapter()
> > > > >
> > > > > Dim dataset As DataSet
> > > > >
> > > > > oleAdapter.SelectCommand = New OleDbCommand(oleCmd.CommandText,
> > > > > oOleDbConnection)
> > > > >
> > > > > oleAdapter.Fill(DataSet)
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > "Steve C. Orr, MCSD" <Steve@Orr.net> wrote in message
> > > > > news:OU12IjjSDHA.3144@tk2msftngp13.phx.gbl...
> > > > > > Perhaps you'll be able to find the connection string you need

> here:

> > > > > > [url]http://www.able-consulting.com/ADO_Conn.htm[/url]
> > > > > >
> > > > > > --
> > > > > > I hope this helps,
> > > > > > Steve C. Orr, MCSD
> > > > > > [url]http://Steve.Orr.net[/url]
> > > > > >
> > > > > >
> > > > > > "Vicky S" <rainstorms@comcast.net> wrote in message
> > > > > > news:udqCdKjSDHA.1552@TK2MSFTNGP10.phx.gbl...
> > > > > > > Hello,
> > > > > > > before dot net I could open up a sqlconnection to a txt/csv

file

> > > with
> > > > > the
> > > > > > > connection string =
> > > > > > > Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=.
> > > > > > >
> > > > > > > how can I do that in dotnet?
> > > > > > >
> > > > > > > Thanks,
> > > > > > > V
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >

> >
> >

>
>