I have a table in sql that holds the rights and values (True/false) for different groups for an application. Using sqldataconnection I have been able to get that data into a radgrid, but all the check boxes have been disabled. How do I enable them so that a user can check/uncheck them?
I have given the code below
<telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None" Height="164px"
Skin="Windows7" DataSourceID="SqlDataSource1" AutoGenerateColumns="False"
onneeddatasource="RadGrid1_NeedDataSource" onprerender="RadGrid1_PreRender"
onselectedindexchanged="RadGrid1_SelectedIndexChanged"
AutoGenerateEditColumn="True">
<MasterTableView DataSourceID="SqlDataSource1">
<Columns>
<telerik:GridBoundColumn DataField="RIGHT_NAME" DefaultInsertValue=""
HeaderText="RIGHT" SortExpression="RIGHT_NAME" UniqueName="RIGHT_NAME" AutoPostBackOnFilter="true" >
</telerik:GridBoundColumn>
<telerik:GridCheckBoxColumn DataField="RIGHT_ADD" DataType="System.Boolean"
DefaultInsertValue="" HeaderText="ADD" SortExpression="RIGHT_ADD"
UniqueName="RIGHT_ADD">
</telerik:GridCheckBoxColumn>
<telerik:GridCheckBoxColumn DataField="RIGHT_VIEW" DataType="System.Boolean"
DefaultInsertValue="" HeaderText="VIEW" SortExpression="RIGHT_VIEW"
UniqueName="RIGHT_VIEW" EditFormColumnIndex="1">
</telerik:GridCheckBoxColumn>
<telerik:GridCheckBoxColumn DataField="RIGHT_EDIT" DataType="System.Boolean"
DefaultInsertValue="" HeaderText="EDIT" SortExpression="RIGHT_EDIT"
UniqueName="RIGHT_EDIT">
</telerik:GridCheckBoxColumn>
<telerik:GridCheckBoxColumn DataField="RIGHT_DELETE" DataType="System.Boolean"
DefaultInsertValue="0" HeaderText="DELETE" SortExpression="RIGHT_DELETE"
UniqueName="RIGHT_DELETE" EditFormColumnIndex="1">
</telerik:GridCheckBoxColumn>
<telerik:GridBoundColumn DataField="RIGHT_TYPE" DefaultInsertValue=""
HeaderText="TYPE" SortExpression="RIGHT_TYPE" UniqueName="RIGHT_TYPE">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="RIGHT_VALUE" DefaultInsertValue=""
HeaderText="VALUE" SortExpression="RIGHT_VALUE" UniqueName="RIGHT_VALUE">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ClientSettings>
<Selecting AllowRowSelect="True" />
</ClientSettings>
</telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:dbConnstr %>"
SelectCommand="SELECT [RIGHT_NAME], [RIGHT_ADD], [RIGHT_VIEW], [RIGHT_EDIT], [RIGHT_DELETE], [RIGHT_TYPE], [RIGHT_VALUE] FROM [USR_TOTAL_RIGHTS] ORDER BY [RIGHT_NAME]">
</asp:SqlDataSource>
Please someone assist me.