Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- string connStr = "Dsn=Excel Files;dbq=" + file + ";";
- OdbcConnection conn = new OdbcConnection(connStr);
- conn.Open();
- OdbcDataAdapter da = new OdbcDataAdapter("SELECT * FROM [工作表1$]", conn);
- DataTable dt = new DataTable();
- da.Fill(dt);
- dataGridView1.DataSource = dt;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement