Adding new column in exist table

Question

I am working on visual studio 2010 Professional i have table and i want to add new column and name the the column by get it from a form that contain texttbox then i enter column name and then click on add button and then i would have a new column added to my exist table

Kunal Vaishya · Answer

Dear do like this Alter Table TableName Add FldName FieldType Example Alter Table Company Add ComapnyAddress VarChar(50)

Kunal Vaishya · Answer

String sCon; sCon = Connection String; System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection (sCon); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText =  Alter Table Company Add ComapnyAddress VarChar(50) ; cmd.Connection = cn; cn.Open(); cmd.ExecuteNonQuery();

younis abdeljawwad · Answer

how to do and execute this sql statement as i use c# language in windows application