Rename Column name in Database

Question

0.00/5 (No votes)

See more:

Hi frnds i need to rename my column name in an database Dynamically Here is my code but i got error as Invalid Column name Pls do help me

C#

try
          {


              foreach (DataGridViewRow row in dataGridView1.Rows)
              {

                  foreach (DataGridViewCell cell in row.Cells)
                  {
                      value1 = row.Cells[0].Value.ToString();
                      value2 = row.Cells[1].Value.ToString();

                      cmd = new SqlCommand("insert into Classify2 (["+comboBox1.SelectedItem.ToString()+"],["+comboBox2.SelectedItem.ToString()+"]) values (@A,@B)", cn.con);
                      cmd.Parameters.AddWithValue("@A", value1.ToString());
                      cmd.Parameters.AddWithValue("@B", value2.ToString());
                      cmd.ExecuteNonQuery();
                      cmd.Dispose();
                      //MessageBox.Show("Execute Process!!");
                  }

              }


          }
          catch (Exception error)
          {

          }

Thank you

Posted 14-Jul-13 21:40pm

usha C

Add a Solution

Comments

usha C 15-Jul-13 3:53am

The Combo box values contain the field names....leave of that i need to rename my database column name using c# code...is it possible to do???

berrymaria 15-Jul-13 3:56am

Have you tried this? Example:

dataTable.Columns["Marks"].ColumnName = "SubjectMarks";

berrymaria 15-Jul-13 3:53am

comboBox1 and comboBox2 contains the name of the columns in the Classify2? What is your problem with that? Why do you need to rename your database column names?

Gishisoft 15-Jul-13 3:53am

In order for you to change/replace or rename the column of your database table. you need to know first the basic syntax of sql. you may refer this link "http://www.techonthenet.com/sql/tables/alter_table.php" on how to rename/change/replace the column name. If you know that it is easier for you to apply it in your c# codes.

SQL ALTER TABLE - Modifying column(s) in a table

Gishisoft 15-Jul-13 3:56am

SQL ALTER TABLE - Modifying column(s) in a table

Syntax #1

To modify a column in an existing table, the SQL ALTER TABLE syntax is:

ALTER TABLE table_name
MODIFY column_name column_type;

For example:

ALTER TABLE supplier
MODIFY supplier_name varchar2(100) not null;

This will modify the column called supplier_name to be a data type of varchar2(100) and force the column to not allow null values.

Syntax #2

To modify multiple columns in an existing table, the SQL ALTER TABLE syntax is:

ALTER TABLE table_name
MODIFY (column_1 column_type,
column_2 column_type,
...
column_n column_type);

For example:

ALTER TABLE supplier
MODIFY (supplier_name varchar2(100) not null,
city varchar2(75));

This will modify both the supplier_name and city columns.

usha C 15-Jul-13 3:58am

I tried working with dis quarries sir thnk u...

Gishisoft 15-Jul-13 20:19pm

sp_rename will help you. pls accept my answer. :)

Gishisoft 15-Jul-13 3:58am

or else like this

Code:

ALTER TABLE tablename RENAME COLUMN OldName TO NewName

or
Code:

ALTER TABLE tablename RENAME OldName TO NewName

Gishisoft 15-Jul-13 4:00am

Yes of course. in above syntax i have given. use that and right it in your new SqlCommand

usha C 15-Jul-13 5:00am

sir am geting the error as
"In correct syntax the Keywork Column" my code is
cmd = new SqlCommand("ALTER TABLE Classify1 RENAME COLUMN A TO new ", cn.con);
cmd.ExecuteNonQuery();
cmd.Dispose();

zenspace 15-Jul-13 4:01am

You can use sp_rename to do that.

usha C 15-Jul-13 5:06am

Hey got op by using sp_rename thanks timmit18

zenspace 15-Jul-13 5:16am

accept my answer, pls :)

1 solution

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)

zenspace · Accepted Answer · 2013-07-14T23:15:00

Solution 2

You can use

SQL

sp_rename

to do that.

Posted 14-Jul-13 23:15pm

zenspace

Updated 14-Jul-13 23:16pm

v2

Comments

usha C 15-Jul-13 5:18am

oops am geting dis error "Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong."

zenspace 15-Jul-13 5:29am

show your code.

usha C 15-Jul-13 5:43am

cmd = new SqlCommand("SP_RENAME 'Classify2.[A]' , '[newtable]', 'COLUMN'", cn.con);
cmd.ExecuteNonQuery();
cmd.Dispose();