How to add new column to the database by inserting a record?

Try this method

 

 

Create Proc [dbo].[Alter_Table](@Table_Name nvarchar(50),@Col_Name nvarchar(50),@Data_Type nvarchar(50),@IsNull bit)
as
begin
Declare @Query nvarchar(max);
if(@IsNull=0)
Set @Query=N'Alter Table '+QUOTENAME(@Table_Name)+' Add '+QUOTENAME(@Col_Name)+' '+QUOTENAME(@Data_Type)
else
Set @Query=N'Alter Table '+QUOTENAME(@Table_Name)+'Add'+QUOTENAME(@Col_Name)+QUOTENAME(@Data_Type)+'Not Null'


EXECUTE sp_executesql @Query
end 

Hello @Sureshma You can try this stored procedure

 

 

USE [Extra]
GO
/****** Object: StoredProcedure [dbo].[Alter_Table] Script Date: 5/22/2015 3:44:29 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[Alter_Table](@Table_Name nvarchar(50),@Col_Name nvarchar(50),@Data_Type nvarchar(50),@IsNull bit)
as
begin
Declare @Query nvarchar(max);
if(@IsNull=0)
Set @Query=N'Alter Table '+QUOTENAME(@Table_Name)+' Add '+QUOTENAME(@Col_Name)+' '+QUOTENAME(@Data_Type)
else
Set @Query=N'Alter Table '+QUOTENAME(@Table_Name)+'Add'+QUOTENAME(@Col_Name)+QUOTENAME(@Data_Type)+'Not Null'


EXECUTE sp_executesql @Query
end 

create procedure usp_altertable

as

begin

alter table add

end

you can use store procedure to alter table.

 

create procedure usp_altertable

as

begin

             alter table [tablename] add [ProductId] int default 0 NOT NULL  

end 

Hello @Sureshma You can use this method

 

Con.Open();
String Str="Alter Table Table_Name Add Column_Name Datatype";
SqlCommand Com = new SqlCommand( Str,Con);
Com.ExecuteNonQuery() ;

Con.Close();