hot to select data and updated it in the same time

Question

1.00/5 (2 votes)

See more:

hello dears
i devlope a web application and i have database that own many tables and i want to get data from one table and update return value in the same time ...( when select row update sepcifc field to new value ) that is i mean ......... any idea for doing it ... i think must to using stored prosdure to do this but how ... i work with command type text not stored and if i must to use stored procedure can you tell me an example

Posted 28-Nov-14 12:38pm

beljk

Add a Solution

Comments

ZurdoDev 28-Nov-14 19:26pm

What exactly is your question? I don't understand what you are saying.

beljk 29-Nov-14 3:04am

i want to select data from employee table and when data returned i want to updated it but in the same time ( my be 2000 row returned , when first row returned , update employee_Status then complete loop second row returned , update employee_Status ....... ETC

2 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)

berrymaria · Answer 1 · 2014-11-28T14:31:00

Solution 1

Try reading this links. It might help you.

C# SqlClient[^]
How To: Connect to SQL using C# and SELECT INSERT UPDATE ?[^]
SQL Insert/Update/Select/Delete using C#[^]

:)

Posted 28-Nov-14 14:31pm

berrymaria

jitendrasingh9415 · Answer 2 · 2014-12-27T00:08:00

Solution 2

Use Merge Statement
you can perform insert, update, or delete operations in a single statement using the MERGE statement

Posted 27-Dec-14 0:08am

jitendrasingh9415