DataServiceCollection load from external source
- by spdro
I'm trying to load external data to my entyity.
DataServiceCollection<products> products = new DataServiceCollection<products>();
var adapter = new OleDbDataAdapter("SELECT * FROM [products$]", "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\\products.xlsx;Extended Properties=\"Excel 12.0;HDR=YES;\"");
DataSet ds = new DataSet();
adapter.Fill(ds, "excell");
products.Load(????);
Can anyone help ?
