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
Pnkl
NA
114
65.7k
Upload Data from ExcelSheet to Sql Database
Apr 16 2016 5:29 AM
Hello Guys,
I have one project of client and client's requirement is that he want to upload data from Excel-sheet to Sql Database using web page in asp.net c#
I know simple how to upload data from Excel-sheet to Sql DB table but Question is that(?) - Suppose 1st time client upload 10 record from 1 sheet to Sql Db and 2nd time client and more 5 record in Excle-Sheet so total record is 15 and then client upload record then I have already 10 old record and this new 15 record upload then total 25 record inserting in Sql Db but I need to upload only last added 5 records only into Sql Db and also client made changes in 1st record then it also be updated in Sql DB.
So how it possible in best way for manage or sync Database
Technology : Asp.net 4.0/4.5, C#, Sql Server
Thanks...
Reply
Answers (
3
)
How to get Last Purchase price in SQL
Image convert into bytes and save in sql