TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Raghavendra Joshi
NA
44
46.8k
How to compare two datatable columns names
Sep 2 2014 1:59 AM
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
Reply
Answers (
4
)
Occasionally connected Window Form Application in C#
Execute .reg file?