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

[Solved] can't edit or insert any data ??

2 Answers 163 Views
Grid
This is a migrated thread and some comments may be shown as answers.
mac
Top achievements
Rank 1
mac asked on 22 May 2008, 05:50 PM

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

  1.  create new aspx vb page.

  2. add rad script manager
  3. add RadGrid
  4. Add SQLDatasource (code below)
  5. Bind to DS
  6. Enable 'AutoGenerateEditColumn' = True'
  7. Run it..
  8. 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>

2 Answers, 1 is accepted

Sort by
0
hazzoom
Top achievements
Rank 1
answered on 22 May 2008, 09:04 PM
Try these attriputes

<

telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True"...

<
MasterTableView CommandItemDisplay="TopAndBottom"...

Regards :)

0
Shinu
Top achievements
Rank 2
answered on 23 May 2008, 05:14 AM
Hi,

Go through the following demo link.
Automatic operations

Shinu.
Tags
Grid
Asked by
mac
Top achievements
Rank 1
Answers by
hazzoom
Top achievements
Rank 1
Shinu
Top achievements
Rank 2
Share this question
or