searching and updating using C# in one button event

Question

1.00/5 (1 vote)

See more:

I want to search the database and update it on click of one button..
so we have to use multiple quries.. can anyone pls help me .. how to use multiple quries...

Posted 28-Feb-11 19:51pm

codegeekalpha

Add a Solution

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)

coolestCoder · Answer 1 · 2011-02-28T19:54:00

Solution 1

Update <some table name>
Set <col1> = <value1>
where <col2> = <search criteria1> AND <col3> = <search criteria2>

and so on....

Posted 28-Feb-11 19:54pm

coolestCoder

Updated 28-Feb-11 19:56pm

v3

rajivpande86 · Answer 2 · 2011-03-01T12:06:00

Not so sure how far I have got your problem.But if your search and update are related and part of a single button event, then you can rather go for creating a stored procedure.This will also give you the many advantages of using stored procedures.

If you are still reluctant to go for the stored procedures, you can write in your code-behind the two methods - one for Search and the other for Update.Whenever your Search criteria gets satisfied, give a call to Update, else not.And in Search and Update methods, write the one-line parametrized query to interact with the database.

HTH

Regards
Rajeev

Please vote and mark the answer as accepted if this helps you.