Index out of range error

tanu

Hello All.
I am having a problem
In my source code i connected with MS access database
and i am using datagrid and trying to edit and delete the record.
but it's giving Index out of range error.
i am using MS access first time
is there any other method to use datagrid with MS access database .
I am very confused
Please solve my problem ....

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Choudhary16y ago
Accepted answer
hi friend,

Please post the error with stack trace.... i can help you
0
Amit Choudhary16y ago
hi tanu,

Always mark the post as answer if it helps you. It benefit others to get the quick solution for resembling problems.

Best regards
0
tanu16y ago
Hello Amit..
thanks a lot..
i totally forget abt that ..
thx a lot....
0
tanu16y ago
Hello Amit..
thanks a lot..
i totally forget abt that ..
thx a lot....
0
Amit Choudhary16y ago
hi friend,

my guess was right after seeing your code i have doubt on the line where you are accessing the datakey....
after looking at your code inside the project found the error that you did'nt specify the DatakeyField value in your Grid.

             BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" CellPadding="4"
            oncancelcommand="DataGrid1_CancelCommand" DataKeyField="ID" oneditcommand="DataGrid1_EditCommand"
            onupdatecommand="DataGrid1_UpdateCommand"
            ondeletecommand="DataGrid1_DeleteCommand"
            onpageindexchanged="DataGrid1_PageIndexChanged"
        AutoGenerateColumns=false Height="290px" Width="437px">

Add this attribute value as above. and your error get resolved.

Please don't forget to mark the answer.
0
tanu16y ago
Hello.
I am sending my whole code with database..
Please check it and tell me where i m wrong.?
thanks.
0

tanu16y ago

Hello Amit..
First of all thx for reply..
this is the stack trace ..
u can check like this or i should upload the full code??
thx again

[ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index]
   System.Collections.ArrayList.get_Item(Int32 index) +2880797
   System.Web.UI.WebControls.DataKeyCollection.get_Item(Int32 index) +9
   asccess_connection._Default.DataGrid1_DeleteCommand(Object source, DataGridCommandEventArgs e) in E:\tanu_asp\asccess_connection\asccess_connection\Default.aspx.cs:103
   System.Web.UI.WebControls.DataGrid.OnDeleteCommand(DataGridCommandEventArgs e) +105
   System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) +537
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
   System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) +117
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
   System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +115
   System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +132
   System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +177
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

kiran kumar16y ago
post your project file with database ,not the text file with piece of code in it
0