Creating a table in Access via ADO.net

[Shake412]

I'm fairly new to .net and am trying to create an app which uses Access as a back end. I need to create a table dynamically and populate it with data. This is no problem using a DataSet and DataTable, however I want to save this table in an Access DB.

How is this done, good old DAO was CreateTableDef, etc. Is there an equivalent in ADO.net?

Thanks
Paul

 

[dalchri]

Using an object model, you would need to still reference DAO or ADOX through ActiveX.

Using pure ADO.net, you will need to issue everything as a DDL SQL statement:

CREATE TABLE tblCompany (
   ID INTEGER PRIMARY KEY, 
   Name VARCHAR(100), 
   Address VARCHAR(100), 
   City VARCHAR(50), 
   State VARCHAR(5), 
   Zip VARCHAR(10), 
   Phone VARCHAR(50), 
   Fax VARCHAR(50))

Check the help in Access under Microsoft Jet SQL Reference (twice), Data Definition Language or use these three articles on MSDN:

http://msdn.microsoft.com/library/d...y/en-us/dnacc2k/html/acfundsql.asp?frame=true

http://msdn.microsoft.com/library/d...ry/en-us/dnacc2k/html/acintsql.asp?frame=true

http://msdn.microsoft.com/library/d...ry/en-us/dnacc2k/html/acadvsql.asp?frame=true

 

[Shake412]

Thanks dalchri, I'll give it a try.