affect the last enter value with the data that is shown in the gridview using asp.net

Question

0.00/5 (No votes)

See more:

affect the last enter value with the data that is shown in the gridview using asp.net

i show the data in the girdview as

item price qty

pen 10 1

pencil 20 1

if i enter the value in the textbox as 2 i need to change the pencil quantity as 2

item price qty

pen 10 1

pencil 20 2

Posted 22-Jul-15 19:56pm

subramanianselvi1

Add a Solution

Comments

Suvendu Shekhar Giri 23-Jul-15 5:00am

What is your datasource?
Can share the code block where you are binding the gridview?

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)

Aravindba · Answer 1 · 2015-07-22T23:00:00

Hi U need to specify which item qty need to update,if u update latest entry,then u can't update old values any more,so better to use where condition for update qty value.

If u want to update lastly added value,then u have set id column in that table and make as identity "yes" so it automatic increment id value once insert value in that table,u no need to insert id value,then when u update use following query

SQL

Update [Trail] set qty='"+ textbox.text.trim +"' where ID= (select max(ID) from  [Trail])

SQL

select max(ID) from  [Trail]

this query return lastly added row.

Regards
Aravind

Veeshal Mali · Answer 2 · 2015-07-23T22:10:00

If you want to show the affected result in the gridview just with updating.
You shoud call the DataBpund() Method of grid view at end of the code of update record.
like this.

protectd void btnUpdate_Click(object sender, EventArgs e)
{
try
{
//Here your code for Update record
}
Catch(Exception ex)
{

}
gridView1.DataBound();
}

affect the last enter value with the data that is shown in the gridview using asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0