datagriedview

Jitendra Sharma

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 ....

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
is this worked for you?
0
Nilesh Jadav11y ago
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
0
Upendra Pratap Shahi11y ago
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", "");
con.Close();
BindData();
}
}
0
Jitendra Sharma11y ago
Dear sir,if u have any kind of code plz send ...........
0
Jitendra Sharma11y ago
all ready done ....
0
Upendra Pratap Shahi11y ago
rebind your datagrid after deletion .
0