Okay, so I have a RadGrid that is being filled with data. I have an edit column. I click the edit column, change a record, and hit update. It posts back to the page, and goes back to the radgrid, only the update didn't happen.
1. My first assumption was that I forgot to set it up so that radgrid would refresh, so I check the data table in the SQL database, only to find that the update simply didn't happen, so...
2. I check the ObjectDataSource; yup, all parameters exist.
3. I check the SQL to make sure the update is correct. Yup, the update is correct.
So in essence, all my code is correct, it's Radgrid that is not working. The question is, why? If anyone has a clue, please let me know. It's probably something that tired eyes are merely overlooking. I think I lost a little more of my hair over this one...lol.
...so here's the relevant .aspx code;
<telerik:RadGrid ID="RecentReviewsGrid" runat="server" AllowAutomaticUpdates="True" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="dsTransactionReview" GridLines="None" HorizontalAlign="Center" PageSize="20"> <mastertableview datakeynames="TransactionID" datasourceid="dsTransactionReview" headerstyle-horizontalalign="Center"> <commanditemsettings exporttopdftext="Export to Pdf" /> <rowindicatorcolumn> <HeaderStyle Width="20px" /> </rowindicatorcolumn> <expandcollapsecolumn> <HeaderStyle Width="20px" /> </expandcollapsecolumn> <Columns> <telerik:GridBoundColumn DataField="TransactionID" DataType="System.Int32" HeaderText="TransactionID" ReadOnly="True" SortExpression="TransactionID" UniqueName="TransactionID" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="OrderID" DataType="System.Int32" HeaderText="OrderID" SortExpression="OrderID" UniqueName="OrderID"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="OrderDate" DataType="System.DateTime" HeaderText="OrderDate" SortExpression="OrderDate" UniqueName="OrderDate" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CreatedBy" HeaderText="CreatedBy" SortExpression="CreatedBy" UniqueName="CreatedBy"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CategoryType" HeaderText="CategoryType" SortExpression="CategoryType" UniqueName="CategoryType"> </telerik:GridBoundColumn> <telerik:GridCheckBoxColumn DataField="IsEntryCorrect" DataType="System.Boolean" HeaderStyle-Width="50px" HeaderText="Correct Code?" ItemStyle-Width="50px" SortExpression="IsEntryCorrect" UniqueName="IsEntryCorrect"> <HeaderStyle Width="50px" /> <ItemStyle Width="50px" /> </telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn DataField="Suitable" DataType="System.Boolean" HeaderStyle-Width="50px" HeaderText="Suitable?" ItemStyle-Width="50px" SortExpression="Suitable" UniqueName="Suitable"> <HeaderStyle Width="50px" /> <ItemStyle Width="50px" /> </telerik:GridCheckBoxColumn> <telerik:GridBoundColumn DataField="CorrectCode" HeaderText="Correct Code" SortExpression="CorrectCode" UniqueName="CorrectCode"> </telerik:GridBoundColumn> <telerik:GridCheckBoxColumn DataField="NeedCoached" DataType="System.Boolean" HeaderStyle-Width="50px" HeaderText="Need Coached?" ItemStyle-Width="50px" SortExpression="NeedCoached" UniqueName="NeedCoached"> <HeaderStyle Width="50px" /> <ItemStyle Width="50px" /> </telerik:GridCheckBoxColumn> <telerik:GridBoundColumn DataField="Comments" HeaderText="Comments" SortExpression="Comments" UniqueName="Comments"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DateReviewed" DataType="System.DateTime" HeaderText="Review Date" SortExpression="DateReviewed" UniqueName="DateReviewed"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Reviewer" HeaderText="Reviewer" SortExpression="Reviewer" UniqueName="Reviewer"> </telerik:GridBoundColumn> <telerik:GridEditCommandColumn UniqueName="EditCommand"> </telerik:GridEditCommandColumn> </Columns> <HeaderStyle HorizontalAlign="Center" /> </mastertableview> </telerik:RadGrid> <asp:ObjectDataSource ID="dsTransactionReview" runat="server" DeleteMethod="Delete" OldValuesParameterFormatString="{0}" SelectMethod="GetData" TypeName="Pan_App.PanDataTableAdapters.Tink_CoachingTableAdapter" UpdateMethod="Update"> <DeleteParameters> <asp:Parameter Name="TransactionID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="OrderID" Type="Int32" /> <asp:Parameter Name="OrderDate" Type="DateTime" /> <asp:Parameter Name="CreatedBy" Type="String" /> <asp:Parameter Name="CategoryType" Type="String" /> <asp:Parameter Name="IsEntryCorrect" Type="Boolean" /> <asp:Parameter Name="Suitable" Type="Boolean" /> <asp:Parameter Name="CorrectCode" Type="String" /> <asp:Parameter Name="NeedCoached" Type="Boolean" /> <asp:Parameter Name="Comments" Type="String" /> <asp:Parameter Name="DateReviewed" Type="DateTime" /> <asp:Parameter Name="Reviewer" Type="String" /> <asp:Parameter Name="TransactionID" Type="Int32" /> </UpdateParameters> </asp:ObjectDataSource>UPDATE TableName SET OrderID = @OrderID, OrderDate = @OrderDate, CreatedBy = @CreatedBy, CategoryType = @CategoryType, IsEntryCorrect = @IsEntryCorrect, Suitable = @Suitable, CorrectCode = @CorrectCode, NeedCoached = @NeedCoached, Comments = @Comments, DateReviewed = @DateReviewed, Reviewer = @Reviewer WHERE (TransactionID = @TransactionID)if (!this.IsPostBack) { this.RadGrid1.MasterTableView.Items[1].Edit = true; this.RadGrid1.MasterTableView.Rebind(); } <asp:Button ID="btnUpdate" Text="Update" runat="server" CommandName="Update" Visible='<%# !(DataItem is Telerik.Web.UI.GridInsertionObject) %>' Font-Size="0.9em" /> </td> <td> <asp:Button ID="btnCancel" runat="server" Text="Cancel" CausesValidation="false" CommandName="Cancel" Font-Size="0.9em" />
rsScheduler.Localization.Show24Hours = (
string)_Master.m_FormLabels["Show 24 hours..."];
<telerik:RadScheduler ID="rsScheduler" runat="server" Skin="Office2009" EnableEmbeddedSkins="false"
DataKeyField="RecordID" DataStartField="StartDate" DataEndField="EndDate" DataSubjectField="Name"
Height="100%" Width="100%" OnNavigationCommand="rsScheduler_OnNavigationCommand" OnAppointmentDataBound="rsScheduler_AppointmentDataBound"
OnClientAppointmentDoubleClick="OnClientAppointmentDoubleClick" OnClientAppointmentInserting="OnClientAppointmentInserting" OnClientAppointmentCreated="OnClientAppointmentCreated" AllowDelete="false" AllowEdit="false" ShowDateHeaders="True" ShowNavigationPane="True" BorderStyle="NotSet" OverflowBehavior="Scroll">
<Localization AdvancedAllDayEvent="All day"></Localization>
<AppointmentTemplate>
<div class="rsAptContent"><img id="imgAppt" src="<%# Eval("Attributes[\"IconUrl\"]") %>" /> <%# Eval("Subject") %></div>
</AppointmentTemplate>
</telerik:RadScheduler>