Community discussion forum

How to create Database and Table at runtime in SQL-Server.

• • Reply

  2 years ago

  by Nishantha

  N.K. Rathnayke

  , Sri Lanka

  Joined 3 years ago

  Dear Sir,

   

  Please somebody tell me how to create Database and table at runtime by use vb.net with SQL -Server

   

  Thank you,

  Nishantha.

  Report abuse
• • Reply

  2 years ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 2 years ago

  You should be able to make an ADO.Net connection to the database and issue the DDL commands that you need to create your database and table. For example:

          Dim conn As New SqlConnection("Persist Security Info=True;User ID=tim;Initial Catalog=master;Data Source=YourSQLServer")
          Dim cmdDB As New SqlCommand("CREATE DATABASE [NewDatabaseName]", conn)
          DBConnection.Open()
   cmdDB.ExecuteNonQuery
  
  
  

  Next, connect to your new database and issue the CREATE TABLE command.

   

  Report abuse
• • Reply

  2 years ago

  by Nishantha

  N.K. Rathnayke

  , Sri Lanka

  Joined 3 years ago

  Dear TimL

  Firstly I like to very thanks full to your code. But I have problem as I’m new to vb.net so that I’m unable to understand some code lines without full code. If you can send me full code, which I’m very thanks full to you.

  Thank you,

  Nishantha

   

  Report abuse
• • Reply

  2 years ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 2 years ago

  Unfortunately, I don't have time to write a full solution but if you're new to this, I suggest you read up a bit on ADO.Net. James has a good article here: http://www.developerfusion.co.uk/show/4278/1/

  The important point for you is to use the 'CREATE DATABASE' and 'CREATE TABLE' SQL to do what you need to do.

  Tim

  Report abuse