Question regarding new database

Question

Hi I have form it contains many text boxes. Whatever the data user enters in textboxes i should export it into a new database with a name XYZ. The final project i should deploy into another computer which has sql server. Here is my doubt: Can i create a new database dynamically with name XYZ? If the SQL sever has the XYZ database than i should enter values into the rows only. It means that When ever my exe file is ideployed in any computer First time it should create a database name called XYZ. Give me some idea. Darma

Jignesh Trivedi · Answer

hi yes you can create database dynamically Please refer.. http://www.codeproject.com/Articles/10213/Create-a-SQL-Server-Database-Using-C same as you can also create database table. http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/4929a0a8-0137-45f6-86e8-d11e220048c3 but it is not good idea. you can also create it at the time of installation. hope this help.