This is a migrated thread and some comments may be shown as answers.
[Solved] [urgent] Please help! I cannot update my fields in grid

2 Answers 89 Views
Grid
This is a migrated thread and some comments may be shown as answers.
louis chan asked on 10 Mar 2010, 07:15 AM
I have created a grid which has generated a edit button, when I edit one of my row, it turns to edit mode, then after I change sth and click update, it would not be updated! Would somebody help me out here?
The first remarked datasource is built by myself and with logical delete, but it seems not working!
The second one is generated by datasource configuration builder. And it is still not working
    
            <%--<asp:AccessDataSource ID="adsMenus" runat="server"   
        
                DataFile="~/App_Data/dbmx.mdb"   
        
                SelectCommand="SELECT * FROM [Menus] where isDelete = False"   
        
                UpdateCommand="UPDATE Menus SET menuName = ?, menuType = ?, menuSequence = ?, menuLink = ?, menuParentID = ? WHERE (menuID = ?)"   
        
                DeleteCommand="UPDATE Menus SET isDelete = true WHERE (menuID = ?)">  
        
                <UpdateParameters> 
        
                    <asp:SessionParameter Name="menuName" SessionField="menuName" /> 
        
                    <asp:SessionParameter Name="menuType" SessionField="menuType"/>  
        
                    <asp:SessionParameter Name="menuSequence" SessionField="menuSequence"/>  
        
                    <asp:SessionParameter Name="menuLink" SessionField="menuLink"/>  
        
                    <asp:SessionParameter Name="menuParentID" SessionField="menuParentID"/>  
        
                    <asp:SessionParameter Name="menuID" SessionField="menuID"/>  
        
                </UpdateParameters> 
        
                <DeleteParameters> 
        
                    <asp:SessionParameter Name="menuID" SessionField="menuID" /> 
        
                </DeleteParameters> 
        
            </asp:AccessDataSource>--%> 
        
            <asp:AccessDataSource ID="adsMenus" runat="server"   
        
                DataFile="~/App_Data/dbmx.mdb"   
        
                SelectCommand="SELECT * FROM [Menus]"   
        
                UpdateCommand="UPDATE [Menus] SET [menuName] = ?, [menuType] = ?, [menuSequence] = ?, [menuLink] = ?, [menuParentID] = ?, [isDelete] = ? WHERE [menuID] = ? AND [menuName] = ? AND (([menuType] = ?) OR ([menuType] IS NULL AND ? IS NULL)) AND (([menuSequence] = ?) OR ([menuSequence] IS NULL AND ? IS NULL)) AND (([menuLink] = ?) OR ([menuLink] IS NULL AND ? IS NULL)) AND (([menuParentID] = ?) OR ([menuParentID] IS NULL AND ? IS NULL)) AND [isDelete] = ?"   
        
                ConflictDetection="CompareAllValues"   
        
                DeleteCommand="DELETE FROM [Menus] WHERE [menuID] = ? AND [menuName] = ? AND (([menuType] = ?) OR ([menuType] IS NULL AND ? IS NULL)) AND (([menuSequence] = ?) OR ([menuSequence] IS NULL AND ? IS NULL)) AND (([menuLink] = ?) OR ([menuLink] IS NULL AND ? IS NULL)) AND (([menuParentID] = ?) OR ([menuParentID] IS NULL AND ? IS NULL)) AND [isDelete] = ?"   
        
                InsertCommand="INSERT INTO [Menus] ([menuID], [menuName], [menuType], [menuSequence], [menuLink], [menuParentID], [isDelete]) VALUES (?, ?, ?, ?, ?, ?, ?)"   
        
                OldValuesParameterFormatString="original_{0}">  
        
                <DeleteParameters> 
        
                    <asp:Parameter Name="original_menuID" Type="Int32" /> 
        
                    <asp:Parameter Name="original_menuName" Type="String" /> 
        
                    <asp:Parameter Name="original_menuType" Type="String" /> 
        
                    <asp:Parameter Name="original_menuSequence" Type="Int32" /> 
        
                    <asp:Parameter Name="original_menuLink" Type="String" /> 
        
                    <asp:Parameter Name="original_menuParentID" Type="Int32" /> 
        
                    <asp:Parameter Name="original_isDelete" Type="Boolean" /> 
        
                </DeleteParameters> 
        
                <UpdateParameters> 
        
                    <asp:Parameter Name="menuName" Type="String" /> 
        
                    <asp:Parameter Name="menuType" Type="String" /> 
        
                    <asp:Parameter Name="menuSequence" Type="Int32" /> 
        
                    <asp:Parameter Name="menuLink" Type="String" /> 
        
                    <asp:Parameter Name="menuParentID" Type="Int32" /> 
        
                    <asp:Parameter Name="isDelete" Type="Boolean" /> 
        
                    <asp:Parameter Name="original_menuID" Type="Int32" /> 
        
                    <asp:Parameter Name="original_menuName" Type="String" /> 
        
                    <asp:Parameter Name="original_menuType" Type="String" /> 
        
                    <asp:Parameter Name="original_menuSequence" Type="Int32" /> 
        
                    <asp:Parameter Name="original_menuLink" Type="String" /> 
        
                    <asp:Parameter Name="original_menuParentID" Type="Int32" /> 
        
                    <asp:Parameter Name="original_isDelete" Type="Boolean" /> 
        
                </UpdateParameters> 
        
                <InsertParameters> 
        
                    <asp:Parameter Name="menuID" Type="Int32" /> 
        
                    <asp:Parameter Name="menuName" Type="String" /> 
        
                    <asp:Parameter Name="menuType" Type="String" /> 
        
                    <asp:Parameter Name="menuSequence" Type="Int32" /> 
        
                    <asp:Parameter Name="menuLink" Type="String" /> 
        
                    <asp:Parameter Name="menuParentID" Type="Int32" /> 
        
                    <asp:Parameter Name="isDelete" Type="Boolean" /> 
        
                </InsertParameters> 
        
            </asp:AccessDataSource> 
        
            <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateDeleteColumn="True"   
        
                AutoGenerateEditColumn="True" DataSourceID="adsMenus" GridLines="None"   
        
                Skin="Office2007">  
        
            <MasterTableView AutoGenerateColumns="False" DataKeyNames="menuID"   
        
                    DataSourceID="adsMenus">  
        
            <RowIndicatorColumn> 
        
            <HeaderStyle Width="20px"></HeaderStyle> 
        
            </RowIndicatorColumn> 
        
            <ExpandCollapseColumn> 
        
            <HeaderStyle Width="20px"></HeaderStyle> 
        
            </ExpandCollapseColumn> 
        
                <Columns> 
        
                    <telerik:GridBoundColumn DataField="menuID" DataType="System.Int32"   
        
                        HeaderText="menuID" ReadOnly="True" SortExpression="menuID" UniqueName="menuID">  
        
                    </telerik:GridBoundColumn> 
        
                    <telerik:GridBoundColumn DataField="menuName" HeaderText="menuName"   
        
                        SortExpression="menuName" UniqueName="menuName">  
        
                    </telerik:GridBoundColumn> 
        
                    <telerik:GridBoundColumn DataField="menuType" HeaderText="menuType"   
        
                        SortExpression="menuType" UniqueName="menuType">  
        
                    </telerik:GridBoundColumn> 
        
                    <telerik:GridBoundColumn DataField="menuSequence" DataType="System.Int32"   
        
                        HeaderText="menuSequence" SortExpression="menuSequence"   
        
                        UniqueName="menuSequence">  
        
                    </telerik:GridBoundColumn> 
        
                    <telerik:GridBoundColumn DataField="menuLink" HeaderText="menuLink"   
        
                        SortExpression="menuLink" UniqueName="menuLink">  
        
                    </telerik:GridBoundColumn> 
        
                    <telerik:GridBoundColumn DataField="menuParentID" DataType="System.Int32"   
        
                        HeaderText="menuParentID" SortExpression="menuParentID"   
        
                        UniqueName="menuParentID">  
        
                    </telerik:GridBoundColumn> 
        
                    <telerik:GridCheckBoxColumn DataField="isDelete" DataType="System.Boolean"   
        
                        HeaderText="isDelete" SortExpression="isDelete" UniqueName="isDelete">  
        
                    </telerik:GridCheckBoxColumn> 
        
                </Columns> 
        
            </MasterTableView> 
        
            </telerik:RadGrid>
2 Answers, 1 is accepted

Accepted