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
Azarudeen Ibn Liyakath Ali
NA
31
6.6k
Excel data needs to be updated in existing SQL table
Aug 4 2014 2:29 AM
I am exporting data from excel and show it in gridview and when I click submit, it needs to be updated in existing table.
Below is my excel data
S.No. RequestID Subdivision No Parcel No CUID Status Remarks
1 5 42 55 55 Open Pending
I have successfully exported and show it in Gridview. Now I want to update the same in the existing table(Tablename:ParcelInf).
Below is my table detail
Table ParcelInf(
[RequestID] [int] IDENTITY(1,1) NOT NULL,
FormattedRequestID AS ('CUID' + RIGHT('00' + CAST(RequestID AS VARCHAR(10)),10)),
[SubdivisionNo] [nvarchar](20) NOT NULL,
[ParcelNo] [nvarchar](20) NOT NULL,
[Region] [nvarchar](20) NULL,
[City] [nvarchar](20) NULL,
[Zone] [nvarchar](20) NOT NULL,
[CoordinateSystem] [nvarchar](20) NOT NULL,
[CUID] [nvarchar](20) NULL,
[Status] [nvarchar](20) NULL,
[Remarks] [nvarchar](20) NULL,
[UpdateDate] [date] NULL,
[RequestedBy] [nvarchar] (20) NULL,
FOREIGN KEY (RequestID) REFERENCES RequestInf (RequestID)
Could you please help me on this.
Reply
Answers (
22
)
SQL query to fetch all table names and row/column from db
Generating many empty lines when exporting into SQL