Sure, I took out all the other columns to make it easier to read but I do have other columns in this, but they are loading fine. My question is, what does the database field need to be? I can make it anything, I just can't figure out what the checkbox needs? I know you say it needs a boolean, but I tried changing the column isoverride to nvarchar and setting some values to 'true' and that didn't work. I also tried a bit where the values were 0 and 1 and that didn't work either. Right now, my column is bit returning 0 or 1
<telerik:RadScriptManager ID="RadScriptManager1" runat="server">
</telerik:RadScriptManager>
<script type="text/javascript">
function RowDblClick(sender, eventArgs) {
idx = eventArgs.get_itemIndexHierarchical();
sender.get_masterTableView().editItem(idx);
}
function RowClick(sender, eventArgs) {
idx = eventArgs.get_itemIndexHierarchical();
sender.get_masterTableView().editItem(idx);
}
</script>
<telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None" AllowPaging="False" BorderStyle="Solid"
BorderColor="#0f0F6F" CellPadding="5" DataSourceID="SqlDataSource1"
AllowSorting="False" AutoGenerateColumns="false" Width="950px" OnUpdateCommand="radgridUpdate">
<ClientSettings>
<ClientEvents OnRowDblClick="RowDblClick" />
<ClientEvents OnRowClick="RowClick" />
</ClientSettings>
<MasterTableView DataKeyNames="overrideId" AutoGenerateColumns="false" EditMode="PopUp">
<ItemStyle CssClass="myRow" Height="60px" />
<AlternatingItemStyle CssClass="alternateRow" Height="60px" />
<RowIndicatorColumn>
<HeaderStyle Width="20px" HorizontalAlign="Right"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<Columns>
<telerik:GridCheckBoxColumn DataField="isOverride" HeaderText="Override" SortExpression="isoverride"
UniqueName="isoverride" >
</telerik:GridCheckBoxColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:connection %>"
SelectCommand="SELECT [overrideId], [name], [pointId], ISNULL([minValue], 0) AS minValue, ISNULL([maxValue], 0) AS maxValue,
ISNULL([defaultValue], 0) as defaultValue, ISNULL([overrideValue], 0) AS overridValue FROM [Override]">
</asp:SqlDataSource>