This is a migrated thread and some comments may be shown as answers.

No 'Add new' button

2 Answers 149 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Clive Hoggar asked on 22 Jun 2009, 02:26 PM

Hi

I have inserted a simple grid in a page, set up for automatic generation of edit and delete columns, allowing automatic
update insert and delete. The edit and delete parts works fine but the 'add new' button does not show up.

I can't see why not. Can anyone help here?

Version is Q1 2009

Thanks

Clive

    
            <telerik:RadScriptManager ID="RadScriptManager1" runat="server">  
        
                    </telerik:RadScriptManager> 
        
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server"   
        
                        ConnectionString="<%$ ConnectionStrings:cotn_publicConnectionString %>"   
        
                        DeleteCommand="DELETE FROM [WeeklySubs] WHERE [ID] = @ID"   
        
                        InsertCommand="INSERT INTO [WeeklySubs] ([FirstName], [LastName], [Email], [Status], [CreateDate], [IP]) VALUES (@FirstName, @LastName, @Email, @Status, @CreateDate, @IP, @HTML, @Spare)"   
        
                        SelectCommand="SELECT * FROM [WeeklySubs] ORDER BY [LastName]"   
        
                        UpdateCommand="UPDATE [WeeklySubs] SET [FirstName] = @FirstName, [LastName] = @LastName, [Email] = @Email, [Status] = @Status, [CreateDate] = @CreateDate, [IP] = @IP WHERE [ID] = @ID">  
        
                        <DeleteParameters> 
        
                            <asp:Parameter Name="ID" Type="Int32" /> 
        
                        </DeleteParameters> 
        
                        <UpdateParameters> 
        
                            <asp:Parameter Name="FirstName" Type="String" /> 
        
                            <asp:Parameter Name="LastName" Type="String" /> 
        
                            <asp:Parameter Name="Email" Type="String" /> 
        
                            <asp:Parameter Name="Status" Type="String" /> 
        
                            <asp:Parameter Name="CreateDate" Type="DateTime" /> 
        
                            <asp:Parameter Name="IP" Type="String" /> 
        
                            <asp:Parameter Name="HTML" Type="String" /> 
        
                            <asp:Parameter Name="Spare" Type="String" /> 
        
                            <asp:Parameter Name="ID" Type="Int32" /> 
        
                        </UpdateParameters> 
        
                        <InsertParameters> 
        
                            <asp:Parameter Name="FirstName" Type="String" /> 
        
                            <asp:Parameter Name="LastName" Type="String" /> 
        
                            <asp:Parameter Name="Email" Type="String" /> 
        
                            <asp:Parameter Name="Status" Type="String" /> 
        
                            <asp:Parameter Name="CreateDate" Type="DateTime" /> 
        
                            <asp:Parameter Name="IP" Type="String" /> 
        
                            <asp:Parameter Name="HTML" Type="String" /> 
        
                            <asp:Parameter Name="Spare" Type="String" /> 
        
                        </InsertParameters> 
        
                    </asp:SqlDataSource> 
        
                    <table align="center" bgcolor="White" width="600px">  
        
                        <tr> 
        
                            <td> 
        
                                <telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True"   
        
                                    AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowPaging="True"   
        
                                    AllowSorting="True" AutoGenerateDeleteColumn="True"   
        
                                    AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1" GridLines="None"   
        
                                    Skin="Forest" Width="800px" CommandItemDisplay="Top">  
        
            <MasterTableView AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource1">  
        
            <RowIndicatorColumn> 
        
            <HeaderStyle Width="20px"></HeaderStyle> 
        
            </RowIndicatorColumn> 
        
            <ExpandCollapseColumn> 
        
            <HeaderStyle Width="20px"></HeaderStyle> 
        
            </ExpandCollapseColumn> 
        
                <Columns> 
        
                    <telerik:GridBoundColumn DataField="FirstName" HeaderText="FirstName"   
        
                        SortExpression="FirstName" UniqueName="FirstName">  
        
                    </telerik:GridBoundColumn> 
        
                    <telerik:GridBoundColumn DataField="LastName" HeaderText="LastName"   
        
                        SortExpression="LastName" UniqueName="LastName">  
        
                    </telerik:GridBoundColumn> 
        
                    <telerik:GridBoundColumn DataField="Email" HeaderText="Email"   
        
                        SortExpression="Email" UniqueName="Email">  
        
                    </telerik:GridBoundColumn> 
        
                    <telerik:GridBoundColumn DataField="Status" HeaderText="Status"   
        
                        SortExpression="Status" UniqueName="Status">  
        
                    </telerik:GridBoundColumn> 
        
                    <telerik:GridBoundColumn DataField="CreateDate" DataType="System.DateTime"   
        
                        HeaderText="CreateDate" SortExpression="CreateDate"   
        
                        UniqueName="CreateDate">  
        
                    </telerik:GridBoundColumn> 
        
                    <telerik:GridBoundColumn DataField="IP" HeaderText="IP"   
        
                        SortExpression="IP" UniqueName="IP">  
        
                    </telerik:GridBoundColumn> 
        
                </Columns> 
        
            </MasterTableView> 
        
                                </telerik:RadGrid>

2 Answers, 1 is accepted

answered on 22 Jun 2009, 02:56 PM

Hello Clive,

In order to show "Add new record" button you should remove CommandItemDisplay property in the MasterTableView as shown bellow:
ASPX:

    
            <telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True"      
        
                                    AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowPaging="True"      
        
                                    AllowSorting="True" AutoGenerateDeleteColumn="True"      
        
                                    AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1" GridLines="None"      
        
                                    Skin="Forest" Width="800px">     
        
            <MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Top" DataKeyNames="ID" DataSourceID="SqlDataSource1">     
        
            <RowIndicatorColumn>    
        
            ...........  
        
            ...........

I hope this helps.

Kind regards,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.