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

Question

Hai Sir In my database I have a table with columns col1col2col3. 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 col1col2col3col4 after altering the fourth column. Is it possible to alter a column from Frontend? If possible what is the stored procedure/query for that?

Pankaj Kumar Choudhary · Answer

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( StrCon); 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 Mishra · Answer

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();