Ddelete in Gridview without using AutoGenerateDeleteButton

Question

how to delete in Gridview row without using AutoGenerateDeleteButton?

Srikanth Reddy · Answer

We can delete by using rowcommand. Please follow the below attached file where it explains about rowcommand with dletion operation in gridview. namespace WebApplication1 { public partial class WebForm2 : System.Web.UI. Page { SqlConnection con = new SqlConnection ( server=.;database=abc;trusted_connection=true ); protected void Page_Load( object sender EventArgs e) { if (!IsPostBack) { bind(); } } public void bind() { SqlCommand cmd = new SqlCommand ( select * from employee  con); SqlDataAdapter da = new SqlDataAdapter (cmd); DataSet ds = new DataSet (); da.Fill(ds con ); GridView1.DataSource = ds; GridView1.DataBind(); } protected void GridView1_RowCommand( object sender GridViewCommandEventArgs e) { if (e.CommandName == comdel ) { int l = Convert .ToInt32(e.CommandArgument); con.Open(); SqlCommand cmd = new SqlCommand ( delete from employee where eno=@a  con); cmd.Parameters.AddWithValue( @a  l); int i = cmd.ExecuteNonQuery(); if (i == 1) { Response.Write( Record deleted ); bind(); } else { Response.Write( Recodrd not deleted... ); } Page_Load(sender e); } } } }