Creation of table in database based upon ado.net database

[Steven Paplanus]

Part of the application which I am building must support either Access or Sql
Server Databases. The code to generate the databases via sql scripts is
done. However, I have a set of tables (they will all have the same columns,
but have different results since they are doing seperate
calculations/modeling that is being written to each table) that need to be
created based upon selections done by the user. It is easy to create an in
memory table that holds this information and to clone it to hold the results
of each individual model. The problem is how do I take this and create a set
of tables with that structure within either of the two database types. If I
can get a clue on how to take a single in memory table and to then build
either an Access or Sql Server table in an already existing database, I can
work out the rest. Any help would be appreciated, since I am stuck at not
having any good solution for this.

 

[Kerry Moorman]

Steven,

You will need to use the appropriate sql create table commands. Here is how
to do that in Access:

http://msdn2.microsoft.com/en-us/library/aa140011.aspx

Kerry Moorman