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

[quoted text, click to view]

Check out www.queryadataset.com

[quoted text, click to view]

Use database's DDL statements - usually each database supports a special
language that allows you to manipulate the structure.
--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

[quoted text, click to view]

¤ 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
~~~~