how to delete the rows in datagrid

Hello, you can delete a row from grid using the OnDelete_Command that u specify within button column.Check out this Example: Code Behind ------------ public void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string authid1; authid1=e.Item.Cells[0].Text;//cell[0] means first field //get the primary key(fldAu_id) in a variable authid1. string sqlDelete="DELETE FROM tblAuthor where fldAu_id='" + authid1 +"'"; SqlCommand cmd = cn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = sqlDelete; cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); DataGrid1.EditItemIndex = -1; BindDataGrid(); } within the column template add the button column as: and in the datagrid tag specify the delete command as below: this sure will work.let me know the result.