Click here to Skip to main content
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 1: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 OriginalGriff 341
1 Marcin Kozub 225
2 Praneet Nadkar 197
3 Sergey Alexandrovich Kryukov 190
4 Shweta N Mishra 161
0 OriginalGriff 8,149
1 Sergey Alexandrovich Kryukov 7,287
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,910


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 5 Jul 2012
Copyright © CodeProject, 1999-2014
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