naheedkassam 9 Newbie Poster

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.