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. 
 

Answers (22)