How to compare two datatable columns names

Question

HI,

I would like to compare columns of 2 data table.

my 1st data table:

app_ID	int	True	AppID	Both
app_Name	varchar	True	AppName	Both
app_Adress	varchar	True	AppAddress	Both
app_Lattitude	varbinary	True	AppLatitude	Both
app_Longitude	varbinary	True	AppLongitude	Both
app_Gender	char	false
app_IsApplicationCorrect	bit	false

and my 2nd table:

	app_ID	int
	app_Salutation	varchar
	app_Name	varchar
	app_Adress	varchar
	app_Lattitude	varbinary
	app_Longitude	varbinary
	app_Gender	char
	app_IsApplicationCorrect	bit
	app_IsWorkingProper	bit

i want to compare 1st and 2nd tables 1st column and check for new data if available and add the data from 1st table to 2nd table...

OUT PUT should be:

app_ID	int	True	AppID	Both
app_Salutation	varchar	false
app_Name	varchar	True	AppName	Both
app_Adress	varchar	True	AppAddress	Both
app_Lattitude	varbinary	True	AppLatitude	Both
app_Longitude	varbinary	True	AppLongitude	Both
app_Gender	char	false
app_IsApplicationCorrect	bit	false
app_IsWorkingProper	bit	false

Mohammad Imran · Answer

I do not under stand your query means do not understand table1 column

Vasanth Krishnan · Answer

Having the string collection as StringCollection lsttable1ColumnValues = new StringCollection(); StringCollection lsttable2ColumnValues = new StringCollection(); Add that particular column values to the list //Add the table 1 value in the list foreach (DataRow drTable1 in dtTable1.Rows) { lsttable1ColumnValues.Add(drTable1["Column1"].ToString()); } foreach (DataRow drTable1 in dtTable1.Rows) { lsttable2ColumnValues.Add(drTable1["Column1"].ToString()); } Now u can compare the list that are common in the two list and achieve what u want. Thanks

Raghavendra Joshi · Answer

in C# itself i got the table data from database.

Vasanth Krishnan · Answer

Hi Can you please let me know whether u need to achieve this in c# or in sql server

How to compare two datatable columns names

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)