I'm linking a CSV file to an obseravable collection (or at least trying to). My column name is Ticket ID in my CSV file. I'm linking and trying to get data using:

 

string commandString = "SELECT * FROM " + System.IO.Path.GetFileName(m_history) +@" where ""Ticket ID"" = " + _td.TicketID + " ";

when I change it to string commandString = "SELECT * FROM " + System.IO.Path.GetFileName(m_history) it workes without any problems as far as loading, so it is the selection.

What can I look at to troubleshoot?

Thanks

I ended up deleting all of it and re-doing it as just a CSV file. Once I did that, I got the error on Ticket ID, so in the file I changed it to Ticket_ID and changed the program to reflect that and everything is working great. Thanks.

I don't think the field name needs quotes around it and I thought that the parameter value needed single quotes. Something like this:

@" where Ticket ID = '" + _td.TicketID + '";

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

if I do that, I get this error:

System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression 'Ticket ID = '1002833''

I ended up deleting all of it and re-doing it as just a CSV file. Once I did that, I got the error on Ticket ID, so in the file I changed it to Ticket_ID and changed the program to reflect that and everything is working great. Thanks.

Check out if there is a cloumn named Ticket ID - I assumes causes the  there is no blank in this column but an underscore. This might cuase the:

 Syntax error (missing operator) in query expression 'Ticket ID = '1002833''