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
>
I think that about covers it. Here's the Update command for SQL:
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)