How to create new database in ASP.NET?

Question

1.00/5 (1 vote)

See more:

My goal is to create a new database for new brands that the user will add on the website. I've created a code for doing such task but it is giving me this exception: An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code Additional information: Incorrect syntax near 'char'.

I already looked at the code several times but i still can't find the root cause of the problem.

What I have tried:

C#

public static void CreateGuitarBrandsDatabase(string brand)
{
    SqlConnection createBrandData = new SqlConnection(@"Data Source=Y560\SQLEXPRESS;Initial Catalog=GuitarItemsDB;Integrated Security=True");
    createBrandData.Open();
    SqlCommand cmdBrandData = new SqlCommand("CREATE TABLE guitarItem" + brand + "(id int,type char(50),model char(50),price float,image1 char(255),image2 char(255),description text,neck type char(100),body char(100), fretboard char(100),fret char(50),bridge char(100),neck pickup char(100),bridge pickup char(100),hardware_color char(50));", createBrandData);
    cmdBrandData.ExecuteNonQuery();//The exception seems to be pointing right here
    createBrandData.Close();
}

Posted 16-Feb-17 16:42pm

BebeSaiyan

Updated 16-Feb-17 18:34pm

Add a Solution

Comments

dan!sh 16-Feb-17 23:24pm

Does your query work in SSMS?

4 solutions

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)

Member 13006470 · Answer 1 · 2017-02-16T17:40:00

Solution 1

neck type should be [neck type] or necktype

Posted 16-Feb-17 17:40pm

Member 13006470

Updated 16-Feb-17 18:39pm

v2

Comments

Karthik_Mahalingam 17-Feb-17 0:39am

5

Garth J Lancaster · Answer 2 · 2017-02-16T17:58:00

Solution 2

as an extension to 'Solution 1', you also have

'neck pickup'
'bridge pickup'

which shouldnt have a space between them

Posted 16-Feb-17 17:58pm

Garth J Lancaster

Bryian Tan · Answer 3 · 2017-02-16T18:14:00

Assuming you want to keep the space in the column name.

neck type should be [neck type]
neck pickup should be [neck pickup]
bridge pickup should be [bridge pickup]

I also suggest to add bracket to description = [description] (not an issue)

Also, please take a look at the article SQL Injection and Cross-Site Scripting[^] when you have time.

Peter Leow · Answer 4 · 2017-02-16T18:34:00

This is very very basic, "NO space in an identifier", be it a variable name, object name, function name, class name, table name, or field name. You may get away with it by enclosing such an identifier with back tick in MySQL or [] in SQL Server, but what the heck. Just don't include a space.
If a name consists of multiple words, use underscore to separate them or Camel case - Wikipedia[^].

How to create new database in ASP.NET?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0