Whats wrong with this line?

[Ruslan Shlain]

I cant get this to work in C#. It works in VB.NET.

OleDbConnection Conn = new
OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=" + FilePath +
";Extended Properties=""te xt;HDR=NO;FMT=D elimited""");

FilePath = "C:\\ftproot\\T OG\\"

[gabriel]

Ruslan Shlain wrote:

OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=" +
FilePath + ";Extended Properties=""te xt;HDR=NO;FMT=D elimited""");

Try this:

OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=" +
FilePath + ";Extended Properties=\"te xt;HDR=NO;FMT=D elimited\"");

Note the escaped double quotes.
--
gabriel

[Ruslan Shlain]

This worked just fine. Thank you. I am very new to C#. Its my first day. Why
did i have to use the \ ?
"gabriel" <[e-mail]> wrote in message
news:83******** *************** ****@msgid.mega newsservers.com ...

Ruslan Shlain wrote:

OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=" +
FilePath + ";Extended Properties=""te xt;HDR=NO;FMT=D elimited""");

Try this:

OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=" +
FilePath + ";Extended Properties=\"te xt;HDR=NO;FMT=D elimited\"");

Note the escaped double quotes.
--
gabriel

[gabriel]

Ruslan Shlain wrote:

This worked just fine. Thank you. I am very new to C#. Its my first
day. Why did i have to use the \ ?

That is how you place normally "illegal" characters in a string. For
example, you had to use \\ instead of \ in your string because using a
single \ gave you an error.

You could also say something like a = @"c:\t\1\2\3 " without a problem
because the @ tells c# that you are not using excape sequences, so it
does not require double backaslashes.

There are several other escape sequences, for example \r\n for a carriage
return/life feed pair. You should read up on these, they are powerful to
use.

Glad to help.

--
gabriel