Getting ColumnID Value from GridView? [modified]
-
Here is the code from ASP.NET 1.1 that works. My problem is below with 2.0 GridView? private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { int playerID = Convert.ToInt32(e.Item.Cells[1].Text); string sqlDelete = "delete Players where PlayerID = '" + playerID +"'"; SqlConnection conn = new SqlConnection(dsn); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = sqlDelete; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); DataGrid1.EditItemIndex = -1; BindGrid(); } This above code is ASP.NET 1.1 code for Deletion from DataGrid. It works fine. Now, I am using GridView (ASP.NET 2.0) The problem I am having is getting the playerID from GridView? ***int playerID = Convert.ToInt32(e.Item.Cells[1].Text); ** does not give any playerID but throws error? How do I get the playerID from GridView. Is the event handler Row Deleting or Row Deleted? Please help............. :confused: -- modified at 16:34 Wednesday 27th September, 2006
Sanju
-
Here is the code from ASP.NET 1.1 that works. My problem is below with 2.0 GridView? private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { int playerID = Convert.ToInt32(e.Item.Cells[1].Text); string sqlDelete = "delete Players where PlayerID = '" + playerID +"'"; SqlConnection conn = new SqlConnection(dsn); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = sqlDelete; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); DataGrid1.EditItemIndex = -1; BindGrid(); } This above code is ASP.NET 1.1 code for Deletion from DataGrid. It works fine. Now, I am using GridView (ASP.NET 2.0) The problem I am having is getting the playerID from GridView? ***int playerID = Convert.ToInt32(e.Item.Cells[1].Text); ** does not give any playerID but throws error? How do I get the playerID from GridView. Is the event handler Row Deleting or Row Deleted? Please help............. :confused: -- modified at 16:34 Wednesday 27th September, 2006
Sanju
-
Thanks for you immediate reply........ Here is the error !!! 'System.Web.UI.WebControls.GridViewDeleteEventArgs' does not contain a definition for 'Item' How do I retrieve PlayerID from the GridView? Thanks
Sanjeev