I cannt figure out how to enable Edit,Add,Delete buttons

[Stoyan]

I want the grid to have Edit,Add,Delete button or selection but it wont let me ...

Here is the ascx

<%@ Control language="C#" Inherits="DotNetNuke.Modules.Maintenance_bitaddresses.View" AutoEventWireup="false" Codebehind="View.ascx.cs" %>

<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

<telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0"

DataSourceID="SqlDataSourceAddresses" GridLines="None"

AutoGenerateColumns="False" AllowAutomaticDeletes="True"

AllowAutomaticInserts="True" AllowAutomaticUpdates="True"

AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True">

<mastertableview datasourceid="SqlDataSourceAddresses"

datakeynames="CryptoAddress,UserID">

<EditItemTemplate>

<telerik:RadTextBox ID="RadTextBox1" Runat="server" LabelWidth="64px"

Resize="None" Text='<%# Bind("CryptoAddress") %>' Width="160px">

</telerik:RadTextBox>

</EditItemTemplate>

<CommandItemSettings AddNewRecordText="Add" CancelChangesText="Cancel"

SaveChangesText="Save" ShowCancelChangesButton="True"

ShowExportToCsvButton="True" ShowSaveChangesButton="True" />

<Columns><telerik:GridBoundColumn DataField="CryptoAddress"

FilterControlAltText="Filter CryptoAddress column" HeaderText="Address"

ReadOnly="True" SortExpression="CryptoAddress" UniqueName="CryptoAddress"></telerik:GridBoundColumn><telerik:GridBoundColumn

DataField="AddressDescription"

FilterControlAltText="Filter AddressDescription column"

HeaderText="Description" SortExpression="AddressDescription"

UniqueName="AddressDescription"></telerik:GridBoundColumn><telerik:GridBoundColumn

DataField="UserID" DataType="System.Int32" Display="False"

FilterControlAltText="Filter UserID column" HeaderText="UserID" ReadOnly="True"

SortExpression="UserID" UniqueName="UserID"></telerik:GridBoundColumn></Columns></mastertableview>

</telerik:RadGrid>

<asp:SqlDataSource ID="SqlDataSourceAddresses" runat="server"

ConnectionString="<%$ ConnectionStrings:bitratemeConnectionString %>"

SelectCommand="SELECT [CryptoAddress], [AddressDescription], [UserID] FROM [user_cryptoaddresses] WHERE ([UserID] = @UserID)"

ConflictDetection="CompareAllValues"

DeleteCommand="DELETE FROM [user_cryptoaddresses] WHERE [CryptoAddress] = @original_CryptoAddress AND [UserID] = @original_UserID AND (([AddressDescription] = @original_AddressDescription) OR ([AddressDescription] IS NULL AND @original_AddressDescription IS NULL))"

InsertCommand="INSERT INTO [user_cryptoaddresses] ([CryptoAddress], [AddressDescription], [UserID]) VALUES (@CryptoAddress, @AddressDescription, @UserID)"

OldValuesParameterFormatString="original_{0}"

UpdateCommand="UPDATE [user_cryptoaddresses] SET [AddressDescription] = @AddressDescription WHERE [CryptoAddress] = @original_CryptoAddress AND [UserID] = @original_UserID AND (([AddressDescription] = @original_AddressDescription) OR ([AddressDescription] IS NULL AND @original_AddressDescription IS NULL))">

<DeleteParameters>

<asp:Parameter Name="original_CryptoAddress" Type="String" />

<asp:Parameter Name="original_UserID" Type="Int32" />

<asp:Parameter Name="original_AddressDescription" Type="String" />

</DeleteParameters>

<InsertParameters>

<asp:Parameter Name="CryptoAddress" Type="String" />

<asp:Parameter Name="AddressDescription" Type="String" />

<asp:Parameter Name="UserID" Type="Int32" />

</InsertParameters>

<SelectParameters>

<asp:Parameter Name="UserID" Type="Int32" />

</SelectParameters>

<UpdateParameters>

<asp:Parameter Name="AddressDescription" Type="String" />

<asp:Parameter Name="original_CryptoAddress" Type="String" />

<asp:Parameter Name="original_UserID" Type="Int32" />

<asp:Parameter Name="original_AddressDescription" Type="String" />

</UpdateParameters>

</asp:SqlDataSource>

　

[Shinu]

Hi Stoyan,

Your code works fine at my end. I see that you have set AutoGenerateDeleteColumn="True" and AutoGenerateEditColumn="True", setting these two properties in the Grid will give you Delete and Edit columns respectively. To show the Add New Record button, please set CommandItemDisplay property of the MasterTableView. Setting all this property to the RadGrid will give you Edit,Add,Delete for your Grid.
If this doesn't help,please provide your ASPX page code snippet.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True". . >
<MasterTableView CommandItemDisplay="Top">

Thanks,
Shinu

[Stoyan]

great that worked but now I only get to enter the Descirption column and not the Address

I have removed the EditTemplate that I was trying to use but it still only gives me to enter Description and not Address field :(

[Shinu]

Hi Stoyan,

When you set ReadOnly="true" for a column, that will not be available for Edit/Insert. Hence please set ReadOnly="false" for the columns that you want to edit.

Thanks,
Shinu

[Stoyan]

thanks

works perfect!