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
Riddhi Valecha
441
3.3k
413.1k
URGENT - Data From Excel To SQL Server from aspx page.
Oct 20 2014 2:34 AM
Hi all,
I need help in making the following application.
My requirement is -
1. The user have an excel sheet (.xls or .csv) files.
2. The user logs in the system and uploads the file. (Using File Upload button).
3. User clicks "OK" Button.
4. On this button, I have to fire an UPDATE and INSERT Query.
-----------
Queries depend on the data in excel sheet.
-------
The excel sheet is as follows (with 4 columns) -
------------
ID
Serial Number
Item Code
Item Name
Assigned To
1
I1
C1
Mouse
Sunil
2
I2
C2
Keyboard
Ajinkya
3
I3
C3
Keyboard
Aditya
Now, on the button click, the system will fire the query as -
Update tablename set itemcode = Item Code, Item Name = Item Name, Assigned To = Assigned To where Serial No = Serial Number
If Serial Number is not there in the database table, then
Insert into temptable (Serial Number, Item Code, Item Name, Assigned To) values
(Serial Number, Item Code, Item Name, Assigned To)
-----------
Points:-
1. I have to use stored procedures. I cannot write queries in aspx.cs file.
2. File extension can be - xls, xlsx, or csv .
-----------
Please help.
Its a bit urgent.
Thanks a lot in advance...
Reply
Answers (
3
)
URGENT - COMMA SEPRATED VALUES EXCEL TO SQL FROM ASPX PAGE.
i want to disply today date as a water mark