Check data if exists then update if not exists then insert it to database

Question

1.50/5 (2 votes)

See more:

Dear friends,

If the data is available in the database then update that data ,if not present then insert the data in the database.But here this should be achieved without using any stored procedure.Using c sharp language i need it.

Thanks

Posted 7-Sep-11 1:12am

3796068

Updated 7-Sep-11 1:20am

nagendrathecoder

v2

Add a Solution

Comments

Herman<T>.Instance 7-Sep-11 7:16am

data is database not c#!

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wendelius · Answer 1 · 2011-09-07T01:18:00

You can do this several ways. For example you can first try to update the data and if no rows are updated insert it.

Also you can first try to fetch the data and then make the decision insert/update.

One way is to use table adapter, get the data first to a dataset (or datatable), then make modifications. After that you can call the data adapters update to reflect the changes to the database.

Also, depending on the situation, you may find MERGE transact sql statement useful.

OriginalGriff · Answer 2 · 2011-09-07T01:22:00

Create a connection to the database.
Create a command: SELECT id FROM MyTable WHERE id=idOfRecordToHandle
Run the command: if the number of rows is zero, you need an insert
To Insert:
Create a new command: INSERT INTO MyTable...
To Update:
Create a new command: UPDATE MyTable SET...
Add the appropriate parameter values to whichever command you need.
Run the command.

The actual code depends on the database you are using, but the basics are all there.

nagendrathecoder · Answer 3 · 2011-09-07T01:19:00

Solution 2

So what is the problem?
Check insert and update data in database using C#[^]

Posted 7-Sep-11 1:19am

nagendrathecoder

Prasanta_Prince · Answer 4 · 2011-09-07T01:28:00

Solution 4

1st check with the query . then use @@RowCount in Storeprocedure to show the effect , store it in a variable and check it. or use Count(ColName) and total query if result is grater than zero then process .

Posted 7-Sep-11 1:28am

Prasanta_Prince

Check data if exists then update if not exists then insert it to database

4 solutions

Solution 1

Solution 3

Solution 2

Solution 4

Add your solution here

Preview 0