writeXmlSchema to MS-Access

[Nicolas]

Hi, I would like to know how should I proceed for the following

I got a dataset and datatable from SQL database displayed in a datagrid
How do I create a Table now in MS_Access base on my Table displayed

Like I want to export this datagrid table design and data to an ms-access
database

I will have previously create a blank database in my bin folder

Thank for your help.

Nicolas

 

[Arne Janning]

Hi, I would like to know how should I proceed for the following

I got a dataset and datatable from SQL database displayed in a datagrid
How do I create a Table now in MS_Access base on my Table displayed

Like I want to export this datagrid table design and data to an ms-access
database

I will have previously create a blank database in my bin folder

Hi Nicolas,

Creating Access-databases is possible with ADOX.
http://support.microsoft.com/?scid=317867

Creating tables in Access-Databases:
http://support.microsoft.com/?scid=252908

You might create a column in Access for each column in your DataGrid and
export the data afterwards.

Cheers

Arne Janning

 

[Cor Ligthert]

Hi Nicolas,

A little addition on the message from Arne,

For the empty blank Access database you would use ADOX with the link Arne
provided.

However for creating the tables you can use as well normal ADONET with
Command.ExecuteNonQuerry

And than the OleDbDataAdapter.update while the rowstates are all Added

http://msdn.microsoft.com/library/d...tml/frlrfsystemdatadatarowstateclasstopic.asp

I hope this helps?

Cor