or
							<%@ Page Title="" Language="C#" MasterPageFile="~/Masters/EPSDev3.master" AutoEventWireup="true" CodeFile="PetitionInfo.aspx.cs" Inherits="PetitionInfo" %><asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"><style type="text/css">    .VerticalAlign1      {          padding-top: 6px;    }        .style1        {            height: 31px;        }        .RadGrid_Default .rgHeaderDiv        {            width: 785px !important;        }        .RadGrid_Default .rgFooterDiv        {            width: 785px !important;        }</style> </asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">      <telerik:RadScriptManager ID="RadScriptManager1" runat="server" />        <!-- content start -->        <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">            <AjaxSettings>                <telerik:AjaxSetting AjaxControlID="SignersGrid">                    <UpdatedControls>                        <telerik:AjaxUpdatedControl ControlID="SignersGrid" LoadingPanelID="RadAjaxLoadingPanel1" />                    </UpdatedControls>                </telerik:AjaxSetting>            </AjaxSettings>        </telerik:RadAjaxManager>        <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" AlternateText="Loading..." Skin="Black" runat="server"  />    <div style="width: 800px;">        <div style="float: left; background-color: White; padding: 0px;">            <table cellpadding="1" cellspacing="0" border="0" >                <tr>                    <td colspan="5" align="center" >                        <h2>                            <asp:Label ID="VoterAuthenticationLabel" runat="server" Text="<%$ Resources:Resource, PetitionInformationLabel %>"></asp:Label>                        </h2>                    </td>                </tr>                <tr>                    <td width="2%">                                              </td>                    <td width="47%" valign="top">                        <table >                            <tr>                                <td colspan="2" align="left" style="font-weight: normal; height: 12px;">                                    <asp:Label ID="Label6" runat="server" Font-Bold="true" Text="<%$ Resources:Resource, CandidateInformationLabel%>"></asp:Label>                                </td>                            </tr>                            <tr>                                <td align="left">                                    <asp:Label ID="CycleLabel" runat="server" Text="<%$ Resources:Resource, CycleLabel %>"></asp:Label>                                </td>                                <td align="left">                                    <asp:Label ID="ElectionCycleList" runat="server" Text=""></asp:Label>                                </td>                            </tr>                            <tr>                                <td align="left">                                    <asp:Label ID="Label1" runat="server" Text="<%$ Resources:Resource, RaceLabel %>"></asp:Label>                                </td>                                <td align="left">                                    <asp:Label ID="PoliticalRaceList" runat="server" Text=""></asp:Label>                                </td>                            </tr>                            <tr>                                <td align="left">                                    <asp:Label ID="Label2" runat="server" Text="<%$ Resources:Resource, NameLabel %>"></asp:Label>                                </td>                                <td align="left">                                    <asp:Label ID="CandidateName" runat="server" Text=""></asp:Label>                                </td>                            </tr>                            <tr>                                <td align="left">                                    <asp:Label ID="Label3" runat="server" Text="<%$ Resources:Resource, AddressLabel %>"></asp:Label>                                </td>                                <td align="left">                                    <asp:Label ID="CandidateAddress" runat="server" Text=""></asp:Label>                                </td>                            </tr>                            <tr>                                <td align="left">                                    <asp:Label ID="Label4" runat="server" Text="<%$ Resources:Resource, CityStZipLabel %>"></asp:Label>                                </td>                                <td align="left">                                    <asp:Label ID="CandidateCity" runat="server" Text=""></asp:Label>                                                                           <asp:Label ID="CandidateState" runat="server" Text=""></asp:Label>                                                                           <asp:Label ID="CandidateZipCode" runat="server" Text=""></asp:Label>                                </td>                            </tr>                            <tr>                                <td align="left">                                    <asp:Label ID="Label5" runat="server" Text="<%$ Resources:Resource, CountyLabel %>"></asp:Label>                                </td>                                <td align="left">                                    <asp:Label ID="CandidateCountyList" runat="server" Text=""></asp:Label>                                </td>                            </tr>                        </table>                    </td>                    <td width="2%">                                              </td>                    <td width="47%"  valign="top">                        <table width="100%">                            <tr>                                <td colspan="2" align="left" style="font-weight: normal; height: 12px;">                                    <asp:Label ID="Label7" runat="server" Font-Bold="true" Text="<%$ Resources:Resource, ContactInformationLabel%>"></asp:Label>                                </td>                            </tr>                            <tr>                                <td align="left">                                    <asp:Label ID="Label8" runat="server" Text="<%$ Resources:Resource, NameLabel %>"></asp:Label>                                </td>                                <td align="left">                                    <asp:Label ID="ContactName" runat="server" Text=""></asp:Label>                                </td>                            </tr>                            <tr>                                <td align="left">                                    <asp:Label ID="Label9" runat="server" Text="<%$ Resources:Resource, PhoneLabel %>"></asp:Label>                                </td>                                <td align="left">                                    <asp:Label ID="ContactPhone" runat="server" Text=""></asp:Label>                                </td>                            </tr>                            <tr>                                <td align="left">                                    <asp:Label ID="Label10" runat="server" Text="<%$ Resources:Resource, EmailLabel %>"></asp:Label>                                </td>                                <td align="left">                                    <asp:Label ID="ContactEmailAddress" runat="server" Text=""></asp:Label>                                </td>                            </tr>                            <tr>                                <td align="left">                                    <asp:Label ID="Label11" runat="server" Text="<%$ Resources:Resource, WebSiteLabel %>"></asp:Label>                                </td>                                <td align="left">                                    <asp:Label ID="ContactWebSiteURL" runat="server" Text=""></asp:Label>                                </td>                            </tr>                            <tr>                                <td align="left">                                    <asp:Label ID="Label16" runat="server" Text="<%$ Resources:Resource, LinkToLabel %>"></asp:Label>                                </td>                                <td align="left">                                    <asp:Label ID="LinkToURL" runat="server" Text=""></asp:Label>                                </td>                            </tr>                        </table>                    </td>                    <td width="2%">                                              </td>                </tr>                <tr>                    <td colspan="5">                                              </td>                </tr>                <tr >                    <td>                                              </td>                        <td align="center" valign="middle" colspan="3" >                            <asp:Label CssClass="VerticalAlign1" ID="PetitionsListTitle" Font-Size="16px" Width="100%" BackColor="#565A43" Height="24px" ForeColor="#ffffff" Font-Bold="true" runat="server" Text="<%$ Resources:Resource, PetitionSignersLabel %>"></asp:Label>                        </td>                    <td>                                              </td>                </tr>                <tr>                    <td width="2%">                                              </td>                    <td colspan="3" valign="middle">                        <telerik:RadGrid AutoGenerateColumns="false" ID="SignersGrid" runat="server" Width="785px"                            AllowSorting="true" AllowFilteringByColumn="true" EnableLinqExpressions="true"                            AllowPaging="false" PageSize="15" CommandItemDisplay="Bottom"                            BorderWidth="1px" BorderColor="#999999" EnableEmbeddedSkins="true" Skin="Default"                            DataSourceID="SQLDataSource1"                            ShowStatusBar="true"                            ShowFooter="false" GridLines="None" >                            <PagerStyle Mode="NextPrevAndNumeric" />                            <GroupingSettings CaseSensitive="false" />                            <StatusBarSettings ReadyText="Ready" LoadingText="Loading..." />                             <MasterTableView AutoGenerateColumns="false" EditMode="InPlace" AllowFilteringByColumn="True"                                ShowFooter="True" TableLayout="Auto">                                <Columns>                                    <telerik:GridBoundColumn HeaderStyle-Width="150px" HeaderText="First Name" UniqueName="FirstName" DataField="FirstName" SortExpression="FirstName" >                                    </telerik:GridBoundColumn>                                    <telerik:GridBoundColumn HeaderStyle-Width="150px" UniqueName="LastName" HeaderText="Last Name" DataField="LastName" SortExpression="LastName" >                                    </telerik:GridBoundColumn>                                    <telerik:GridBoundColumn HeaderStyle-Width="350px" UniqueName="VoterAddress" HeaderText="Address" DataField="Address" SortExpression="Address"  >                                    </telerik:GridBoundColumn >                                    <telerik:GridButtonColumn CommandName="RemoveSigner" HeaderStyle-Width="135px" UniqueName="RemoveSigner" HeaderText="Remove" ButtonType="PushButton" Text="Remove" ConfirmText="Are you certain that you want to remove this signature?" >                                    </telerik:GridButtonColumn>                                </Columns>                            </MasterTableView>                            <ClientSettings>                                <Scrolling AllowScroll="true" UseStaticHeaders="true" />                            </ClientSettings>                        </telerik:RadGrid>                    </td>                    <td width="2%">                                              </td>                </tr>                <tr>                    <td colspan="5" align="center" >                        <asp:Label ID="Label17" runat="server" Text=""></asp:Label>                    </td>                </tr>                <tr>                    <td colspan="5" align="center" >                        <asp:Label ID="SignatureCountMessage" runat="server" Text=""></asp:Label>                    </td>                </tr>                <tr>                    <td colspan="5" align="center" >                        <asp:Label ID="Label18" runat="server" Text=""></asp:Label>                    </td>                </tr>                <tr>                    <td colspan="5" align="center" >                                              </td>                </tr>                <tr >                    <td>                                              </td>                        <td align="center" valign="middle" colspan="3" >                            <asp:Label CssClass="VerticalAlign1" ID="Label14" Font-Size="16px" Width="100%" BackColor="#565A43" Height="24px" ForeColor="#ffffff" Font-Bold="true" runat="server" Text="<%$ Resources:Resource, CloseAndPrintLabel %>"></asp:Label>                        </td>                    <td>                                              </td>                </tr>                <tr>                    <td colspan="5" align="center" >                                              </td>                </tr>                <tr>                    <td colspan="5" align="center" >                        <asp:Button ID="ReturnToMyDocs" runat="server" TabIndex="6"                            Text="<%$ Resources:Resource, ReturnToMyEDocs %>"                             onclick="ReturnToMyDocs_Click" />                                                    <asp:Button ID="ClosePetitionButton" TabIndex="7" runat="server" Text="<%$ Resources:Resource, ClosePetitionBtn %>" />                                                    <asp:Button ID="PrintListButton" TabIndex="8" runat="server" Text="<%$ Resources:Resource, PrintListBtn %>" />                                                    <asp:Button ID="PrintForFilingButton" TabIndex="9" runat="server" Text="<%$ Resources:Resource, PrintForFilingBtn %>" />                    </td>                </tr>                <tr>                    <td colspan="5" align="center" >                                              </td>                </tr>            </table>        </div>        <div class="clear">        </div>    </div>    <asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:ElectronicPetitionSystemConnectionString %>"        ProviderName="System.Data.SqlClient" runat="server">    </asp:SqlDataSource></asp:Content>using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using Telerik.Web.UI;using System.Configuration;using System.Data;using System.Data.SqlClient;public partial class PetitionInfo : System.Web.UI.Page{    protected void Page_Init(object sender, EventArgs e)    {            //  Set the sql statement for the sql data source            string griddatasource = "SELECT VoterSignatureId, PetitionId, LastName, FirstName, MiddleName, NameSuffix, [Address], CountyId, Email, SignatureImage, CountyVoterId, ";            griddatasource = griddatasource + "MvdSerialNumber, DateSigned, ClientIpAddress, VoterSignatureStatusId, CreatedDate, ModifiedDate ";            griddatasource = griddatasource + "FROM VoterSignatures ";            string gridWHERE = "WHERE PetitionId = " + Request.QueryString["PID"];            SqlDataSource1.SelectCommand = griddatasource + gridWHERE;    }    protected void Page_Load(object sender, EventArgs e)    {        if (!IsPostBack)        {            if (Request.QueryString["PID"].Length > 0)            {                Int32 iMyKeyValue = Convert.ToInt32(Request.QueryString["PID"]);                ElectronicPetitionSystemDataContext efdc = new ElectronicPetitionSystemDataContext();                var petn =                    (from pe in efdc.Misc_GetPetitionInfo(iMyKeyValue)                     select pe).First();                //  First display the individual fields at the top of the screen                this.ElectionCycleList.Text = petn.CycleName;                this.PoliticalRaceList.Text = petn.OfficeDescription;                this.CandidateName.Text = petn.CandidateDisplayName;                this.CandidateAddress.Text = petn.Address1;                this.CandidateCity.Text = petn.City;                this.CandidateState.Text = petn.State;                this.CandidateZipCode.Text = petn.Zip;                this.CandidateCountyList.Text = petn.CountyName;                this.ContactName.Text = petn.ContactDisplayName;                this.ContactPhone.Text = petn.ContactPhone;                this.ContactEmailAddress.Text = petn.ContactEmail;                this.ContactWebSiteURL.Text = petn.ContactLink;                this.LinkToURL.Text = Convert.ToString(petn.DeepLinkGuid);            }        }                SignatureCountMessage.Text = "(" + (String)GetGlobalResourceObject("Resource", "YouCurrentlyHave1") + " nn " + (String)GetGlobalResourceObject("Resource", "YouCurrentlyHave2") + " nnnn " + (String)GetGlobalResourceObject("Resource", "YouCurrentlyHave3") + ")";    }    //  Telerik grid sample with filtering, etc.    //    //    //  The following link may be a better example for the SQL/filtering handling    protected void ReturnToMyDocs_Click(object sender, EventArgs e)    {        Response.Redirect("MyeDocs.aspx");    }}
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="FixedHeader.aspx.vb" Inherits="FixedHeader" %>   <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">   <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title></title> </head> <body>     <form id="form1" runat="server">     <div>             <telerik:RadScriptManager runat="server" ID="mgrJS">         </telerik:RadScriptManager>           <div style="overflow:scroll;overflow-y:hidden;width:400px" >                     <telerik:RadGrid runat="server" ID="dgHeader" Skin="Web20" >                 <ClientSettings>                     <Scrolling UseStaticHeaders="True" />                     <Selecting EnableDragToSelectRows="False" />                 </ClientSettings>                 <MasterTableView BorderWidth="1px" GridLines="Both" style="border-collapse: collapse !Important;" Font-Bold="false" TableLayout="Fixed" AutoGenerateColumns="false" ShowHeader="True">                     <RowIndicatorColumn Visible="False">                         <HeaderStyle Width="20px" />                     </RowIndicatorColumn>                     <ExpandCollapseColumn Resizable="False" Visible="False">                         <HeaderStyle Width="20px" />                     </ExpandCollapseColumn>                     <EditFormSettings>                         <PopUpSettings ScrollBars="None" />                     </EditFormSettings>                 </MasterTableView>             </telerik:RadGrid>            </div>      </div>     </form> </body> </html> Partial Class FixedHeader     Inherits System.Web.UI.Page       Dim dtCols As New DataTable     Dim dtHeader As New DataTable       Protected Sub dgHeaderAPO_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles dgHeader.NeedDataSource         dgHeader.DataSource = dtHeader     End Sub      Protected Sub FixedHeader_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load         'Grid columns will be defined off of this table         dtCols.Columns.Add(New DataColumn("COL_ID", GetType(String)))         Dim colRow As DataRow = dtCols.NewRow         colRow(0) = "1234567"        dtCols.Rows.Add(colRow)         colRow = dtCols.NewRow         colRow(0) = "2345678"        dtCols.Rows.Add(colRow)         colRow = dtCols.NewRow         colRow(0) = "3456789"        dtCols.Rows.Add(colRow)         colRow = dtCols.NewRow         colRow(0) = "4567890"        dtCols.Rows.Add(colRow)         colRow = dtCols.NewRow         colRow(0) = "5678901"        dtCols.Rows.Add(colRow)         colRow = dtCols.NewRow         colRow(0) = "6789012"        dtCols.Rows.Add(colRow)         colRow = dtCols.NewRow         colRow(0) = "7890123"        dtCols.Rows.Add(colRow)           'Create Header table         For Each dr As DataRow In dtCols.Rows             dtHeader.Columns.Add(New DataColumn(dr("COL_ID"), GetType(Integer)))         Next          'Populate w/ data         Dim Generator As System.Random = New System.Random()         Dim r As DataRow = dtHeader.NewRow         For j As Integer = 0 To 6             r(j) = Generator.Next(0, 100)         Next        dtHeader.Rows.Add(r)           'Define columns of master table view.         For Each row As DataRow In dtCols.Rows             Dim newCol As New GridBoundColumn             dgHeader.MasterTableView.Columns.Add(newCol)             newCol.HeaderText = row("COL_ID")             newCol.DataField = row("COL_ID")             newCol.DataFormatString = "{0:N0}"            newCol.HeaderStyle.Width = 100             newCol.ItemStyle.Width = 100         Next    End Sub      Protected Sub dgHeaderAPO_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles dgHeader.PreRender         If dgHeader.MasterTableView.GetItems(GridItemType.Header).Length > 0 Then              Dim header As GridHeaderItem = DirectCast(dgHeader.MasterTableView.GetItems(GridItemType.Header)(0), GridHeaderItem)             Dim head As GridTHead = DirectCast(header.Parent, GridTHead)               'create a new GridHeaderItem which will be the new row               Dim newHeaderItem As New GridHeaderItem(dgHeader.MasterTableView, 0, 0)               'add 2 empty table header cells, as there are 2 hidden columns always created in RadGrid             newHeaderItem.Cells.Add(New GridTableHeaderCell())             newHeaderItem.Cells.Add(New GridTableHeaderCell())               Dim leftMargin As Integer = 0             Select Case dtCols.Rows.Count                 Case 1, 2                     leftMargin = 0                 Case 3                     leftMargin = 50                 Case 4                     leftMargin = 75                 Case 4                     leftMargin = 100                 Case Else                    leftMargin = 125             End Select              'Uncentered code without resizing issue             'newHeaderItem.Cells.Add(New GridTableHeaderCell() With {.Text = "<input id='cbAll' type='checkbox');' \>CENTER ME", .ColumnSpan = dtCols.Rows.Count})               'Centered code with resizing issue             newHeaderItem.Cells.Add(New GridTableHeaderCell() With {.Text = "<div style='width:130px;position:fixed;margin-left:" & leftMargin & "px;'><input id='cbAll' type='checkbox');' \>CENTER ME</div>", .ColumnSpan = dtCols.Rows.Count})             head.Controls.AddAt(0, newHeaderItem)           End If      End SubEnd Classe.Appointment.Start, e.Appointment.End, e.Appointment.Subject, e.Appointment.Description
it shows only the values in the database in radScheduler1_AppointmentUpdate event
i have binded the schedulder thru a sqlDatasource only using select command.
is there any solution for it?
function dropRowOnTree(args) {
                   args.get_destinationHtmlElement().click();