create database using C#?

Question

is it possible to create access database on a c:\ drive on the click event of the button ???

Create from scratch? Or from an existing one? What exactly are you trying to achieve? — Oded
– Oded, Commented Apr 29, 2011 at 6:17
possible duplicate of How do I create a Microsoft Jet (Access) database without an interop assembly? — Mitch Wheat
– Mitch Wheat, Commented Apr 29, 2011 at 6:23
Depends on where on the C: drive. In the root, you'd likely not be able to because of restrictions on write permissions. — David-W-Fenton
– David-W-Fenton, Commented Apr 30, 2011 at 19:39

Mitch Wheat · Accepted Answer · 2011-04-29 06:26:51Z

2

Yes you can. But this is a duplicate.

To create an Access database from C# code use ADOX: - How to create an Access database by using ADOX and Visual C# .NET:

using System;
using ADOX;

namespace ConsoleApplication1
{
    class Class1
    {
        [STAThread]
        static void Main(string[] args)
        {
            ADOX.CatalogClass cat = new ADOX.CatalogClass();

            cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" +
                   "Data Source=D:\\AccessDB\\NewMDB.mdb;" +
                   "Jet OLEDB:Engine Type=5");

            Console.WriteLine("Database Created Successfully");

            cat = null;

        }
    }
}

[To create an SQL Server database from C# code use SQL Server Management Objects (SMO).]

edited Apr 29, 2011 at 6:26

answered Apr 29, 2011 at 6:20

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Oded Over a year ago

He is looking to create an access database, not SQL Server.

Oded · Accepted Answer · 2011-04-29 06:19:28Z

2

You could use office automation to create a new database and save it to the local drive.

Or if you have a template of a database you could use that and copy it to the local drive.

Without knowing exactly what you are trying to do, a more useful answer can't be given.

answered Apr 29, 2011 at 6:19

Oded

501k102 gold badges900 silver badges1k bronze badges

1 Comment

David-W-Fenton Over a year ago

Why would anybody use automation to create it when you've got Jet available on every copy of Windows since 2000? +1 for the template, though.

Collectives™ on Stack Overflow

create database using C#?

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related