SQL XML Bulk Load

  • Thread starter Thread starter Shane
  • Start date Start date
S

Shane

Hi All,

I have used the above functionality to generate tables from XML using
standard SQL Server 2000. However , as far as I can make out , I can't
use SQL XML Bulk Load in the compact framework unless I write a
wrapper.

Does this make sense to anyone or am I missing out on something?

If I can't make use of SQL XML Bulk Load can any one suggest any SQL
Server CE functionality I can access via C# that will enable
relatively simple generation of Tables on SQL Server CE on a PDA ?

Thanks in advance,
Shane
 
If you create a web service that returns a dataset with data, you could
store this dataset data in the existing table. A code sample is available
here (it reads dataset from disk, but of course this does not change
anything): http://www.alexfeinman.com/download.asp?doc=ImportDataset.zip
As for creating a table from a dataset schema - I've done this, but don't
have a public sample. The process is not very complicated though.
 
As for creating a table from a dataset schema - I've done this, but don't
have a public sample. The process is not very complicated though.
Click to expand...

Any hints as to what this process might be ?

Shane
 
I've done it too... and the process is based on create an SQL Create Table
statement based on the DataColumns information of the DataTable contained on
the DataSet.
It's not complicated as Alex said.

Hope This Helps!
Roberto
 
Back
Top