how to delete the rows in datagrid

Question

hi... any one please give me codings to delete the particular row in a datagrid using button column... thank you Arun chakravarthi

Reena Sajith · Answer

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.

Palanivelrajan V · Answer

get the row id or unquie id from datagrid and find the datatable to delete the datatable row and rebind the datagrid. this is one way like this so many ways is there

Arun · Answer

Thank you very much.