How can we delete a record from a grid view and update related some columns data in database on button click

Question

0.00/5 (No votes)

See more:

Hello everyone..

My problem is I have a delete button in grid view. if i click on delete button that particular row need to be deleted and some columns of that row need to be updated which on same button click.

example if i click delete that row that row needs to be deleted..that row has Status column which is active before deleting, after clicking delete that column status should change to delete, and row should be deleted and one more column that id should change to null.

What I have tried:

very confused how to do both operations on single click

help??
suggestions??

Posted 26-Feb-17 17:19pm

Mahesh2223

Updated 26-Feb-17 19:04pm

Add a Solution

Comments

Karthik_Mahalingam 27-Feb-17 0:07am

rebind the data to the gridview

Mahesh2223 27-Feb-17 0:09am

how to do??

Karthik_Mahalingam 27-Feb-17 0:11am

where you are getting the id

Mahesh2223 27-Feb-17 0:14am

Yes thats what i m confused.. if i get the id also, how to do both operations on single click

Karthik_Mahalingam 27-Feb-17 0:15am

how you are deleting a particular row?
is there a check box?

Mahesh2223 27-Feb-17 0:16am

on a button click. every row has a delete button

Karthik_Mahalingam 27-Feb-17 0:22am

so the button is inside each row ?

Mahesh2223 27-Feb-17 0:23am

yes every row has button delete

Karthik_Mahalingam 27-Feb-17 0:15am

how do you get the id?

Mahesh2223 27-Feb-17 0:22am

i wil change the gridview using command field. using show delete button. and write row bound event. but that only deletes the row, how to update the status from active to deleted on click

Karthik_Mahalingam 27-Feb-17 0:26am

unless you show the mark up its difficult to understand your scenario.

Karthik_Mahalingam 27-Feb-17 0:10am

is the delete button inside the grid?

Mahesh2223 27-Feb-17 0:11am

yes inside grid

Karthik_Mahalingam 27-Feb-17 0:11am

id is not accessed inside the event

Mahesh2223 27-Feb-17 0:13am

yes id is not accessed and that row needs to deleted.. the status needs to change from active to deleted.. how to do both on one click

Karthik_Mahalingam 27-Feb-17 0:25am

post the gridview code
markup

Karthik_Mahalingam 27-Feb-17 0:28am

which is the id column

Mahesh2223 27-Feb-17 0:29am

no id column, and so confused how to do

Karthik_Mahalingam 27-Feb-17 0:35am

add the id column to the column list.

Mahesh2223 27-Feb-17 0:31am

the thing is on clicking delete. that row needs to be deleted, and status of that should change to deleted and same should display in grid

Karthik_Mahalingam 27-Feb-17 0:35am

without having the id , how will you refer the line

Mahesh2223 27-Feb-17 0:40am

yes after adding id column. we can access. but on single click. we can delete the row, how to update the status to deleted from active

Karthik_Mahalingam 27-Feb-17 0:42am

string Query = "update DeviceDetails set GroupId = NULL, InUse = 0 , Status = 'Deleted' Where Id = @Id";

cmd.Parameters.Add("@Id",id);

Mahesh2223 27-Feb-17 0:45am

can the id column be hidden without showing in grid

Karthik_Mahalingam 27-Feb-17 0:51am

yes, we can.

Mahesh2223 27-Feb-17 0:57am

if i am doing this i am geeting server tag not well formed
<asp:Button id ="<%# Eval("Id") %>" runat="server" onclick="btnDelete_Click('<%# Eval("Id") %>')" Text="Delete" class="btn btn-primary btn-sm"/>

Karthik_Mahalingam 27-Feb-17 1:04am

check my solution.

Mahesh2223 27-Feb-17 1:09am

please wait i wil modify nd check

Karthik_Mahalingam 27-Feb-17 1:18am

ok.

Mahesh2223 27-Feb-17 1:23am

if i do as u said in id field its taking status column, status column means active. so all active columns wil be modified.in id we shoulg get only id number 1 ,2 etc

Karthik_Mahalingam 27-Feb-17 1:36am

assign the proper index
int idcolumnIndex = 5; // check this index

Mahesh2223 27-Feb-17 1:50am

column index needs to be null at starting or what? properly??

Karthik_Mahalingam 27-Feb-17 1:52am

if the id column is the 4th column then the index will be 3

Mahesh2223 27-Feb-17 2:03am

we are not doing this operation for a particular column index, it is the same for evry row, so column index should not be assigned with value in code

Karthik_Mahalingam 27-Feb-17 2:04am

whats wrong in that.

Mahesh2223 27-Feb-17 2:06am

u r telling me to do
int idcolumnIndex = 5; // check this index what if it's for other index

Karthik_Mahalingam 27-Feb-17 2:10am

to get the id column from the gridview

Button btn = (Button)sender;
GridViewRow gvr = (GridViewRow)btn.NamingContainer;
int idcolumnIndex = 5; // check this index
string id = gvr.Cells[idcolumnIndex].Text;

Mahesh2223 27-Feb-17 2:36am

well it's almost ok , but the thing is that column is deleted and updatd. before deleted my drop down has 5 values, after deleting this value also adds to drop down. but this values are not shown in grid deleted values

Karthik_Mahalingam 27-Feb-17 2:38am

That you have to check

Mahesh2223 27-Feb-17 2:40am

ok cool thanks

Mahesh2223 27-Feb-17 2:37am

user selects the values from drop downs. now deleted values should also come in grid

Karthik_Mahalingam 27-Feb-17 2:43am

You will have to write the logic

Mahesh2223 27-Feb-17 2:47am

the logic is already written.. in drop down what ever he selects that should be shown in grid.

Karthik_Mahalingam 27-Feb-17 2:50am

It's off topic

Post a new question with more details

1 solution

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)

Karthik_Mahalingam · Accepted Answer · 2017-02-26T19:04:00

<asp:BoundField HeaderText="ID" DataField="Id" ItemStyle-CssClass="hidecol" HeaderStyle-CssClass="hidecol" >
</asp:BoundField>

CSS

<style type="text/css">
  .hidecol
  {
    display: none;
  }
</style>

protected void btnDelete_Click(object sender, EventArgs e)
       {
           Button btn = (Button)sender;
           GridViewRow gvr = (GridViewRow)btn.NamingContainer;
           int idcolumnIndex = 5; // check this index
           string id = gvr.Cells[idcolumnIndex].Text;
       }