Import Data from Text and CSV file to DataGridView in .Net

This problem not code problem its only a project setting problem please go to project properties ->build-->Change your platform target to x86

i get this error when select csv file from dialog box "provider cannot be found it may not be properly work" anybody know hw to resolve this??

Correct

This problem not code problem its only a project setting problem please go to project properties ->build-->Change your platform target to x86

Provider cannot be found. it may not be properly installed how to solve the problem

i use vs 2008, i try with interop, but cannot work. can some body give example with library that used.

CSV is ok,but If Text only disply one column ,why not the same with CSV? please help me!

thank you!

You just set Target platform X86 of your application and us jet engine with VS10

This project uses the jet engine, which is not available for VS10. Microsoft has no intention of continuing support for the jet engine. How would this be rewritten without the jet engine, using LINQ, perhaps?

i just tried running this and i get the following error message, "Provider cannot be found. it may not be properly installed." any ideas?

hi Ankur correct url is: https://www.defercode.com/tools/csharp-to-vb.aspx

Hi Toni Thanks.. you can easily convert above example in vb.net by sevral open source for ex. https://www.defercode.com/tools/csharp-to-vb.aspx

it very good. do you have an example in vb.net?

Thanks it works

Hi ankur. your article is good for reading from file. But is it possible to let me know how can i send the datagrid data or an sql query data to a text file in formatted way like header and some line and their sum and then total sum...like printing a bill.i will be very thankful if u reply asap.

can you please help me to create a treeview in the datagrid what we made with csv file???

Thank you..this article helping us a lot..

what is the using directive for ADODB? its showing an error

Thanks for the wonderful article. Just one question, how can I modify the code so I can read the data from an excel sheet? Thanks, Ali

hi devloper I m write your code in my project and its working very good but a prolem is that my most csv file values are seprated by (;) and i m load delimiter in that but its cannot works i sending a code to you please read them and i request u please correct them public static DataTable ParseCSV(string path) { if (!File.Exists(path)) return null; string full = Path.GetFullPath(path); string file = Path.GetFileName(full); string dir = Path.GetDirectoryName(full); //create the "database" connection string string connString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=\"" + dir + "\\\";" + "Extended Properties=\"text;HDR=yes;FMT=Delimited\";"); //create the database query string query = "SELECT * FROM " + file; //create a DataTable to hold the query results DataTable dTable = new DataTable(); //create an OleDbDataAdapter to execute the query OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, connString); try { //fill the DataTable dAdapter.Fill(dTable); } catch (System.Exception ex) { MessageBox.Show(ex.Message); } dAdapter.Dispose(); return dTable; } private void button1_Click(object sender, EventArgs e) { try { DialogResult result = this.openFileDialog1.ShowDialog(); if (result == DialogResult.OK) { string filename = openFileDialog1.FileName; textBox1.Text = filename; } else { MessageBox.Show("dear user please select path"); } DataTable dt = Form1.ParseCSV(textBox1.Text); dataGridView1.DataSource = dt.DefaultView; } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }