Create Sql Database Using Value Of TextBox

Question

1.00/5 (1 vote)

See more:

VB

I want to know that How can I create Sql Database using value
of a textbox in vb.net application

Indranil

Posted 1-Feb-13 4:57am

hspl

Add a Solution

Comments

Zoltán Zörgő 1-Feb-13 11:00am

Which of the databases's properties will be the value of the textbox?
Or you want to enter a whole sql script in the textbox and execute - what will stop you from issuing a drop database command?

2 solutions

Solution 1

Hi,

Below code, I have passed the text box value as database name,

VB

Private Sub btnCreateDataBase_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCreateDataBase.Click
        Dim conStr As String = "Server=Myserver;Database=;Trusted_Connection = yes"
        Dim objCon As New SqlConnection(conStr)
        Dim obj As SqlCommand
        Dim strSQL As String

        ' Create the database
        objCon.Open()
        obj = objCon.CreateCommand()
        strSQL = "CREATE DATABASE _" + TextBox1.text
        ' Execute
        obj.CommandText = strSQL
        Try
            obj.ExecuteNonQuery()
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
        
        objCon.Close()
        objCon = Nothing
End Sub

Posted 1-Feb-13 5:06am

Muthuraja Irullandi

Updated 4-Feb-13 4:34am

v2

Comments

hspl 4-Feb-13 1:45am

Sir,
I used value of TextBox1.text = 1001
But when i click on CreateDatabase button an error shows that

Incorrect Syntax Near '1001'.

hspl 4-Feb-13 6:58am

Sir waiting for your reply against my comment....

Muthuraja Irullandi 4-Feb-13 7:12am

Hi,
You have to specify the database Name in the text box. So that the query will create the database in the SQL Server.

Muthuraja Irullandi 4-Feb-13 7:13am

Also try with the below connection string
Dim conStr As String = "Server=Myserver;Database=master;Trusted_Connection = yes"

hspl 4-Feb-13 10:03am

Sir
I want to create database with the numeric value of a textbox
So how can i do that.....

Muthuraja Irullandi 4-Feb-13 10:33am

Hi,
As per the database naming rules you cannot give the numeric as database name . But you can give the name as below.

CREATE DATABASE _1234

Please see the modified solution

hspl 5-Feb-13 1:16am

Dear Sir,
I am sorry to say that as per database naming rules we cannot give the numeric as database name which you have told in your last comment.
Well i feel happy that i solved the problem with my own tricks and able to create
NUMERIC as database name, below is the my solution......

Private Sub btnCreateDataBase_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCreateDataBase.Click

DIM dbname AS STRING
dbname = TEXTBOX1.TEXT
Dim conStr As String = "Server=Myserver;Database=;Trusted_Connection = yes"
Dim objCon As New SqlConnection(conStr)
Dim obj As SqlCommand
Dim strSQL As String

' Create the database
objCon.Open()
obj = objCon.CreateCommand()
strSQL = "CREATE DATABASE [" + dbname + "]"
' Execute
obj.CommandText = strSQL
Try
obj.ExecuteNonQuery()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try

objCon.Close()
objCon = Nothing
End Sub

After running this it will successfully create the database having name in numeric.
Indranil

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

hspl · Accepted Answer · 2013-02-04T19:17:00

Private Sub btnCreateDataBase_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCreateDataBase.Click

DIM dbname AS STRING
dbname = TEXTBOX1.TEXT
Dim conStr As String = "Server=Myserver;Database=;Trusted_Connection = yes"
Dim objCon As New SqlConnection(conStr)
Dim obj As SqlCommand
Dim strSQL As String

' Create the database
objCon.Open()
obj = objCon.CreateCommand()
strSQL = "CREATE DATABASE [" + dbname + "]"
' Execute
obj.CommandText = strSQL
Try
obj.ExecuteNonQuery()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try

objCon.Close()
objCon = Nothing
End Sub

After running this it will successfully create the database having name in numeric.
Indranil