Unable to delete records in grid view

Question

Hi I encountered a problem with deleting records from database. This is the error: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index May I know what causes it? This is the business logic: protected void gvUploadedDocuments_RowDeleting( object sender GridViewDeleteEventArgs e) { vrmdb.Delete_UploadedNewDocuments(gvUploadedDocuments.DataKeys[e.RowIndex].Values[0].ToString()); BindGrid1(); } Thanks!

Bryian Tan · Answer

hello The suggestion from Suthish should work. Here is more info about it http://forums.asp.net/t/1561630.aspx

Becky Bloomwood · Answer

this is the database.cs code: //Method to DELETE Documents public bool Delete_UploadedNewDocuments( string uploadedDocID) { SqlCommand cmd_UploadedDocumentsList = new SqlCommand (); cmd_UploadedDocumentsList.CommandText = [VRM].[DELETE_UploadedNewDocuments] ; cmd_UploadedDocumentsList.CommandType = CommandType .StoredProcedure; cmd_UploadedDocumentsList.Parameters.Clear(); SqlParameter sqlParaUDocID = new SqlParameter ( @uploadedDocID  SqlDbType .VarChar 10); //doc id sqlParaUDocID.Value = uploadedDocID; cmd_UploadedDocumentsList.Parameters.Add(sqlParaUDocID); return executeNotQuery(cmd_UploadedDocumentsList); } And this is the stored procedure: ALTER PROCEDURE [VRM].[DELETE_UploadedNewDocuments] @uploadedDocID varchar(10) AS BEGIN DELETE FROM VRM.UploadedDocuments WHERE uploadedDocID = @uploadedDocID END Thanks!

Shankey · Answer

hi Please put breakpoint on line 1 and put line 2 in quick watch in VS2k5 or later and check whether it is not giving error Line: 1 vrmdb.Delete_UploadedNewDocuments(gvUploadedDocuments.DataKeys[e.RowIndex].Values[0].ToString()); Line: 2 vUploadedDocuments.DataKeys[e.RowIndex].Values[0].ToString()

Suthish Nair · Answer

change the line to gvUploadedDocuments.DataKeys[e.RowIndex]. Value .ToString()

Krishna Garad · Answer

can you show your method written to delete the row I mean that vrmdb.Delete_UploadedNewDocuments I think this error occuring in that method only.

Unable to delete records in grid view

Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index