UPDATE selected row only on asp.net gridview

Question

0.00/5 (No votes)

See more:

Here is the scenario (user clicks update)
TIME IN TIME OUT
PERSON A | 7:30 8:00
PERSON A | 7:35 8:00

I have the following code:

C#

string cmdstr = "update dbo.RecordEmployee set TIME_OUT=@timeout, REMARKS=@editRemarks where EMPLOYEE_NAME =@empname";

what it does and when I update the first record 8:00 will be assigned to the first record, and it will also be assigned to the second record

what I want to achieve here is when the user clicks update, the other record of person A's time out will remain null

so the only selected row updated will have a value

Posted 31-Mar-14 23:40pm

JB0301

Add a Solution

Comments

Pranav-BiTwiser 1-Apr-14 5:45am

totally blank....what u want? plzz elaborate

JB0301 1-Apr-14 5:46am

I want only the selected row to be updated, because for example there are instances that there are duplication of entries, so when I update one, all of them are updated, I want to update only the selected row.

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)

Schatak · Answer 1 · 2014-04-01T01:58:00

You need to have an id column for each row and pass it as parameter in to your query.
The current row id. in your table you may have a unique id for each row.
In grid view where you are having your edit button pass commandName as id
e.g

C#

<asp:button id="btnEdit" text="Edit" runat="server" commandargument="<%#Eval("id")%>" commandname="Edit" xmlns:asp="#unknown" />

in grid view RowCommand event:

C#

using(SqlCommand cmd = new SqlCommand("update dbo.RecordEmployee set TIME_OUT=@timeout, REMARKS=@editRemarks where EMPLOYEE_NAME =@empname and id=@id", conn))
        {
           cmd.Parameters.AddWithValue("@id", id);
           cmd.ExecuteNonQuery();
        }

Member 10641779 · Answer 2 · 2014-04-01T01:45:00

Solution 1

Check here, may be you get any useful information
link here

Posted 1-Apr-14 1:45am

Member 10641779