Creating a new table...

[Amir Jalaly]

how can I create new table in a database with ado.net
programically?
we have a dataset ,connection and dataadaptor.
Has ado.net a function for this work.

please help me.
Regards' Amir Jalaly

 

[Miha Markic]

Hi Amir,

ADO.NET has no such functionality (other than use sql stataments for this
purpose).
You might want to use ADOX ActiveX object.
Check out the article
HOW TO: Create an Access Database Using ADOX and Visual C# .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;317881&Product=vcSnet

 

[Cor]

Hi Amir,

how can I create new table in a database with ado.net
programically?
we have a dataset ,connection and dataadaptor.
Has ado.net a function for this work.

You can make tables in ADO net using the sqlStatements "CREATE TABLE"

Those have you to process using the OLeDB or SQL command.executeNonQueury()

I hope this helps?

Cor

 

[Paul Clement]

¤ how can I create new table in a database with ado.net
¤ programically?
¤ we have a dataset ,connection and dataadaptor.
¤ Has ado.net a function for this work.

You may want to indicated why kind of database you are working with.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)