Telerik Forums
UI for ASP.NET AJAX Forum
or
Ask question
All Questions
Unanswered
Answered
110,824 questions
12 answers
173 views
[Solved] InsertCommand not triggered
Hi all:
I must be doing something wrong in the settings as I can't seem to figure out why my listbox isn't auto updating.  I've used this demo to help me on my way, and I successfully have the delete statement working great.  I need to get the "insert" to work.  Here's my code:

.aspx
<telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanel1" />
<telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel1" LoadingPanelID="RadAjaxLoadingPanel1">
<telerik:RadListBox ID="pasLead_rlb" runat="server" Height="150px" Width="250px" AllowTransfer="true" TransferToID="pasLead_rlbDestination"
    DataSourceID="paslead_DS" DataTextField="paslead" DataValueField="contactID">
</telerik:RadListBox>
<telerik:RadListBox ID="pasLead_rlbDestination" runat="server" Height="150px" Width="250px" DataKeyField="contactID" AutoPostBackOnTransfer="true" AutoPostBack="true"
    DataSourceID="pasleadSelected_DS" DataTextField="paslead" DataValueField="contactID" AllowAutomaticUpdates="true" AutoPostBackOnDelete="true" AllowDelete="true">
</telerik:RadListBox>
</telerik:RadAjaxPanel>

sqldatasource
<asp:SqlDataSource ID="pasleadSelected_DS" runat="server"
    ConnectionString="<%$ ConnectionStrings:myconnection %>"
    SelectCommand="SELECT contacts.id AS contactID, contacts.name + ' (' + groups.short_name + ')' AS paslead
                    FROM contacts,
                        groups,
                        area_contact_map acm
                    WHERE contacts.groupID = groups.id
                        and contacts.id = acm.contactID
                        and areaID = @id
                        and (acm.blnRemoved IS NULL OR acm.blnRemoved = 0)
                    ORDER BY paslead"
    DeleteCommand="UPDATE area_contact_map SET update_date = getDate(), update_user = @u, blnRemoved = 1 WHERE areaID = @aid AND contactID = @contactID"
    InsertCommand="INSERT INTO area_contact_map (areaID, contactID, create_date, create_user, blnRemoved) VALUES (@aid, @contactID, getDate(), @u, 0)">
    <SelectParameters>
        <asp:Parameter Name="id" Type="String" />
    </SelectParameters>
    <DeleteParameters>
        <asp:Parameter Name="aid" Type="String" />
        <asp:Parameter Name="contactID" Type="String" />
        <asp:Parameter Name="u" Type="String" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="aid" Type="String" />
        <asp:Parameter Name="contactID" Type="String" />
        <asp:Parameter Name="u" Type="String" />
    </InsertParameters>
</asp:SqlDataSource>

.vb
aid = Request.QueryString("i")
pasuser = Membership.GetUser.ProviderUserKey.ToString()
 
areaDS.SelectParameters("id").DefaultValue = aid
pasleadSelected_DS.SelectParameters("id").DefaultValue = aid
pasleadSelected_DS.DeleteParameters("aid").DefaultValue = aid
pasleadSelected_DS.DeleteParameters("u").DefaultValue = pasuser
pasleadSelected_DS.InsertParameters("aid").DefaultValue = aid
pasleadSelected_DS.InsertParameters("u").DefaultValue = pasuser

The action I need to track automatically, is when the user moves an item from paslead_rlb to paslead_rlbDestination.  Help!  Thanks!
ListBox
Terri-Lynn
Top achievements
Rank 1
 answered on 25 Nov 2011
5 answers
215 views
[Solved] Problem with Grid Header
I am having a problem with the header portion of the radgrid.

When the page is first displayed the right-hand portion of the header has been eliminated and replaced with white space.  Attached graphic "HeaderWidth1.png" shows this and also shows the Developer Tools display with the header segment highlighted.  You can see the width is set at "663px".

If I change the "663px" to "100%", the header will be displayed at full width (refer to attached graphic "HeaderWidth2.png").

I have tried coding a special css class for this item setting its width to 100% to no avail.

The code for the .aspx file is displayed immediately below.  Can anyone tell me why this issue is happening and how I can eliminate it?

Thanks in advance!

Lynn

<%@ 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;
    }
    .rgHeaderDiv
    {
        width: 100%;  
    }
</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" 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="99.7%"
                            AllowSorting="true" AllowFilteringByColumn="true" EnableLinqExpressions="false"
                            AllowPaging="false" PageSize="15"
                            BorderWidth="1px" BorderColor="#999999" EnableEmbeddedSkins="true" Skin="Default"
                            DataSourceID="SQLDataSource1"
                            ShowFooter="True" GridLines="None" >
                            <PagerStyle Mode="NextPrevAndNumeric" />
                            <GroupingSettings CaseSensitive="false" />
                            <MasterTableView AutoGenerateColumns="false" EditMode="InPlace" AllowFilteringByColumn="True"
                                ShowFooter="True" TableLayout="Auto">
                                <Columns>
 
                                    <telerik:GridBoundColumn FilterControlWidth="50px" HeaderText="First Name" UniqueName="FirstName" DataField="FirstName" SortExpression="FirstName" >
                                    </telerik:GridBoundColumn>
 
                                    <telerik:GridBoundColumn UniqueName="LastName" HeaderText="Last Name" DataField="LastName" SortExpression="LastName" >
                                    </telerik:GridBoundColumn>
 
                                    <telerik:GridBoundColumn UniqueName="VoterAddress" HeaderText="Address" DataField="Address" SortExpression="Address"  >
                                    </telerik:GridBoundColumn >
 
                                    <telerik:GridBoundColumn UniqueName="RemoveSignature" HeaderText="Remove" DataField="CountyId" SortExpression="CountyId" >
                                    </telerik:GridBoundColumn>
                                     
 
                                </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 colspan="5" align="center" >
                          
                    </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="Label12" Font-Size="16px" Width="100%" BackColor="#565A43" Height="24px" ForeColor="#ffffff" Font-Bold="true" runat="server" Text="<%$ Resources:Resource, SearchPetitionSignersLabel %>"></asp:Label>
                        </td>
                    <td>
                          
                    </td>
                </tr>
                <tr>
                    <td colspan="5" align="center" >
                          
                    </td>
                </tr>
                <tr>
                    <td colspan="5" align="center" >
                        <asp:Label ID="Label15" runat="server" Text="<%$ Resources:Resource, FirstLastNameLabel %>"></asp:Label>
                        <asp:TextBox ID="SearchFirstName" Width="80px" runat="server" TabIndex="1"></asp:TextBox>
                           
                        <asp:TextBox ID="SearchLastName" Width="80px" runat="server" TabIndex="2"></asp:TextBox>
                                       
                        <asp:Label ID="Label13" runat="server" Text="<%$ Resources:Resource, AddressLabel %>"></asp:Label>
                           
                        <asp:TextBox ID="SearchAddress" runat="server" TabIndex="3"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <td colspan="5" align="center" >
                        <asp:RadioButtonList ID="TypeOfCompare" runat="server" CellSpacing="10" RepeatDirection="Horizontal" >
                            <asp:ListItem Enabled="True" Selected="True" Text="Contains the value anywhere" Value="1" />
                            <asp:ListItem Enabled="True" Selected="False" Text="Only check the beginning of the entry" Value="2" />
                        </asp:RadioButtonList>
                         
                        <br />
                        <asp:Label ID="SearchInstructions" runat="server" Text="<%$ Resources:Resource, SearchInstructionsLabel %>"></asp:Label>
                    </td>
                </tr>
                <tr>
                    <td colspan="5" align="center" >
                          
                    </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="ClosePetitionButton" TabIndex="6" runat="server" Text="<%$ Resources:Resource, ClosePetitionBtn %>" />
                            
                        <asp:Button ID="PrintListButton" TabIndex="7" runat="server" Text="<%$ Resources:Resource, PrintListBtn %>" />
                            
                        <asp:Button ID="PrintForFilingButton" TabIndex="8" 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>



Grid
Pavlina
Telerik team
 answered on 25 Nov 2011
1 answer
210 views
Problem with Radgrid nestedview template
Hi,

    I am having a problem with RadGrid control. I am using radgrid with filter and sorting option. Now my grid is having 2 rows for a particular record (as shown in lookup2.png). In the starting when we come onto the page it looks like a general grid with filter option on the top. But when we select edit in dropdownlist present in action column. then that row comes down and another edit record row become visible with prepopuleted fields. now when i click on update, It updates the record in database and edit row becomes invisible.
I tried to solve this my using nestedviewtemplate example given in the forum but i did not get it. 
   So can u make a dummy application give it to me because this concept is the main concept of the project and nearly 80% grids of the project is based on this concept.
  So please resolve it asap.

With Regards
Grid
Tsvetina
Telerik team
 answered on 25 Nov 2011
5 answers
147 views
ContentArea background color
Ive read multiple threads on here about setting the background color of the editor but with no success.

As my page background is dark, text is unreadable so i want to make the background white.

Ive created a EditorContentArea.css file but not sure where i place this. Its currently in the web root but isnt being picked up.

do i need to set the path to this somewhere in an editor property or does the editor expect to load it from a certain location?

has anyone succeeded in doing this?

my only alternative is to try another editor if i can't find a solution to this


Editor
Rumen
Telerik team
 answered on 25 Nov 2011
1 answer
195 views
RadDatePicker with HtmlTextWriter
Hi,

Problem about : "RadDatePicker" 
I am trying to create a html table with "RadDatePicker" dynamically(in code behind) and tried to pass that HTML table as string to jquery.

Its working fine for ASP controls but whenever I tried to add "RadDatePicker" it is giving error.
My code -
[System.Web.Services.WebMethod]
        public static string  txtNoOfInstallment_OnTextChanged(int noOfInstallments)
        {          
            try
            {
                Table tab = new Table();
 
                for (int i = 1; i <= noOfInstallments; i++)
                {
                    TableRow tr = new TableRow();
                    TableCell td1 = new TableCell();
                    TableCell td2 = new TableCell();
                    TableCell td3 = new TableCell();
                    TableCell td4 = new TableCell();
 
                    Label lblAmt = new Label();
                    lblAmt.Text = "Installment" + " " + i;
 
                    TextBox txtAmount = new TextBox();
                    txtAmount.ID = "txtAmount" + i;
 
                    Label lblDate = new Label();
                    lblDate.Text = "Due date";
 
                    RadDatePicker dtPickerIstallmentDate = new RadDatePicker();
                    dtPickerIstallmentDate.ID = "dtPickerIstallmentDate" + i;
 
                    td1.Controls.Add(lblAmt);
                    td2.Controls.Add(txtAmount);
                    td3.Controls.Add(lblDate);
                    td4.Controls.Add(dtPickerIstallmentDate);
 
                    tr.Cells.Add(td1);
                    tr.Cells.Add(td2);
                    tr.Cells.Add(td3);
                    tr.Cells.Add(td4);
 
                    tab.Rows.Add(tr);
                }
                System.Text.StringBuilder sb = new System.Text.StringBuilder();
                System.IO.StringWriter tw = new System.IO.StringWriter(sb);
                HtmlTextWriter hw = new HtmlTextWriter(tw);
 
                tab.RenderControl(hw);
                return sb.ToString();
            }
            catch(Exception ex)
            {
                return ex.Message;
            }
        }

At " tab.RenderControl(hw);" this line it is throwing an following error-

{System.NullReferenceException: Object reference not set to an instance of an object.
   at Telerik.Web.UI.DatePickingInput.RenderBeginTag(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer)
   at Telerik.Web.UI.RadWebControl.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
   at Telerik.Web.UI.RadDatePicker.AddControlComponents(HtmlTextWriter writer)
   at Telerik.Web.UI.RadDatePicker.RenderChildren(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer)
   at Telerik.Web.UI.RadWebControl.RenderContents(HtmlTextWriter writer)
   at Telerik.Web.UI.RadDatePicker.RenderContents(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer)
   at Telerik.Web.UI.RadWebControl.Render(HtmlTextWriter writer)
   at Telerik.Web.UI.RadDatePicker.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
   at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
   at System.Web.UI.WebControls.TableCell.RenderContents(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)
   at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.RenderContents(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
   at System.Web.UI.WebControls.Table.RenderContents(HtmlTextWriter writer)
   at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer)
   at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)
   at System.Web.UI.Control.RenderControl(HtmlTextWriter writer)
   at pagename.txtNoOfInstallment_OnTextChanged1(Object sender, EventArgs e) in path/pagename.aspx.cs:line "tab.RenderControl(hw);"}

Is there any other way to get html text of RadControls?
Please guide me.

Regards,
Abhi
General Discussions
Antonio Stoilkov
Telerik team
 answered on 25 Nov 2011
2 answers
123 views
Hierarchical RadGrid Inside Dynamic RadDock
//Master Page Code Behind
 
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
 
public partial class MasterPage : System.Web.UI.MasterPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
 
    }
}
 
//Web Page Code Behind
 
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using Telerik.Web.UI;
 
public partial class HierarchyRadGrd : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
 
        }
 
        myHomeContent.Controls.Add(GetBandRadDock(2, 3, "Plan Details"));
         
 
        if (ScriptManager.GetCurrent(this).IsInAsyncPostBack)
        {
            string controlPath = string.Empty;
            string sourceid = "";
            try
            {
                if (ScriptManager.GetCurrent(this).AsyncPostBackSourceElementID.Contains("$"))
                    sourceid = ScriptManager.GetCurrent(this).AsyncPostBackSourceElementID.Split('$')[2];
                else
                    sourceid = ScriptManager.GetCurrent(this).AsyncPostBackSourceElementID.Split('_')[2];
                controlPath = "UserControlRadGrid.ascx";
                LoadUserControl(sourceid);
            }
            catch (IndexOutOfRangeException ExoutOf)
            {
            }
        }
 
 
    }
 
    protected void LoadUserControl(string _BandId)
    {
        string SourceString = "";
        string updateControl = "";
        if (ScriptManager.GetCurrent(this).AsyncPostBackSourceElementID.Contains("$"))
            SourceString = ScriptManager.GetCurrent(this).AsyncPostBackSourceElementID;   
        else
            SourceString = ScriptManager.GetCurrent(this).AsyncPostBackSourceElementID;
        string IdVal = SourceString;
        string ajpCtrl = "UpdatePanel3";
        string _sActualPath = SourceString;
        AddControl(_sActualPath, ajpCtrl, "UserControlRadGrid.ascx", _BandId);
    }
 
    protected void AddControl(string sourcedock, string ajaxp, string path, string _sBandId)
    {
        RadDock SourceDock = this.FindControl(sourcedock) as RadDock;
 
        UpdatePanel SourcePanel = (UpdatePanel)SourceDock.ContentContainer.FindControl(ajaxp);
 
        SourcePanel.ContentTemplateContainer.Controls.Clear();
        UserControl mycon = (UserControl)LoadControl(path);
        mycon.ID = "DC" + _sBandId;
 
        switch (_sBandId)
        {
 
            case "3":
                ((UserControlRadGrid)mycon)._ShowBand = false;
                break;
 
        }
 
        SourcePanel.ContentTemplateContainer.Controls.Add(mycon);
 
 
    }
 
    private RadDock GetBandRadDock(int Sequence, int _iBandId, string _sBandTitle)
    {
        RadDock _radDock = new RadDock();
        _radDock.CommandsAutoPostBack = true;
        _radDock.DockMode = DockMode.Docked;
        _radDock.DefaultCommands = Telerik.Web.UI.Dock.DefaultCommands.ExpandCollapse;
        _radDock.Command += new DockCommandEventHandler(_radDock_Command);
        _radDock.OnClientCommand = "OnDockExpand";
        _radDock.ForbiddenZones = new string[] { "DockZone" };
        _radDock.DockMode = DockMode.Default;
        _radDock.Collapsed = true;
        _radDock.ExpandText = "Loading...";
        _radDock.EnableAnimation = true;
        _radDock.Title = _sBandTitle;
        _radDock.Font.Bold = true;
        _radDock.ID = _iBandId.ToString();
        UpdatePanel uPanel = new UpdatePanel();
        uPanel.ID = "UpdatePanel" + _iBandId.ToString();
        uPanel.UpdateMode = UpdatePanelUpdateMode.Conditional;
        uPanel.RenderMode = UpdatePanelRenderMode.Inline;
        AsyncPostBackTrigger oTrigger = new AsyncPostBackTrigger();
        oTrigger.ControlID = _radDock.ID;
        uPanel.Triggers.Add(oTrigger);
        Label oLabel = new Label();
        oLabel.Text = "Loading....";
        oLabel.ID = "ldng";
        uPanel.ContentTemplateContainer.Controls.Add(oLabel);
        _radDock.ContentContainer.Controls.Add(uPanel);
        return _radDock;
 
    }
 
    void _radDock_Command(object sender, DockCommandEventArgs e)
    {
        Control _DynamicControl = new Control();
        RadDock oDock = new RadDock();
 
        oDock = sender as RadDock;
        oDock.AutoPostBack = false;
        oDock.CommandsAutoPostBack = false;
 
        UpdatePanel uPanel = new UpdatePanel();
        string uId = "UpdatePanel" + oDock.ID;
        uPanel = (UpdatePanel)oDock.ContentContainer.FindControl(uId);
        uPanel.ContentTemplateContainer.Controls.Clear();
        int _iBandId = Convert.ToInt32(oDock.ID);
 
        if (oDock.Collapsed)
        {
            Label oLabel = new Label();
            oLabel.Text = "Loading....";
            uPanel.Controls.Clear();
            uPanel.Controls.Add(oLabel);
        }
        else
        {
            switch (_iBandId)
            {               
                case 3:
 
                    _DynamicControl = LoadControl("UserControlRadGrid.ascx");
                    _DynamicControl.ID = "DC3";
                    _DynamicControl.GetType().GetProperty("ShowBand").SetValue(_DynamicControl, false, null);
                    break;              
            }
            uPanel.ContentTemplateContainer.Controls.Add(_DynamicControl);
        }
    }
 
 
 
    public void RaisePostBackEvent(string eventArgument) { }
}
 
//User Control Code Behind
 
 
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using Telerik.Web.UI;
 
public partial class UserControlRadGrid : System.Web.UI.UserControl
{
 
 
    private SqlConnection _con;
    private SqlDataAdapter _adp;
    private static DataTable _dt;
    public bool _ShowBand = true;
 
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            RadGrid1.DataSource = BindData();
            RadGrid1.DataBind();
        }
 
        RadGrid1.DataSource = BindData();
        RadGrid1.DataBind();
 
    }
 
    public DataTable BindData()
    {
        try
        {
            _con = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString);
            _adp = new SqlDataAdapter("SELECT * FROM Shop", _con);
            _dt = new DataTable();
            _adp.Fill(_dt);
        }
        catch (Exception e)
        {
            Response.Write(e.Message.ToString());
        }
        return _dt;
    }
 
    protected void RadGrid1_DetailTableDataBind(object source, GridDetailTableDataBindEventArgs e)
    {
 
        GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;
 
        switch (e.DetailTableView.Name)
        {
            case "Category":
                {
                    string _shopId = dataItem.GetDataKeyValue("ShopID").ToString();
                    e.DetailTableView.DataSource = GetNextLevelCategory(_shopId);
                    break;
                }
            case "Product":
                {
                    string _categoryID = dataItem.GetDataKeyValue("CategoryID").ToString();
                    e.DetailTableView.DataSource = GetNextLevelProduct(_categoryID);
                    break;
                }
        }
    }
 
    protected DataTable GetNextLevelCategory(string _shopId)
    {
        try
        {
            _con = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString);
            _adp = new SqlDataAdapter("SELECT * FROM Category WHERE ShopId=" + _shopId, _con);
            _dt = new DataTable();
            _adp.Fill(_dt);
        }
        catch (Exception e)
        {
            Response.Write(e.Message.ToString());
        }
        return _dt;
    }
 
    protected DataTable GetNextLevelProduct(string _categoryID)
    {
        try
        {
            _con = new SqlConnection(ConfigurationManager.ConnectionStrings["ShopConnectionString"].ConnectionString);
            _adp = new SqlDataAdapter("SELECT * FROM Products WHERE CategoryId=" + _categoryID, _con);
            _dt = new DataTable();
            _adp.Fill(_dt);
        }
        catch (Exception e)
        {
            Response.Write(e.Message.ToString());
        }
        return _dt;
    }
}





<!--Master Page-->
 
 
<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPage.master.cs" Inherits="MasterPage" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true" EnableScriptGlobalization="true"
    AsyncPostBackTimeout="600" ScriptMode="Release"/>       
    <div>
        <asp:contentplaceholder id="ContentPlaceHolder1" runat="server">
         
        </asp:contentplaceholder>
    </div>
    </form>
</body>
</html>
 
<!--Web Page-->
 
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="HierarchyRadGrd.aspx.cs" Inherits="HierarchyRadGrd" Title="Untitled Page" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<%@ Register Src="UserControlRadGrid.ascx" TagName="PlanDetailsUCSample" TagPrefix="control" %>
 
 
 
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 
 
<script type="text/javascript">
 
function OnDockExpand(sender,args)
{
        if(sender._collapsed == true)
        {
            args._cancel = true;
        }
        else
        {
            if(navigator.appName != "Netscape")
            {
                if(sender._contentContainer.childNodes[0].childNodes.length > 1)
                    args.set_cancel(true);  
            }
            else
            {
                if(sender._contentContainer.children[0].children.length > 1)
                   args.set_cancel(true);  
            }
        }
}
 
</script>
 
 
 
 
<telerik:RadDockLayout ID="dckLayout" runat="server">
    <telerik:RadDockZone ID="myHomeContent" runat="server" FitDocks="true" Font-Bold="true"
        BorderStyle="None" Orientation="Vertical">
    </telerik:RadDockZone>
</telerik:RadDockLayout>
    <center>
        <table cellpadding="0" cellspacing="0" width="97%">
            <tr>
                <td>
                    <control:plandetailsucsample id="PlanDetailsUCSample" runat="server" />
                </td>
            </tr>
        </table>
    </center>
    <br />
    <br />                            
</asp:Content>
 
<!--User Control-->
 
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="UserControlRadGrid.ascx.cs" Inherits="UserControlRadGrid" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
 
<%--<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="RadGrid1">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
            </UpdatedControls>
        </telerik:AjaxSetting>
    </AjaxSettings>
</telerik:RadAjaxManager>--%>
 
<telerik:RadGrid ID="RadGrid1" runat="server" Width="60%" AutoGenerateColumns="false"
    OnDetailTableDataBind="RadGrid1_DetailTableDataBind" RegisterWithScriptManager="true">
    <MasterTableView DataKeyNames="ShopID">
        <Columns>
            <telerik:GridBoundColumn HeaderText="ShopID" DataField="ShopID">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn HeaderText="ShopName" DataField="ShopName">
            </telerik:GridBoundColumn>
        </Columns>
        <DetailTables>
            <telerik:GridTableView DataKeyNames="CategoryID" Name="Category">
                <Columns>
                    <telerik:GridBoundColumn HeaderText="CategoryID" DataField="CategoryID">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn HeaderText="CategoryName" DataField="CategoryName">
                    </telerik:GridBoundColumn>
                </Columns>
                <DetailTables>
                    <telerik:GridTableView Name="Product">
                        <Columns>
                            <telerik:GridBoundColumn HeaderText="ProductID" DataField="ProductID">
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn HeaderText="ProductName" DataField="ProductName">
                            </telerik:GridBoundColumn>
                        </Columns>
                    </telerik:GridTableView>
                </DetailTables>
            </telerik:GridTableView>
        </DetailTables>
    </MasterTableView>
</telerik:RadGrid>

 Hi,


I am loading a Hierarchical RadGrid inside a dynamically created RadDock, and the RadGrid is inside a user control. So when the RadDock is expanded the usercontrol(with the RadGrid) is loaded. And on expanding the Hierarchical RadGrid the next level of items is not shown. This is because of ispostback property which is always true for the usercontrol. And so the RadGrid inside the usercontrol is creating problem. It is working fine for a plain grid without any levels, but i am in need of using a Hierarchical RadGrid. Would appreciate if any help is provided for this. I want to know is that scenario possible or not and the way for doing it if possible. Thank you. Attaching the code below. 
Grid
Thiyagu
Top achievements
Rank 1
 answered on 25 Nov 2011
1 answer
108 views
Export just expanded rows on hierarchical grid
Hello!
I want to know if there is a way i can export just the rows that are expanded ont the hierarchy grid, the other rows (which are not expanded) i don't want them to appear on the pdf, is this possible?

Thanks a lot in advance!
Grid
Daniel
Telerik team
 answered on 25 Nov 2011
1 answer
70 views
Sharepoint 2010 with RadChart issues
I am having issues trying to add a RadChart to a Sharepoint 2010 webpart control.

I found this telerik forum post and have followed the directions so far, but there is a bad link in this post and it seems that this is where I'm stuck. 

I am getting this error from the server:

Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the <configuration>\<system.web>\<httpModules> section in the application configuration.


Snippets from my web.config: 
    <httpHandlers>
      <add verb="*" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource, Telerik.Web.UI" />
      <add path="ChartImage.axd" verb="*" type="Telerik.Web.UI.ChartHttpHandler, Telerik.Web.UI" validate="false" />
    </httpHandlers>

    <httpModules>
      <add name="Session" type="System.Web.SessionState.SessionStateModule" />
    </httpModules>

    <SafeControls>
     ...
      <SafeControl Assembly="Telerik.Web.UI" Namespace="Telerik.Charting" TypeName="*" Safe="True" />
      <SafeControl Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TypeName="*" Safe="True" />
    </SafeControls>
    <pages enableSessionState="true" enableViewState="true" enableViewStateMac="true" validateRequest="false" pageParserFilterType="Microsoft.SharePoint.ApplicationRuntime.SPPageParserFilter, Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxxxxxxxxxxxxxxxxx" asyncTimeout="7"  enableEventValidation="true">

Snippets from my ascx webpart page:
<%@ Register Assembly="Telerik.Web.UI, Version=2010.3.1317.35, Culture=neutral, PublicKeyToken=xxxxxxxxxxxxxxxxxxxxxx"
    Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<%@ Register Assembly="Telerik.Web.UI, Version=2010.3.1317.35, Culture=neutral, PublicKeyToken=xxxxxxxxxxxxxxxxxxxxx"
    Namespace="Telerik.Charting" TagPrefix="telerik" %>
<telerik:RadChart ID="RadChart1" runat="server">
    <PlotArea>
        <XAxis MaxValue="5" MinValue="1" Step="1">
        </XAxis>
        <YAxis MaxValue="25" Step="5">
        </YAxis>
        <YAxis2 MaxValue="5" MinValue="1" Step="1">
        </YAxis2>
    </PlotArea>
    <Series>
        <telerik:ChartSeries Name="Series 1" Type="Pie">
            <Appearance LegendDisplayMode="ItemLabels">
            </Appearance>
            <Items>
                <telerik:ChartSeriesItem YValue="23" Name="jim">
                </telerik:ChartSeriesItem>
                <telerik:ChartSeriesItem YValue="24" Name="pie">
                </telerik:ChartSeriesItem>
                <telerik:ChartSeriesItem YValue="19" Name="chart">
                </telerik:ChartSeriesItem>
                <telerik:ChartSeriesItem YValue="50" Name="test">
                </telerik:ChartSeriesItem>
            </Items>
        </telerik:ChartSeries>
    </Series>
</telerik:RadChart>

Is there an updated link to AdvancedSessionState or can someone tell me if something is wrong in what I'm doing?
Chart (Obsolete)
Evgenia
Telerik team
 answered on 25 Nov 2011
4 answers
149 views
FocusControl() not working in IE7
Hi,

I have a DotNetNuke module with quite some controls being loaded dynamically. Each of the input controls has autopostback set. In practice, a user will tab to a next control.

In javascript, I put the ID of the newly focussed control in a hidden field.
Then autopostback occurs, and I use RadAjaxManager.FocusControl() to set the focus to the control in the hidden field.

This works just fine in FireFox and IE9, but doesn't work in IE7 (or IE9 with compatibility mode set to true).

Any ideas?

Thanks!
Stefan Kamphuis
Ajax
Stefan Kamphuis
Top achievements
Rank 2
 answered on 25 Nov 2011
3 answers
122 views
[Solved] Ajax updating controls when it is not supposed to
Hi there,

I have a timer that updates a grid on a condition. For example:

if (IsDifferentFilter())
{
         //Load logs method is called so the datagrid will be updated
         Thread logsThread = new Thread(new ThreadStart(LoadLogs));
         logsThread.Start();
         logsThread.Join();
}
//else the datagrid will NOT be updated

The issue here is that even though the datagrid is NOT updated, it still gets refreshed. When I say refeshed i mean its just the datagrid not the whole page.

The grid is ajaxisfied using:

<telerik:RadAjaxManagerProxy ID="radAjaxManagerProxyLogs" runat="server" >
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="tmrAutoFilter">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="dgLogs" />
            </UpdatedControls>
        </telerik:AjaxSetting>
        <telerik:AjaxSetting AjaxControlID="dgLogs">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="dgLogs" LoadingPanelID="ldgBar" />
            </UpdatedControls>
        </telerik:AjaxSetting>
    </AjaxSettings>
</telerik:RadAjaxManagerProxy>


Any help would be appreciated.

Thanks

K

Edited (Nov-21-2011): I realized the OnInit code is being triggered after each timer tick as well. That is not normal is it
Ajax
Mira
Telerik team
 answered on 25 Nov 2011
Narrow your results
Done
Selected tags
Tags
Grid
General Discussions
Editor
Scheduler
ComboBox
Ajax
Window
TreeView
Menu
Calendar
Chart (Obsolete)
TabStrip
Input
Dock
ToolTip
Upload (Obsolete)
AsyncUpload
WebParts for SharePoint
PanelBar
FileExplorer
Splitter
ListBox
Chart (HTML5)
Rotator
ListView
Button
ToolBar
TreeList
Sharepoint Integration
FormDecorator
Filter
Slider
ScriptManager and StyleSheetManager
UI for ASP.NET AJAX in ASP.NET MVC
AutoCompleteBox
PivotGrid
Installer and VS Extensions
Spell
Documentation and Tutorials
ImageEditor
Captcha
RibbonBar
DropDownList
OrgChart
Visual Style Builder
DropDownTree
Gantt
ColorPicker
Notification
BinaryImage
SkinManager
TileList
Wizard
SearchBox
Spreadsheet
Map
ImageGallery
Rating
DatePicker
MediaPlayer
XmlHttpPanel
Diagram
Compression
DataPager
SiteMap
CloudUpload
LightBox
Gauge
AjaxLoadingPanel
PageLayout
Navigation
SocialShare
DataForm
Persistence Framework
ClientExportManager
ProgressArea
AjaxPanel
CheckBox
TagCloud
NumericTextBox
Barcode
ClientDataSource
PdfViewer
DateTimePicker
MultiColumnComboBox
MultiSelect
RadioButtonList
MaskedTextBox
Theme Builder
Styling
ProgressBar
DateInput
Licensing
Chat
ODataDataSource
MonthYearPicker
TimePicker
Accessibility
LinkButton
ToggleButton
Label
Localization
Security
DateRangePicker
TreeMap
ImageButton
InputManager
Timeline
Card
Drawer
PushButton
Ticker
Signature
Avatar
Switch
OTPInput
Breadcrumb
SplitButton
DragDropManager
Stepper
FloatingActionButton
Chip
ChipList
AIPrompt
Badge
SpeechToText
SmartPasteButton
SegmentedControl
+? more
Top users last month
Jake
Top achievements
Rank 1
RBarnes
Top achievements
Rank 1
Iron
Iron
Rami
Top achievements
Rank 1
Iron
Veteran
Nathan
Top achievements
Rank 1
Kumeri
Top achievements
Rank 1
Iron
Veteran
Iron
Want to show your ninja superpower to fellow developers?
Learn how
4681 4682
4683
4684 4685
Top users last month
Jake
Top achievements
Rank 1
RBarnes
Top achievements
Rank 1
Iron
Iron
Rami
Top achievements
Rank 1
Iron
Veteran
Nathan
Top achievements
Rank 1
Kumeri
Top achievements
Rank 1
Iron
Veteran
Iron
Want to show your ninja superpower to fellow developers?
Learn how
Want to show your ninja superpower to fellow developers?
Learn how