如何删除网格视图中的行删除（asp.net）后端我的sql [英] how to delete row delete in grid view (asp.net) backend my sql

问题描述

如何删除网格视图中的行删除（asp.net）后端我的sql

how to delete row delete in grid view (asp.net) backend my sql

推荐答案

protected void lnkdelete_Click(object sender, EventArgs e)
{

LinkButton lnkbtn= sender as LinkButton;
//getting particular row linkbutton
GridViewRow gvrow = lnkbtn.NamingContainer as GridViewRow;
//getting userid of particular row
int userid = Convert.ToInt32(gvrecords.DataKeys[gvrow.RowIndex].Value.ToString());
string username = gvrow.Cells[0].Text;
con.Open();
SqlCommand cmd = new SqlCommand("delete from UserDetails where UserId="+userid,con);
int result=cmd.ExecuteNonQuery();
con.Close();
if (result == 1)
{
BindUserDetails();
//Displaying alert message after successfully deletion of user
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert(''" + username + " details deleted successfully'')", true);
}

courty：

http://www.aspdotnet-suresh.com/2011/01/how-to-delete-records- in-gridview-with.html [ ^ ]

这篇关于如何删除网格视图中的行删除（asp.net）后端我的sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！