How to update Password top (textbox.Text) quantity of rows from database

Question

0.00/5 (No votes)

See more:

Hello,
I have a Text box. I want to Update that quantity of rows from the database the amount I write in the textbox. how will I do it. Please tell the query

Posted 7-Sep-14 21:43pm

Member 10578683

Add a Solution

Comments

OriginalGriff 8-Sep-14 3:52am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.

Member 10578683 8-Sep-14 4:02am

con.Open();
string query2 = "update TOP(1) Inventory set P='" + Label29.Text + "' where [Product]='" + Product.Text + "' and Status='" + Status.Text + "'";
SqlCommand cmd = new SqlCommand(query2, con);
cmd.ExecuteNonQuery();
con.Close();
Hello sorry to not give u proper information
This is my code. Instead of updating the TOP(1) row I want to UPDATE that number of row that are in textbox

Prasad Avunoori 8-Sep-14 3:55am

????????????????????????????

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)

OriginalGriff · Accepted Answer · 2014-09-07T22:22:00

Re: Solution 1.
This is very, very dangerous!
Because you cannot use ORDER BY with an UPDATE command, and SQL is at liberty to process rows in any order unless a specific order is given, you can't guarantee which rows will be updated at all. It may work now, and then fail in spectacular ways in production.

A better solution is to use a cursor, as explained here: http://stackoverflow.com/questions/3439110/sql-server-update-a-table-by-using-order-by[^]

Jawad Shairf · Accepted Answer · 2014-09-07T22:05:00

Solution 1

following C# statement may help

C#

sting Query = "update top (" + txtbox1.Text + ") TableName set Password = '" + txtPassword.Text + "' "

so lets say you have entered 5 in txtbox1 and "abc" in the txtPassword then
Query would be

SQL

update top (5) TableName set Password = 'abc'

Posted 7-Sep-14 22:05pm

Jawad Shairf

Comments

Member 10578683 8-Sep-14 4:10am

Thank U. this is exactly the same I want

OriginalGriff 8-Sep-14 4:23am

Not a good idea: You can't specify the order in which the rows are selected, so you don't know which are going to be the "top 5"

Jawad Shairf 8-Sep-14 5:19am

i agree. its not a good practice
but he may be trying to understand some concept thats why... :)

OriginalGriff 8-Sep-14 5:21am

Doesn't matter - understanding something via a method that will give problems later is not good! :laugh: