Can I create tables in an existing database or manage a dynamic dataset?

[gobis]

Hello all,

I am working on a csharp database application that should give its end
users the ability to create new tables related to existing ones or
even create the database structure completely on their own.

I know how to do that by creating a DataSet object and adding tables
and relations to it, etc. but I found no way of creating queries on
this dataset created within the application.

I know how to connect to an exiting (Access) database and fill/edit/
update tables and call up queries, but then I see no way of creating
new tables within that existing database and creating table adapters
for connecting to those new tables.

According to my brief search over newsgroups, a few other people asked
about ways to create new tables on data servers and they seem to have
gotten negative answers.

If anyone can tell me the ways of
a) creating queries on a dataset created within an application
b) creating new tables in a database managed by an application

I will be grateful.

Best wishes for everyone,
Hurol Aslan

 

[Miha Markic]

If anyone can tell me the ways of
a) creating queries on a dataset created within an application

Check out www.queryadataset.com

b) creating new tables in a database managed by an application

Use database's DDL statements - usually each database supports a special
language that allows you to manipulate the structure.

 

[Paul Clement]

¤ Hello all,
¤
¤ I am working on a csharp database application that should give its end
¤ users the ability to create new tables related to existing ones or
¤ even create the database structure completely on their own.
¤
¤ I know how to do that by creating a DataSet object and adding tables
¤ and relations to it, etc. but I found no way of creating queries on
¤ this dataset created within the application.
¤
¤ I know how to connect to an exiting (Access) database and fill/edit/
¤ update tables and call up queries, but then I see no way of creating
¤ new tables within that existing database and creating table adapters
¤ for connecting to those new tables.
¤
¤ According to my brief search over newsgroups, a few other people asked
¤ about ways to create new tables on data servers and they seem to have
¤ gotten negative answers.
¤
¤ If anyone can tell me the ways of
¤ a) creating queries on a dataset created within an application
¤ b) creating new tables in a database managed by an application
¤

See if the following helps:

Fundamental Microsoft Jet SQL for Access 2000
http://msdn2.microsoft.com/en-us/library/aa140011(office.10).aspx

Intermediate Microsoft Jet SQL for Access 2000
http://msdn2.microsoft.com/en-us/library/aa140015(office.10).aspx


Paul
~~~~
Microsoft MVP (Visual Basic)