im using the evaluation package so I don't know if this is a limitation but here goes.. I cannot edit data from any of my controls. Here is the following
Create a dummy SQL table
CREATE TABLE [EducationDates] (
[EMPL_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[EducationType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[EducationDate] [datetime] NOT NULL ,
[EducationID] [int] IDENTITY (1, 1) NOT NULL ,
CONSTRAINT [PK_EducationDates] PRIMARY KEY CLUSTERED
(
[EducationID]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
--MAKE SURE YOU HAVE A PK and THAT IT CAN AUTOINCREMENT
--ADD SOME ROW DATA
-
create new aspx vb page.
- add rad script manager
- add RadGrid
- Add SQLDatasource (code below)
- Bind to DS
- Enable 'AutoGenerateEditColumn' = True'
- Run it..
- The app won't edit
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:phcJobPostsDevConnectionString %>"DeleteCommand="DELETE FROM [EducationDates] WHERE [EducationID] = @EducationID"InsertCommand="INSERT INTO [EducationDates] ([EMPL_ID], [EducationType], [EducationDate]) VALUES (@EMPL_ID, @EducationType, @EducationDate)"SelectCommand="SELECT * FROM [EducationDates]" UpdateCommand="UPDATE [EducationDates] SET [EducationDate] = @EducationDate WHERE [EducationID] = @EducationID">
<DeleteParameters>
<asp:Parameter Name="EducationID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="EducationDate" Type="DateTime" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="EMPL_ID" Type="String" />
<asp:Parameter Name="EducationType" Type="String" />
<asp:Parameter Name="EducationDate" Type="DateTime" />
</InsertParameters>
</asp:SqlDataSource>
<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1"
GridLines="None">
<MasterTableView AutoGenerateColumns="False" DataKeyNames="EducationID" DataSourceID="SqlDataSource1">
<RowIndicatorColumn Visible="False">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<ExpandCollapseColumn Resizable="False" Visible="False">
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn DataField="EMPL_ID" HeaderText="EMPL_ID" SortExpression="EMPL_ID"
UniqueName="EMPL_ID">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="EducationType" HeaderText="EducationType" SortExpression="EducationType"
UniqueName="EducationType">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="EducationDate" DataType="System.DateTime" HeaderText="EducationDate"
SortExpression="EducationDate" UniqueName="EducationDate">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="EducationID" DataType="System.Int32" HeaderText="EducationID"
ReadOnly="True" SortExpression="EducationID" UniqueName="EducationID">
</telerik:GridBoundColumn>
</Columns>
<EditFormSettings>
<PopUpSettings ScrollBars="None" />
</EditFormSettings>
</MasterTableView>
</telerik:RadGrid>