locked
How do i create a template (Table Structure) from the existing Table of MS-Access DataBase to create an Empty Table at RunTime ? RRS feed

  • Question

  • C#:
         I'm using MS-Access as a BackEnd DataBase to my Project. Sometimes i need to Create a Empty Table with Some Fields from the existing Table. The DataTable structure should be the same in the Existing Table and the Newly created Table file.
    ---Sri's
    Saturday, September 19, 2009 2:55 PM

Answers

All replies

  • SQL supports creating tables dynamically [which you can do in code], you can make a DataTable structure of that in code as well.

    John Grove - TFD Group, Senior Software Engineer, EI Division, http://www.tfdg.com
    Saturday, September 19, 2009 3:36 PM
  • Hi,

    Does the article work for you:

    Create an Access Database in C#

    It talks about how to use  Microsoft ADO Ext. X.X for DDL and Security to manipulate access database.

    Harry
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Marked as answer by Harry Zhu Wednesday, September 30, 2009 7:32 AM
    Friday, September 25, 2009 5:52 AM
  • Nice link Harry!
    John Grove - TFD Group, Senior Software Engineer, EI Division, http://www.tfdg.com
    Wednesday, September 30, 2009 12:53 PM
  • Hi John ,

    Thanks!

    Harry
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Thursday, October 1, 2009 1:30 AM