rename columnName and change column's data typ

Question

how can I by using Ado.net rename existing column in a table and changing a column's data type?

Answer 1

You can call stored procedure for that, as follows

EXEC sp_rename 'MyTable.OldColumnName', 'NewColumnName'

see section: Renaming a Column in this Article