Adding table into database
-
Hi all, i have a question: it's possible to fill a dataset with all the tables of my database? thanx
-
Hi all, i have a question: it's possible to fill a dataset with all the tables of my database? thanx
I think it may be possible. The dataset has Tables collection which stores all the tables that u are storing. U have to test it by using maximum number of tables. Regards, Sandy Sekhon
-
Hi all, i have a question: it's possible to fill a dataset with all the tables of my database? thanx
I had the same question a while ago... it's verry simple you take a command object for example : OleDbCommand createTable = new OleDbCommand(); createTable.Connection = aValidConnectionObject; createTable.CommandText = "CREATE TABLE TableName { obj varchar(0), } "; I'm not sure on the sql part... but that is the main idea. I have an example written at school .. have to look into it! Lazar Mihai Highschool student
-
I think it may be possible. The dataset has Tables collection which stores all the tables that u are storing. U have to test it by using maximum number of tables. Regards, Sandy Sekhon
Thanx but i can fill my dataset with select command, and the select command it's possible only at one table. If i have a database with no tables and i want to adding a table by code i dont know how i can do this. Regards