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
thenmozhi s
NA
3
738
How to add External Content type To customSharePoint list ?
May 13 2016 3:09 AM
We have a requirement Creating External Content type in sharpoint 2013 based on that SQL database Table.
For example in sql i have four database(db1,db2,db3,db4) and sharepoint i have 4 custom list(list1,list2,list3,list4).
db1 having 4 columns
EMPID NAME ADDRESS PhoneNumber
1 Robert Bangalore 9645612345
2 George Chennai 9745612345
3 John Bangalore 9845612345
Same data are in sharepoint list1(Customlist Name : Employeedatabase) also but exept PhoneNumber column.
So i need to add this Phone Number column to Employeedatabase custom list through External content type.
when i add this External Content Type to Employeedatabase custom list PhoneNumber column should be added and Based on that EMPID in that same row PhoneNumber should be update.
How i can achieve this through code without using sharepoint designer?
This is just example like that we are having more database with more columns.
Please anyone share sample code snippet or any link for this.
Thanks in advance.
Reply
Answers (
2
)
enum int without casting
fix a time and date to fill and edit the gridview and save ?