Hi, I'm trying to make my Checkbox clickable if that's a word.. I am having trouble because when I try to change it into a <telerik:GridTemplateColumn> with a the ItemTemplate stuff data does not get fetched from the server. To clear it up when I change it to a TemplateColumn the data from the server does not transfer and the checkboxes ARE clickable but checks do not appear where they should be. What I want is the checkboxes to appear as "clickable" and data appears where it should be, and also when a checkbox is checked the data will go to the SQL server. Sorry, if I'm asking for too much.... I'm still learning.:)
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server"> <div> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager> <telerik:RadGrid ID="CGRUnPaidFees2017" runat="server" AllowAutomaticInserts="True" CGRUnPaidFees2017_Init="true" OnItemDeleted="CGRUnPaidFees2017_ItemDeleted" OnItemInserted="CGRUnPaidFees2017_ItemInserted" OnItemUpdated="CGRUnPaidFees2017_ItemUpdated" OnPreRender="CGRUnPaidFees2017_PreRender" AllowAutomaticUpdates="True" AllowPaging="True" AutoGenerateColumns="True" DataSourceID="UnPaidFees2017" Height="945px" Width="1380px"><GroupingSettings CollapseAllTooltip="Collapse all groups" CaseSensitive="False"></GroupingSettings> <SortingSettings EnableSkinSortStyles="False" /><ExportSettings ExportOnlyData="True"></ExportSettings> <ClientSettings> <Scrolling AllowScroll="True" UseStaticHeaders="True" /> </ClientSettings> <MasterTableView AutoGenerateColumns="False" DataKeyNames="Paid" DataSourceID="UnPaidFees2017" PageSize="34" AllowFilteringByColumn="True" ShowGroupFooter="True" GridLines="Both"> <Columns> <telerik:GridBoundColumn DataField="School" HeaderButtonType="PushButton" FilterControlAltText="Filter School column" HeaderText="School" SortExpression="School" UniqueName="School"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Student_Matric" HeaderButtonType="PushButton" FilterControlAltText="Filter Student_Matric column" HeaderText="Student_Matric" SortExpression="Student_Matric" UniqueName="Student_Matric" DataType="System.Double"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Name" HeaderButtonType="PushButton" FilterControlAltText="Filter Name column" HeaderText="Name" SortExpression="Name" UniqueName="Name"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Fee_Amount" HeaderButtonType="PushButton" FilterControlAltText="Filter Fee_Amount column" HeaderText="Fee_Amount" SortExpression="Fee_Amount" UniqueName="Fee_Amount" DataType="System.Double"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Fee" FilterControlAltText="Filter Fee column" HeaderButtonType="PushButton" HeaderText="Fee" SortExpression="Fee" UniqueName="Fee"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Date_Issued" DataType="System.DateTime" HeaderButtonType="PushButton" FilterControlAltText="Filter Date_Issued column" HeaderText="Date_Issued" SortExpression="Date_Issued" UniqueName="Date_Issued"> </telerik:GridBoundColumn> <telerik:GridCheckboxColumn DataField="Paid" FilterControlAltText="Filter Paid column" HeaderText="Paid" HeaderButtonType="PushButton" SortExpression="Paid" UniqueName="Paid" AutoPostBackOnFilter="True"> </telerik:GridCheckboxColumn> </Columns> <EditFormSettings> </EditFormSettings> </MasterTableView> <FilterItemStyle HorizontalAlign="Left" VerticalAlign="Middle" /> <PagerStyle PageSizes="30;60;90;120" PageButtonCount="30" /></telerik:RadGrid> <asp:SqlDataSource ID="UnPaidFees2017" runat="server" ConnectionString="<%$ ConnectionStrings:pedrolConnectionString %>" SelectCommand="SELECT School, [Student Matric] AS Student_Matric, Name, [Fee Amount] AS Fee_Amount, Fee, [Date Issued] AS Date_Issued, Paid FROM UnPaidFees2017" UpdateCommand="UPDATE UnPaidFees2017 SET Paid = @Paid" OnSelecting="UnPaidFees2017_Selecting" InsertCommand="INSERT INTO UnPaidFees2017(Paid) VALUES (@Paid)"> <InsertParameters> <asp:Parameter Name="Paid" Type="Boolean" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="Paid" Type="Boolean" /> </UpdateParameters> </asp:SqlDataSource> </div> </form></body></html>
I know there's a bunch of junk in my <telerik:RadGrid /> I was trying to solve my issue and couldn't, let me know if you need more info, I'll send whatever I can.
1 Answer, 1 is accepted
0
Peter
Top achievements
Rank 1
Rank 1
answered on 08 Jun 2017, 09:03 PM
Nevermind, I solved it! Thanks