Add new DataTable to a database???

[fiaolle]

Hi I wonder if I can make a table to an existing database without using the statement "Create Table". I want to use the Datatable with DataColumns and DataRows I have made. Is there a way I can connect to the database in code and add this DataTable? If so, please tell me Fia

[Dave Kreskowiak]

I don't believe you can do that. I think you have to create the table with SQL code first. Dave Kreskowiak Microsoft MVP - Visual Basic

[Ray Cassick]

As far as I know you can't do it that way. You have to create tables using the proper SQL syntax. From what I remember when talking to a SQL engineer @ MS even the SQL Enterprise manager just talks SQL to the DB engine when creating and deleting tables.

---

My Blog[^]
FFRF[^]

---

[Dave Kreskowiak]

That's part of the SQL specification. The engine and system databases are managed by the same language used to manipulate user databases. Dave Kreskowiak Microsoft MVP - Visual Basic

[master napishi ru]

you can add reference to "Microsoft.SqlServer.Smo" and use it's classes to manage (create, alter, drop) any SQLServer objects - tables, procedures, constraints, indexes, foreign keys etc. Very useful.

[Dave Kreskowiak]

That works if your using SQL Server 2005. Other versions, I recommend using the SQL method. In either case, he wanted to do it just by adding a new DataTabel object to his DataSet, which won.t work at all. Dave Kreskowiak Microsoft MVP - Visual Basic