title: How do I make the user choose the name of the database?
body: <p>in my project i need some changes in my code to give the user choose the name of sql database !</p>
  
  <p>and this is My original code:</p>
  
  <pre><code>            Dim DssD As String
      DssD = TextBox1.Text
  
      Zsql = "CREATE DATABASE my_db ON PRIMARY" +
          "(Name=my_db, filename = 'D:\DB\SQL\my_db.mdf')log on" +
          "(name=my_db_log, filename='D:\DB\SQL\my_db_log.ldf')"
  
      Zcmd = New SqlCommand(Zsql, Zsqlcon)
      Try
          Zsqlcon.Open()
          Zcmd.ExecuteNonQuery()
          Zsqlcon.Close()
  
          MsgBox("Done", MsgBoxStyle.Information, " ZerAllail")
      Catch
          MsgBox("Somthing wrong", MsgBoxStyle.Critical, " ZerAllail")
      End Try
  </code></pre>
  
  <p>its working good but its not create the log fail !</p>