How to alter a column name in the db table from frontend?

C# Corner

Kanaparthi Sureshma Reddy

11y995.NET

Hai Sir,

In my database I have a table with columns col1,col2,col3.

I want to give the fourth column i.e..,col4 from the front end(when I click add column button in my front end).

Now the updated table should be like col1,col2,col3,col4 after altering the fourth column.

Is it possible to alter a column from Frontend? If possible what is the stored procedure/query for that?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankaj Kumar Choudhary11y ago
Hello @Sureshma it is possible that add a column in table from front end for this you can use below method

Con.Open();
string Str;
Str = "Alter Table Emp Add " + textBox1.Text + " " + textBox2.Text + "";

SqlCommand Com = new SqlCommand( Str,Con);
Com.ExecuteNonQuery();
Con.Close();

here textbox1 contain column name
textbox2 contain datatype of column . If you have a fixed data type for all column then you don't need this textbox2 you can write direct datatype in query.

Sabyasachi Mishra11y ago

string execSQL = "DECLARE @col4 nvarchar(15); 
                  " + "SET @col4 = '" + Txtboxnewtext.text+ "'; " + 
                  "EXEC ('ALTER TABLE ProductNormalDB  ADD ' + @col4 + ' nvarchar(20) NULL')" 
                  SqlCommand cmd= new SqlCommand(execSQL, con); 
                  cmd.ExecuteNonQuery();