By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

Database Creating

OuTCasT
100+
P: 374
Hi all.

I want to ask if its possible if we could have a form that would require user input in textboxes and with that information create the dbName and dbTables ?

for example these were required to fill in [ ] = textbox :

Company Name: [dbName]

Earnings: [dbEarningsTable]

Bonus: [dbEarningsTable].[dbEarningTableColumn]
Salary: [dbEarningsTable].[dbEearningsTableColumn]

is something like this possible.

each time they create a NEW COMPANY a new database is created with that name being the new company name and then they got to populate it with there own details? ??
Apr 7 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
Is it possible? Yes.

Is that form possible in MS-SQL Server, No.

You have to create the form using a front-end tool and use the info supplied on that form to create your DB and tables.

-- CK
Apr 7 '08 #2

OuTCasT
100+
P: 374
Is it possible? Yes.

Is that form possible in MS-SQL Server, No.

You have to create the form using a front-end tool and use the info supplied on that form to create your DB and tables.

-- CK
Ok so ive created like a couple of screens that will act as a wizard at creation of company etc.

the sql statement would be structured how ?

Expand|Select|Wrap|Line Numbers
  1. Create Table ' " & txtCompanyName.text & " ' 
Apr 8 '08 #3

ck9663
Expert 2.5K+
P: 2,878
Ok so ive created like a couple of screens that will act as a wizard at creation of company etc.

the sql statement would be structured how ?

Expand|Select|Wrap|Line Numbers
  1. Create Table ' " & txtCompanyName.text & " ' 

Looks like you're using VB/ASP/.net apps. But you're in the right direction. You just have to place that entire string into a variable that you can pass to your connection object.

-- CK
Apr 9 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.