DataSource problem with C#

Hello again everyone. I am using the OleDb Database Provider and I am reading in csv and dBase database files. I noticed that when the datasource is something like C:\DB\, it works fine and I can read in the data, however if the datasource has a space in it like C:\D B\, it is not able to read in the data from the file. I was wondering if anyone knew if there was a way to fix that or not.

Thanks,
The Major Rager

Double quotes?

Hi, thanks for replying, I was wondering if you could give me an example of where to put the double quotes.

Thanks,
The Major Rager.

I have no idea - I've never used C# - but in DOS:

Code:

---

C:\>cd Program Files
Too many arguments
C:\>cd "Program Files"

C:\Program Files>

---

Well I went into the debugger, it does connect to the correct datasouce, it does show the datasource as C:\D B\, but when it hits the dataReader, it seems to throw an exception. When I manually go into the directory and change the directory to C:\DB, it works.

Okay, so let's see the code. If it's something like this:

Code:

---

get_something("C:\D B", &what);

---

then just change it to

Code:

---

get_something("\"C:\D B\"", &what);

---

Hi Thanks again for taking the time to reply.

The connection string looks like this.

Code:

---


"C:\D B\"

---

my program is dynamic, so when I go in and just change the directory name to C:\DB
my code looks like this

Code:

---

"C:\DB\"

---

and it is able to read it in fine.

Change it to

Code:

---

"\"C:\D B\""

---

and see what happens.

the connection string looked like this in the debugger

Code:

---

"\C:\D B\"

---

and it wasn't even able to connect. When I tried to open the connection
it failed.

It actually connects with the original as

Code:

---

C:\D B\

---

however, when it gets to the dataReader, it fails for some odd reason.

Hey, thanks a lot, I got it to work now. My Select statement was the problem, i just needed to reference the entire file name instead of the datasource with the file name. So I got it, thanks a lot though!

Sincerely,
The Major Rager