Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
How to compare two datatable columns names
Raghavendra Joshi
Sep 2 2014 1:59 AM
1.7k
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Occasionally connected Window Form Application in C#
Execute .reg file?