Click here to Skip to main content
11,709,537 members (51,149 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Excel table
Hi,
I am uploading an excel sheet into sql table.
I want to upload a data without duplicates.
If the data already exists in the table, that should update the table.
If the data doesn't exists in the table, then that should append the table.
Kindly say the solution for it.
I tried with many codes..All flopped...
Posted 5-Jul-12 0:33am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

IF EXISTS(SELECT * FROM table WHERE id1 = @id)
  BEGIN
     -- do the update because you know it exists
     UPDATE Table SET field1 = @field1, etc.
  END
ELSE
  BEGIN
    -- do an insert, because it does not exist
    INSERT INTO table ...
  END
  Permalink  
Comments
comeshyamala at 6-Jul-12 3:26am
   
Thank you so much...But i want to know the code in asp.net...
I dont know how to connect to sql by using asp.net
ryanb31 at 6-Jul-12 7:52am
   
There is a lot to it, more than I can give you here. Do you not have a SQL class already to connect to db? Look into the SQLDataSource and SQLCommand objects. You will use those.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 525
1 OriginalGriff 250
2 Peter Leow 219
3 Maciej Los 185
4 Mika Wendelius 160
0 OriginalGriff 9,428
1 Sergey Alexandrovich Kryukov 9,037
2 CPallini 5,189
3 Maciej Los 4,991
4 Mika Wendelius 3,856


Advertise | Privacy | Mobile
Web03 | 2.8.150819.1 | Last Updated 5 Jul 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100