Click here to Skip to main content
15,921,837 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
This my code
ASP.NET
<asp:UpdatePanel ID="UpdatePanel8" runat="server">
                        <ContentTemplate>
                            <dx:ASPxGridView ID="grid"  runat="server" Width="100%" AutoGenerateColumns="False" ClientInstanceName="grid" EnableRowsCache="False" KeyFieldName="ProductCode"
                                 önRowUpdating="grid_RowUpdating" >
                                <TotalSummary>
                                    <dx:ASPxSummaryItem FieldName="Qty" ShowInColumn="Qty" ShowInGroupFooterColumn="Qty"
                                        SummaryType="Sum" DisplayFormat="#.###" />
                                    <dx:ASPxSummaryItem FieldName="QtyReceive" ShowInColumn="QtyReceive" ShowInGroupFooterColumn="QtyReceive"
                                        SummaryType="Sum" DisplayFormat="#.###" />
                                </TotalSummary>
                                <Columns>
                                    <dx:GridViewDataTextColumn VisibleIndex="0" Caption="No" Width="40px" ReadOnly="True"
                                        HeaderStyle-HorizontalAlign="Center">
                                        <DataItemTemplate>
                                            <dx:ASPxLabel ID="lblRowID_T1"  runat="server" Text='<%# Container.ItemIndex + 1 %>'>
                                            </dx:ASPxLabel>
                                        </DataItemTemplate>
                                        <HeaderStyle Font-Names="Arial" Font-Size="10pt" Font-Bold="true" HorizontalAlign="Center"
                                            VerticalAlign="Middle" Wrap="True" />
                                        <CellStyle Wrap="False">
                                        </CellStyle>
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn Caption="Artikel" FieldName="ProductCode" ReadOnly="True"
                                        VisibleIndex="1" Width="30%">
                                        <HeaderStyle Font-Names="Arial" Font-Size="10pt" Font-Bold="true" HorizontalAlign="Center"
                                            VerticalAlign="Middle" Wrap="True" />
                                        <CellStyle Font-Names="Arial" Font-Size="10pt" Wrap="False">
                                        </CellStyle>
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn Caption="Nama Produk" FieldName="ProductName" ReadOnly="True"
                                        VisibleIndex="2" Width="30%">
                                        <HeaderStyle Font-Names="Arial" Font-Size="10pt" Font-Bold="true" HorizontalAlign="Center"
                                            VerticalAlign="Middle" Wrap="True" />
                                        <CellStyle Font-Names="Arial" Font-Size="10pt" Wrap="False">
                                        </CellStyle>
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn Caption="Tema" FieldName="TemaCode" ReadOnly="True" VisibleIndex="3"
                                        Width="30%">
                                        <HeaderStyle Font-Names="Arial" Font-Size="10pt" Font-Bold="true" HorizontalAlign="Center"
                                            VerticalAlign="Middle" Wrap="True" />
                                        <CellStyle Font-Names="Arial" Font-Size="10pt" Wrap="False">
                                        </CellStyle>
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataTextColumn Caption="Qty" FieldName="Qty" ReadOnly="True" VisibleIndex="4"
                                        Width="100px">
                                        <HeaderStyle Font-Names="Arial" Font-Size="10pt" Font-Bold="true" HorizontalAlign="Center"
                                            VerticalAlign="Middle" Wrap="True" />
                                        <CellStyle Font-Names="Arial" Font-Size="10pt" Wrap="False" HorizontalAlign="Center">
                                        </CellStyle>
                                        <FooterCellStyle HorizontalAlign="Center">
                                        </FooterCellStyle>
                                    </dx:GridViewDataTextColumn>
                                    <dx:GridViewDataSpinEditColumn Caption="Qty Terima" FieldName="QtyReceive" ShowInCustomizationForm="True"
                                        VisibleIndex="5" Width="100px" CellStyle-HorizontalAlign="Center">
                                        <PropertiesSpinEdit DisplayFormatString="g" Spacing="0">
                                        </PropertiesSpinEdit>
                                        <EditItemTemplate>
                                            <dx:ASPxSpinEdit ID="seQty"  runat="server" Font-Names="Arial" Font-Size="10pt" Width="90px"
                                                Number="0" Text='<%# Bind("QtyReceive") %>' MaxValue="1000000" SpinButtons-ShowIncrementButtons="False"
                                                SpinButtons-ShowLargeIncrementButtons="True" LargeIncrement="1">
                                            </dx:ASPxSpinEdit>
                                        </EditItemTemplate>
                                        <HeaderStyle Font-Names="Arial" Font-Size="10pt" Font-Bold="true" HorizontalAlign="Center"
                                            VerticalAlign="Middle" Wrap="True" />
                                        <CellStyle Font-Names="Arial" Font-Size="10pt" Wrap="False">
                                        </CellStyle>
                                        <FooterCellStyle HorizontalAlign="Center">
                                        </FooterCellStyle>
                                    </dx:GridViewDataSpinEditColumn>
                                    <dx:GridViewCommandColumn ShowSelectCheckbox="true" VisibleIndex="8">
                                    </dx:GridViewCommandColumn>
                                    <dx:GridViewCommandColumn VisibleIndex="7">
                                        <EditButton Visible="True">
                                        </EditButton>
                                    </dx:GridViewCommandColumn>
                                </Columns>
                                <SettingsBehavior ColumnResizeMode="Control" ProcessSelectionChangedOnServer="true"/>
                                <SettingsPager NumericButtonCount="100" PageSize="100" />
                                <SettingsEditing Mode="Inline" />
                                <Settings ShowGroupedColumns="True" ShowHorizontalScrollBar="True" ShowFilterRow="true"
                                    ShowFilterRowMenu="true" ShowFooter="True" />
                                <Images SpriteCssFilePath="~/App_Themes/Office2010Silver/{0}/sprite.css">
                                    <LoadingPanelOnStatusBar Url="~/App_Themes/Office2010Silver/GridView/Loading.gif">
                                    </LoadingPanelOnStatusBar>
                                    <LoadingPanel Url="~/App_Themes/Office2010Silver/GridView/Loading.gif">
                                    </LoadingPanel>
                                </Images>
                                <ImagesFilterControl>
                                    <LoadingPanel Url="~/App_Themes/Office2010Silver/GridView/Loading.gif">
                                    </LoadingPanel>
                                </ImagesFilterControl>
                                
                            </dx:ASPxGridView>
                            <br />
                            <asp:UpdateProgress runat="server" ID="UpdateProgress" AssociatedUpdatePanelID="UpdatePanel8"
                                DisplayAfter="0" DynamicLayout="false">
                                <ProgressTemplate>
                                    <img alt="In progress..." src="Image/7.gif">
                                </ProgressTemplate>
                            </asp:UpdateProgress>
                        </ContentTemplate>
                    </asp:UpdatePanel>



I want using this design gridview, if i want to change QTY receive I can click edit commend but I don't want to edit I just check. but I getting error "A primary key field specified via the KeyFieldName property is not found in the underlying data source. Make sure the field name is spelled correctly. Pay attention to the character case."
please help me,
Posted

1 solution

Quote:
The KeyFieldName property should be specified when using the following ASPxGridView features:

data editing;
adding new and deleting existing rows;
selecting rows;
master-detail view;
endless paging.

HTML
<dx:aspxgridview ...="" keyfieldname="FirstName;LastName;Phone;BirthDate">
     ...
</dx:aspxgridview>

Ref :ASPxGridView.KeyFieldName Property[^]
 
Share this answer
 
v2
Comments
IshaqSalam 4-Jun-14 2:08am    
I was try this, but it's still not work.
i can check some data in table, but when I was click edit comment, the error still come out.
the error says "A primary key field specified via the KeyFieldName property is not found in the underlying data source. Make sure the field name is spelled correctly. Pay attention to the character case."

please help me this problem,

I want to explain more detail about this problem, I Want to send Image, but how

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900