datagriedview

Question

when first time click on delete button in datagriedview then delete row successfully again click on delete then no row delete or no action perform but why .... same condition with edit button ... how to solve this problem plz reply me ....

Upendra Pratap Shahi · Answer

is this worked for you?

Nilesh Jadav · Answer

Check this Jitendra : protected void gvDetails_RowDeleting( object sender, GridViewDeleteEventArgs e) { int userid = Convert .ToInt32(gvDetails.DataKeys[e.RowIndex].Values[ "UserId" ].ToString()); string username = gvDetails.DataKeys[e.RowIndex].Values[ "UserName" ].ToString(); con.Open(); SqlCommand cmd = new SqlCommand ( "delete from Employee_Details where UserId=" + userid, con); int result = cmd.ExecuteNonQuery(); con.Close(); if (result == 1) { BindEmployeeDetails(); lblresult.ForeColor = Color .Red; lblresult.Text = username + " details deleted successfully" ; } } Full tutorial: http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html

Upendra Pratap Shahi · Answer

use this code for delete-- protected void DataGrid1_DeleteCommand( object source, DataGridCommandEventArgs e) { con = new SqlConnection (dbcon); cmd = new SqlCommand ( "Delete from Emp where Empid=" + DataGrid1.DataKeys[e.Item.ItemIndex].ToString(), con); con.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { Page.ClientScript.RegisterClientScriptBlock( this .GetType(), "Deleted" , " alert('Deleted Successfully') " ); con.Close(); BindData(); } }

Jitendra Sharma · Answer

Dear sir,if u have any kind of code plz send ...........

Jitendra Sharma · Answer

all ready done ....

Upendra Pratap Shahi · Answer

rebind your datagrid after deletion .