ado.net - SQL Server CE and C#; Populate a DataSet with ALL the Tables from a SQL Server CE DB -
how populate dataset tables sql server ce database. possible in 1 sql select statement?
i know can call separate select statements names of table need data need generic solution dumps tables sql server ce database dataset.
thanks
select 'select * ' + table_name information_schema.tables
- run queries.
- run each query, dumping in same dataset.
this works easy.
edit: think had problems trying run multiple queries in single go sql ce (even line terminator ;
).
Comments
Post a Comment