【1】链接数据源(excel文件)
(1)配置链接字符串:
string connString = @"Provider = Microsoft.Jet.OLEDB.4.0; Extended Properties = Excel 8.0; Data Source = C:\Users\BoBo\Desktop\student.xlsx";
(2)创建链接对象:
OleDbConnection oleDbConnection = new OleDbConnection(connString);
【2】打开链接对象
oleDbConnection.Open();
【3】创建adpter和dataset对象并且填充到数据集中
string sql = "select * from [Student$]";//和sqlserver查询语句几乎差不多,就是在表名上需要加上[表名$] OleDbDataAdapter da = new OleDbDataAdapter(sql, oleDbConnection);
DataSet