C# SqlCommand syntax for this SQL command

Question

I am trying to turn this SQL example command into a C # SqlCommand:

if not exists (select column_name
               from INFORMATION_SCHEMA.columns
               where table_name = 'TotalHeals'
                 and column_name = '"+Healee+"')
    alter table TotalHeals add +Healee+ int

What I have so far

// TO DO check to see if column exists instead of throwing error
cmd2 = new SqlCommand("ALTER TABLE TotalHeals ADD " + Healee + " INT",openCon);
cmd2.ExecuteNonQuery();

I am completely lost how to code the if not exists statement. Any help?

I am dynamically adding columns on the fly and do not want to just catch the exception when the column already exists — Jeremiah Stillings
– Jeremiah Stillings, Commented May 23, 2016 at 3:17

cableload · Accepted Answer · 2016-05-23 03:23:07Z

1

You need to execute your first select query to check whether the column exist like this

cmd = new SqlCommand("Select count(*) from
                     INFORMATION_SCHEMA.columns
                     where
                     table_name = 'TotalHeals'
                     and column_name = '"+Healee+"',openCon);
int output=Convert.ToInt32(cmd.ExecuteScalar());

if (output>0)
 // column already present....handle that case..
else
//alter your table to add the column

answered May 23, 2016 at 3:23

cableload

4,4156 gold badges42 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Jeremiah Stillings Over a year ago

I am throwing a Exception thrown: 'System.FormatException' in mscorlib.dll on the int output=Convert.ToInt32(cmd.ExecuteScalar()); line

cableload Over a year ago

are you doing select count(*) ?

Jeremiah Stillings Over a year ago

Caught your code mid edit... testing the updated version

Jeremiah Stillings Over a year ago

Thank you very much for the help! I had to change this '"+Healee+"'",openCon);

Collectives™ on Stack Overflow

C# SqlCommand syntax for this SQL command

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related