how to marge two database table column value and save anothe

Question

Dear sir, how to marge two database table column value and save another table ..please share complate code. Regards, Indradeo

indradeo kumar · Answer

i have share my table structure. while user insert value from text boxes then taid generate combination of empid. empid:-9412 then taid:-94121 CREATE TABLE [dbo].[TA] ( [taId] INT IDENTITY (1, 1) NOT NULL, [empid] INT NULL, [firstname] VARCHAR (50) NULL, [lastname] VARCHAR (50) NULL, [designation] VARCHAR (50) NULL, [department] VARCHAR (50) NULL, [mobile] NCHAR (10) NULL, [level] NCHAR (10) NULL, [ Basic_Pay] NCHAR (10) NULL, [ Tour_Comm_Dt] NCHAR (10) NULL, [ Tour_No] NCHAR (10) NULL, [Advance_from_Proj] NCHAR (10) NULL, PRIMARY KEY CLUSTERED ([taId] ASC) );

indradeo kumar · Answer

i have share my table structure. while user insert value from text boxes then taid generate combination of empid. empid:-9412 then taid:-94121 CREATE TABLE [dbo].[TA] ( [taId] INT IDENTITY (1, 1) NOT NULL, [empid] INT NULL, [firstname] VARCHAR (50) NULL, [lastname] VARCHAR (50) NULL, [designation] VARCHAR (50) NULL, [department] VARCHAR (50) NULL, [mobile] NCHAR (10) NULL, [level] NCHAR (10) NULL, [ Basic_Pay] NCHAR (10) NULL, [ Tour_Comm_Dt] NCHAR (10) NULL, [ Tour_No] NCHAR (10) NULL, [Advance_from_Proj] NCHAR (10) NULL, PRIMARY KEY CLUSTERED ([taId] ASC) );

Laxmidhar Sahoo · Answer

hi is there any comon column value in the two tables or there is no common column value

Amit Gupta · Answer

You can merge two or more datatable like dataTable1.Merge(dataTable2);