quotations for integer value

Question

1.00/5 (1 vote)

See more:

Hello,
this is c# code , the problem in the quotations for j1 .
please help .

C#

for (int j1=0;j1<y;j1++)
   {


          con.Open();
           using (SqlCommand command = new SqlCommand("alter table [empmaster] add [td['"+j1+"']] varchar(50) default 0 NOT NULL"))
           {
               command.Connection = con;
               command.ExecuteNonQuery();
           }
    }

Posted 22-Dec-14 21:20pm

loai_maane

Add a Solution

Comments

Thomas Daniels 23-Dec-14 3:21am

What exactly is the problem?

loai_maane 23-Dec-14 3:26am

Unclosed quotation mark after the character string 'td['0'] varchar(50) default 0 NOT NULL'.
Incorrect syntax near 'td['0'] varchar(50) default 0 NOT NULL'.
this is the error

Sibasisjena 23-Dec-14 3:27am

Hi loai_maane,

What exactly you are trying to do? You want to add column or what?

loai_maane 23-Dec-14 3:30am

hello dear,
yes i created table and i want to add columns .

Sibasisjena 23-Dec-14 3:38am

Hi loai_maane,
Please do check in sql server management studio before create dynamic query in c# code. That will help you a lot

2 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)

Mehdi Gholam · Accepted Answer · 2014-12-22T21:32:00

ALTER TABLE takes a column name : http://msdn.microsoft.com/en-us/library/ms190273.aspx[^]

SQL

alter table [empmaster] add td1 varchar(50) default 0 NOT NULL

If you intend to add numbers to the end of the name then you should do :

C#

using (SqlCommand command = new SqlCommand("alter table [empmaster] add td"+j1+" varchar(50) default 0 NOT NULL"))
{
...

Sibasisjena · Accepted Answer · 2014-12-22T21:36:00

SQL

for (int j1=0;j1<y;j1++)
   {


          con.Open();
           using (SqlCommand command = new SqlCommand("alter table [empmaster] add [td"+j1+"] varchar(50) default 0 NOT NULL"))
           {
               command.Connection = con;
               command.ExecuteNonQuery();
           }
    }

quotations for integer value

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0