Reading from a .csv file using oledb c#

Dragging DataGridView and Button controls from the Visual Toolbox to your form designer, then design your form as shown below. Creating a ReadCsv method that allows you to read data from csv file into DataTable in c. Adding a click event handler to the Open button allows you to load data from csv file to DataGridView.

Through this c example, I hope so you've learned how to read csv file in c windows application. I have used it so many times and have not hit any snag.

I have posted this from work hence I cannot post an example snippet. I will do so when I go home this evening. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 10 years, 5 months ago. Active 2 years, 10 months ago. Viewed 48k times. I know this topic is done to death but I am at wits end. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Zulfi Tapia Zulfi Tapia 1 1 gold badge 4 4 silver badges 14 14 bronze badges. Add a comment. Active Oldest Votes.

According to my tests, it would appear that a filename for OLEDB is restricted to a total of 64 characters, this includes the.

Posted May am Richard MacCutchan. Especially since you have made the effort to test this. Richard MacCutchan May am. Testing was easy since I already had a sample app that I use for self-study. Posted May am V. Add your solution here. OK Paste as. Treat my content as plain text, not as HTML. Existing Members Sign in to your account. This email is in use. Do you need your password?

Submit your solution! Stats Jan Schreuder Rate me:. Please Sign up or sign in to vote. A simple class to help you get started with the OleDb Jet Engine to import text files. Download demo project - For example: C.

Copy Code. Jan Schreuder. Technical Lead. I'm a professional software developer for a small company in the Netherlands. I have been developing software since in C, Visual Basic and C. My main focus is now on problem analysis in IT projects. First Prev Next doesn't work perfect..? FreddieH85 Jun Jan Schreuder Jun FreddieH85 1-Jul Paresh B Joshi Oct Jan Schreuder Jul Paul B. Go to top. Layout: fixed fluid. First Prev Next. This was just what I was looking for, but I just got a fieldcount of 1 back in my reader See the results below.