Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error when trying to edit a record

Status
Not open for further replies.
phytos

phytos

Technical User
Joined
Oct 20, 2002
Messages
15
Location
CY
when i click on the edit button i get the following error

Server Error in '/WebSite1' Application.
-----------------------------------------------------------

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

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

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


any idea how to fix this?
 
Sort by date Sort by votes
You'll have to post the code for the Edit button, but the error appears to lie in an array or collection that you are trying to reference, and the value of the array or collection that you are trying to access doesn't exist.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty ( or read FAQ222-2244 on how to get better results.
 
Upvote 0 Downvote
Here is the Code

Code: 
<%@ Page Language="VB" AutoEventWireup="false" CompileWith="WODetails.aspx.vb" ClassName="Default_aspx" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "[URL unfurl="true"]http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">[/URL]

<html xmlns="[URL unfurl="true"]http://www.w3.org/1999/xhtml"[/URL] >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table>
            <tr>
                <td style="font-weight: bold; vertical-align: middle; width: 1024px; color: lemonchiffon;
                    font-style: normal; font-family: Verdana; height: 43px; background-color: #336699;
                    text-align: left" colspan="3">
                    &nbsp;&nbsp; Work Order Details Page</td>
            </tr>
            <tr>
                <td style="font-weight: normal; font-size: 12pt; width: 1024px; font-family: Verdana;
                    height: 4px; background-color: #00ccff" colspan="3">
                </td>
            </tr>
            <tr>
                <td style="font-weight: normal; font-size: 12pt; width: 1024px; font-family: Verdana;
                    height: 2px; background-color: #00ccff" colspan="3">
                </td>
            </tr>
            <tr>
                <td style="font-weight: normal; font-size: 12pt; width: 1024px; font-family: Verdana;
                    height: 4px" colspan="3">
                </td>
            </tr>
            <tr>
                <td style="font-weight: normal; font-size: 12pt; width: 1024px; font-family: Verdana;
                    height: 4px" colspan="3">
                    <span style="font-size: 10pt"></span>
                </td>
            </tr>
            <tr>
                <td style="font-weight: normal; font-size: 12pt; width: 1024px; font-family: Verdana;
                    height: 88px" colspan="3">
                    &nbsp;<asp:AccessDataSource ID="AccessDataSource1" Runat="server" DataFile="~/Data/LaserchargeDB.mdb"
                        SelectCommand="SELECT * FROM [WorkOrders] WHERE ([WorkOrderID] = ?)" DeleteCommand="DELETE FROM [WorkOrders] WHERE [WorkOrderID] = ? AND [CompanyName] = ? AND [SupName] = ? AND [TechName] = ? AND [InHouseRefNumber] = ? AND [ProjectNumber] = ? AND [RefNumber] = ? AND [ProblemPlacedBy] = ? AND [DateReceived] = ? AND [BriefDescription] = ? AND [Make] = ? AND [Model] = ? AND [SerialNumber] = ? AND [ProblemDescription] = ? AND [DatedFinished] = ? AND [Status] = ? AND [Comments] = ? AND [Computer] = ? AND [Printer] = ? AND [PageCount] = ? AND [BillableHours] = ? AND [Traveling] = ?"
                        InsertCommand="INSERT INTO [WorkOrders] ([WorkOrderID], [CompanyName], [SupName], [TechName], [InHouseRefNumber], [ProjectNumber], [RefNumber], [ProblemPlacedBy], [DateReceived], [BriefDescription], [Make], [Model], [SerialNumber], [ProblemDescription], [DatedFinished], [Status], [Comments], [Computer], [Printer], [PageCount], [BillableHours], [Traveling]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
                        UpdateCommand="UPDATE [WorkOrders] SET [CompanyName] = ?, [SupName] = ?, [TechName] = ?, [InHouseRefNumber] = ?, [ProjectNumber] = ?, [RefNumber] = ?, [ProblemPlacedBy] = ?, [DateReceived] = ?, [BriefDescription] = ?, [Make] = ?, [Model] = ?, [SerialNumber] = ?, [ProblemDescription] = ?, [DatedFinished] = ?, [Status] = ?, [Comments] = ?, [Computer] = ?, [Printer] = ?, [PageCount] = ?, [BillableHours] = ?, [Traveling] = ? WHERE [WorkOrderID] = ? AND [CompanyName] = ? AND [SupName] = ? AND [TechName] = ? AND [InHouseRefNumber] = ? AND [ProjectNumber] = ? AND [RefNumber] = ? AND [ProblemPlacedBy] = ? AND [DateReceived] = ? AND [BriefDescription] = ? AND [Make] = ? AND [Model] = ? AND [SerialNumber] = ? AND [ProblemDescription] = ? AND [DatedFinished] = ? AND [Status] = ? AND [Comments] = ? AND [Computer] = ? AND [Printer] = ? AND [PageCount] = ? AND [BillableHours] = ? AND [Traveling] = ?"
                        ConflictDetection="CompareAllValues">
                        <DeleteParameters>
                            <asp:Parameter Type="Int32" Name="WorkOrderID"></asp:Parameter>
                            <asp:Parameter Type="String" Name="CompanyName"></asp:Parameter>
                            <asp:Parameter Type="String" Name="SupName"></asp:Parameter>
                            <asp:Parameter Type="String" Name="TechName"></asp:Parameter>
                            <asp:Parameter Type="String" Name="InHouseRefNumber"></asp:Parameter>
                            <asp:Parameter Type="String" Name="ProjectNumber"></asp:Parameter>
                            <asp:Parameter Type="String" Name="RefNumber"></asp:Parameter>
                            <asp:Parameter Type="String" Name="ProblemPlacedBy"></asp:Parameter>
                            <asp:Parameter Type="String" Name="DateReceived"></asp:Parameter>
                            <asp:Parameter Type="String" Name="BriefDescription"></asp:Parameter>
                            <asp:Parameter Type="String" Name="Make"></asp:Parameter>
                            <asp:Parameter Type="String" Name="Model"></asp:Parameter>
                            <asp:Parameter Type="String" Name="SerialNumber"></asp:Parameter>
                            <asp:Parameter Type="String" Name="ProblemDescription"></asp:Parameter>
                            <asp:Parameter Type="String" Name="DatedFinished"></asp:Parameter>
                            <asp:Parameter Type="String" Name="Status"></asp:Parameter>
                            <asp:Parameter Type="String" Name="Comments"></asp:Parameter>
                            <asp:Parameter Type="Boolean" Name="Computer"></asp:Parameter>
                            <asp:Parameter Type="Boolean" Name="Printer"></asp:Parameter>
                            <asp:Parameter Type="Int32" Name="PageCount"></asp:Parameter>
                            <asp:Parameter Type="Int32" Name="BillableHours"></asp:Parameter>
                            <asp:Parameter Type="Int32" Name="Traveling"></asp:Parameter>
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:Parameter Type="String" Name="CompanyName"></asp:Parameter>
                            <asp:Parameter Type="String" Name="SupName"></asp:Parameter>
                            <asp:Parameter Type="String" Name="TechName"></asp:Parameter>
                            <asp:Parameter Type="String" Name="InHouseRefNumber"></asp:Parameter>
                            <asp:Parameter Type="String" Name="ProjectNumber"></asp:Parameter>
                            <asp:Parameter Type="String" Name="RefNumber"></asp:Parameter>
                            <asp:Parameter Type="String" Name="ProblemPlacedBy"></asp:Parameter>
                            <asp:Parameter Type="String" Name="DateReceived"></asp:Parameter>
                            <asp:Parameter Type="String" Name="BriefDescription"></asp:Parameter>
                            <asp:Parameter Type="String" Name="Make"></asp:Parameter>
                            <asp:Parameter Type="String" Name="Model"></asp:Parameter>
                            <asp:Parameter Type="String" Name="SerialNumber"></asp:Parameter>
                            <asp:Parameter Type="String" Name="ProblemDescription"></asp:Parameter>
                            <asp:Parameter Type="String" Name="DatedFinished"></asp:Parameter>
                            <asp:Parameter Type="String" Name="Status"></asp:Parameter>
                            <asp:Parameter Type="String" Name="Comments"></asp:Parameter>
                            <asp:Parameter Type="Boolean" Name="Computer"></asp:Parameter>
                            <asp:Parameter Type="Boolean" Name="Printer"></asp:Parameter>
                            <asp:Parameter Type="Int32" Name="PageCount"></asp:Parameter>
                            <asp:Parameter Type="Int32" Name="BillableHours"></asp:Parameter>
                            <asp:Parameter Type="Int32" Name="Traveling"></asp:Parameter>
                            <asp:Parameter Type="Int32" Name="WorkOrderID"></asp:Parameter>
                        </UpdateParameters>
                        <SelectParameters>
                            <asp:FormParameter Name="WorkOrderID" Type="Int32" FormField="workorderid"></asp:FormParameter>
                        </SelectParameters>
                        <InsertParameters>
                            <asp:Parameter Type="Int32" Name="WorkOrderID"></asp:Parameter>
                            <asp:Parameter Type="String" Name="CompanyName"></asp:Parameter>
                            <asp:Parameter Type="String" Name="SupName"></asp:Parameter>
                            <asp:Parameter Type="String" Name="TechName"></asp:Parameter>
                            <asp:Parameter Type="String" Name="InHouseRefNumber"></asp:Parameter>
                            <asp:Parameter Type="String" Name="ProjectNumber"></asp:Parameter>
                            <asp:Parameter Type="String" Name="RefNumber"></asp:Parameter>
                            <asp:Parameter Type="String" Name="ProblemPlacedBy"></asp:Parameter>
                            <asp:Parameter Type="String" Name="DateReceived"></asp:Parameter>
                            <asp:Parameter Type="String" Name="BriefDescription"></asp:Parameter>
                            <asp:Parameter Type="String" Name="Make"></asp:Parameter>
                            <asp:Parameter Type="String" Name="Model"></asp:Parameter>
                            <asp:Parameter Type="String" Name="SerialNumber"></asp:Parameter>
                            <asp:Parameter Type="String" Name="ProblemDescription"></asp:Parameter>
                            <asp:Parameter Type="String" Name="DatedFinished"></asp:Parameter>
                            <asp:Parameter Type="String" Name="Status"></asp:Parameter>
                            <asp:Parameter Type="String" Name="Comments"></asp:Parameter>
                            <asp:Parameter Type="Boolean" Name="Computer"></asp:Parameter>
                            <asp:Parameter Type="Boolean" Name="Printer"></asp:Parameter>
                            <asp:Parameter Type="Int32" Name="PageCount"></asp:Parameter>
                            <asp:Parameter Type="Int32" Name="BillableHours"></asp:Parameter>
                            <asp:Parameter Type="Int32" Name="Traveling"></asp:Parameter>
                        </InsertParameters>
                    </asp:AccessDataSource>
                    <span style="font-size: 10pt"></span></td>
            </tr>
            <tr>
                <td style="width: 1024px; height: 203px" align="left" colspan="3" rowspan="2">
                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                    <asp:DetailsView ID="DetailsView1" Runat="server" DataSourceID="AccessDataSource1"
                        DataKeyNames="WorkOrderID" AutoGenerateRows="False" Width="327px" Height="509px">
                        <Fields>
                            <asp:BoundField ReadOnly="True" HeaderText="WorkOrderID" InsertVisible="False" DataField="WorkOrderID"
                                SortExpression="WorkOrderID"></asp:BoundField>
                            <asp:BoundField HeaderText="CompanyName" DataField="CompanyName" SortExpression="CompanyName"></asp:BoundField>
                            <asp:BoundField HeaderText="SupName" DataField="SupName" SortExpression="SupName"></asp:BoundField>
                            <asp:BoundField HeaderText="TechName" DataField="TechName" SortExpression="TechName"></asp:BoundField>
                            <asp:BoundField HeaderText="InHouseRefNumber" DataField="InHouseRefNumber" SortExpression="InHouseRefNumber"></asp:BoundField>
                            <asp:BoundField HeaderText="ProjectNumber" DataField="ProjectNumber" SortExpression="ProjectNumber"></asp:BoundField>
                            <asp:BoundField HeaderText="RefNumber" DataField="RefNumber" SortExpression="RefNumber"></asp:BoundField>
                            <asp:BoundField HeaderText="ProblemPlacedBy" DataField="ProblemPlacedBy" SortExpression="ProblemPlacedBy"></asp:BoundField>
                            <asp:BoundField HeaderText="DateReceived" DataField="DateReceived" SortExpression="DateReceived"></asp:BoundField>
                            <asp:BoundField HeaderText="BriefDescription" DataField="BriefDescription" SortExpression="BriefDescription"></asp:BoundField>
                            <asp:BoundField HeaderText="Make" DataField="Make" SortExpression="Make"></asp:BoundField>
                            <asp:BoundField HeaderText="Model" DataField="Model" SortExpression="Model"></asp:BoundField>
                            <asp:BoundField HeaderText="SerialNumber" DataField="SerialNumber" SortExpression="SerialNumber"></asp:BoundField>
                            <asp:BoundField HeaderText="ProblemDescription" DataField="ProblemDescription" SortExpression="ProblemDescription"></asp:BoundField>
                            <asp:BoundField HeaderText="DatedFinished" DataField="DatedFinished" SortExpression="DatedFinished"></asp:BoundField>
                            <asp:BoundField HeaderText="Status" DataField="Status" SortExpression="Status"></asp:BoundField>
                            <asp:BoundField HeaderText="Comments" DataField="Comments" SortExpression="Comments"></asp:BoundField>
                            <asp:CheckBoxField HeaderText="Computer" SortExpression="Computer" DataField="Computer"></asp:CheckBoxField>
                            <asp:CheckBoxField HeaderText="Printer" SortExpression="Printer" DataField="Printer"></asp:CheckBoxField>
                            <asp:BoundField HeaderText="PageCount" DataField="PageCount" SortExpression="PageCount"></asp:BoundField>
                            <asp:BoundField HeaderText="BillableHours" DataField="BillableHours" SortExpression="BillableHours"></asp:BoundField>
                            <asp:BoundField HeaderText="Traveling" DataField="Traveling" SortExpression="Traveling"></asp:BoundField>
                            <asp:CommandField ShowEditButton="True"></asp:CommandField>
                        </Fields>
                    </asp:DetailsView>
                </td>
            </tr>
            <tr>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>
 
Upvote 0 Downvote
OK you'll have to help me out a bit here so I don't have to interpret all that code!

Which is your edit button that is causing the error and what code is associated with that button?

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty ( or read FAQ222-2244 on how to get better results.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

chikwendu
  • Locked
  • Question Question
Mouse jumps to DropDownList when clicking a button
Replies
0
Views
362
chikwendu
chikwendu
Makumbi256
  • Locked
  • Question Question
How to make days vertical and grid view editable using asp.net vb
Replies
0
Views
1K
Makumbi256
Makumbi256
JohnB33
  • Locked
  • Question Question
int type causes error
Replies
0
Views
1K
JohnB33
JohnB33
AhmedAzizBarbary
  • Locked
  • Question Question
How to read data response body after success login razor page ?
Replies
0
Views
1K
AhmedAzizBarbary
AhmedAzizBarbary
AhmedAzizBarbary
  • Locked
  • Question Question
How to pass list of checkboxes not checked on page model razor page?
Replies
0
Views
1K
AhmedAzizBarbary
AhmedAzizBarbary

Part and Inventory Search

Sponsor

Back
Top