String name = "exx"; String constr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\fingerprint\\exx.csv" + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\";"; OleDbConnection con = new OleDbConnection(constr); OleDbCommand oconn = new OleDbCommand("Select * From [" + name + "$]", con); con.Open(); OleDbDataAdapter sda = new OleDbDataAdapter(oconn); data = new DataTable(); sda.Fill(data); dataGridView1.DataSource = data; ds = new DataSet(); OleDbConnection conn = new OleDbConnection(constr); OleDbCommand oconnn = new OleDbCommand("Select * From [" + name + "$]", conn); OleDbDataAdapter sdaa = new OleDbDataAdapter(oconnn); sda.Fill(ds);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)