Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
93 views
I'm running 2011.2.712.40 on Visual Studio 2010 SP1 in a .NET 4 Application and I cannot find the Chart Wizard for the life of me, at least the one pictured on this page: http://www.telerik.com/products/aspnet-ajax/chart.aspx

Technically it's a "web application" but I haven't (and don't want to) convert it to a web application.

I've tried going to Telerik in the menu bar > RadControls for ASP.NET > More Scenarios and nothing's there. In the Toolbox, I go to the "Telerik AJAX Visualization Components 2011 Q2 NET 40" section and right click on "RadChart" but there isn't a "Properties" or anything else that would take me there. If I drag it to a .aspx file, it just adds the two lines of code.

I do have Reporting Q2 2011 installed on my machine, but the wizard that's in there doesn't look like what's on the page...

Do note, though, that the project is up-to-date and running many other Telerik features.

Any ideas?
Yavor
Telerik team
 answered on 02 Sep 2011
4 answers
120 views
Hello everyone,
I apologize now for my English!
I have a problem for connecting two RadGrid, the first concerns orders the second the details of the orders.
The error is as follows:

and the code is this:
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Ordini1.aspx.cs" Inherits="Ordini_Ordini1" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

    <telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadGrid1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                    <telerik:AjaxUpdatedControl ControlID="RadGrid2" />
                </UpdatedControls>
            </telerik:AjaxSetting>
            <telerik:AjaxSetting AjaxControlID="RadGrid2">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid2" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManagerProxy>

    <br />

    <telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True"
        Width="95%" CellSpacing="0" DataSourceID="SqlDataSource1" GridLines="None"
        Skin="Outlook" PageSize="5" OnItemCommand="RadGrid1_ItemCommand"
        AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True"
        style="z-index: 1; left: 13px; top: 135px; position: absolute; height: 8px; width: 1296px">
                    <ClientSettings AllowKeyboardNavigation="true" EnablePostBackOnRowClick="true">
                        <Selecting AllowRowSelect="true" />
                    </ClientSettings>
            <MasterTableView  DataKeyNames="id_ordine" DataSourceID="SqlDataSource1">
            
            </MasterTableView>

           <PagerStyle Mode="NextPrevAndNumeric" />
    </telerik:RadGrid>

    <%--I did not write everything because it is a test --%>
    <telerik:RadGrid ID="RadGrid2" runat="server" AllowPaging="True"
        ShowStatusBar="True" PageSize="5"
                    CellSpacing="0" DataSourceID="SqlDataSource2" GridLines="None"
        Skin="Outlook" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True"
        style="z-index: 1; left: 5px; top: 527px; position: absolute; height: 20px; width: 1296px">
            <MasterTableView DataSourceID="SqlDataSource2" DataKeyNames="id_ordine">
           <Columns>
                <telerik:GridBoundColumn DataField="id_ordine" DataType="System.Decimal" HeaderText="id_ordine"
                    ReadOnly="True" SortExpression="id_ordine" UniqueName="id_ordine">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="QTA_COM" DataType="System.DateTime" HeaderText="QTA_COM"
                    SortExpression="QTA_COM" UniqueName="QTA_COM" DataFormatString="{0:d}">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="GRORD" HeaderText="GRORD" SortExpression="GRORD"
                    UniqueName="GRORD">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="DESCR_RORD" HeaderText="DESCR_RORD" SortExpression="DESCR_RORD"
                    UniqueName="DESCR_RORD">
                </telerik:GridBoundColumn><telerik:GridBoundColumn DataField="MATERIALE" HeaderText="MATERIALE" SortExpression="MATERIALE"
                    UniqueName="MATERIALE">
                </telerik:GridBoundColumn><telerik:GridBoundColumn DataField="LARGH" HeaderText="LARGH" SortExpression="LARGH"
                    UniqueName="LARGH">
                </telerik:GridBoundColumn>
            </Columns>
            </MasterTableView>

            <ClientSettings AllowKeyboardNavigation="true" EnablePostBackOnRowClick="true">
                <Selecting AllowRowSelect="true" />
            </ClientSettings>

            <FilterMenu EnableImageSprites="False"></FilterMenu>

            <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>

            <PagerStyle Mode="NextPrevAndNumeric" />
    </telerik:RadGrid>


    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:ConnessioneOfficine %>"
        DeleteCommand="DELETE FROM &quot;ORDINI&quot; WHERE &quot;ID_ORDINE&quot; = ? AND &quot;ID_COMMESSA&quot; = ?"
        InsertCommand="INSERT INTO &quot;ORDINI&quot; (&quot;ID_ORDINE&quot;, &quot;ID_COMMESSA&quot;, &quot;ID_INDIRIZZO&quot;, &quot;SIGLA&quot;, &quot;DATA_ORD&quot;,
        &quot;COGNOME&quot;, &quot;NOME&quot;, &quot;TERMINE&quot;, &quot;DATA_RICEZ&quot;, &quot;ORD_TELEF&quot;, &quot;DATA_PFATT&quot;, &quot;IMP_PFATT&quot;,
        &quot;PAGAMENTO_TRAMITE&quot;, &quot;TRAS_VAL&quot;, &quot;SUPP_VAL&quot;, &quot;TOTALE_ORDINE&quot;, &quot;SCONTO&quot;, &quot;IVA_COMPRESA&quot;,
        &quot;STATO&quot;, &quot;BOLLETINO&quot;, &quot;DATA_FATT&quot;, &quot;ENTRATAM&quot;, &quot;OSSERVAZIONI&quot;, &quot;ID_RNC&quot;, &quot;FATTURA_TERZI&quot;,
        &quot;FATTURA&quot;, &quot;RESPONSABILE&quot;, &quot;ID_IND_FATTURAZIONE&quot;, &quot;TOTALE_ORDINE_IVA&quot;)
        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
        ProviderName="<%$ ConnectionStrings:ConnessioneOfficine.ProviderName %>"
        SelectCommand="SELECT &quot;ID_ORDINE&quot;, &quot;ID_COMMESSA&quot;, &quot;ID_INDIRIZZO&quot;, &quot;SIGLA&quot;, &quot;DATA_ORD&quot;, &quot;COGNOME&quot;,
        &quot;NOME&quot;, &quot;TERMINE&quot;, &quot;DATA_RICEZ&quot;, &quot;ORD_TELEF&quot;, &quot;DATA_PFATT&quot;, &quot;IMP_PFATT&quot;, &quot;PAGAMENTO_TRAMITE&quot;,
        &quot;TRAS_VAL&quot;, &quot;SUPP_VAL&quot;, &quot;TOTALE_ORDINE&quot;, &quot;SCONTO&quot;, &quot;IVA_COMPRESA&quot;, &quot;STATO&quot;, &quot;BOLLETINO&quot;, &quot;DATA_FATT&quot;, &quot;ENTRATAM&quot;, &quot;OSSERVAZIONI&quot;, &quot;ID_RNC&quot;, &quot;FATTURA_TERZI&quot;, &quot;FATTURA&quot;, &quot;RESPONSABILE&quot;, &quot;ID_IND_FATTURAZIONE&quot;, &quot;TOTALE_ORDINE_IVA&quot; FROM &quot;ORDINI&quot;"
        UpdateCommand="UPDATE &quot;ORDINI&quot; SET &quot;ID_INDIRIZZO&quot; = ?, &quot;SIGLA&quot; = ?, &quot;DATA_ORD&quot; = ?, &quot;COGNOME&quot; = ?,
        &quot;NOME&quot; = ?, &quot;TERMINE&quot; = ?, &quot;DATA_RICEZ&quot; = ?, &quot;ORD_TELEF&quot; = ?, &quot;DATA_PFATT&quot; = ?, &quot;IMP_PFATT&quot; = ?,
        &quot;PAGAMENTO_TRAMITE&quot; = ?, &quot;TRAS_VAL&quot; = ?, &quot;SUPP_VAL&quot; = ?, &quot;TOTALE_ORDINE&quot; = ?, &quot;SCONTO&quot; = ?,
        &quot;IVA_COMPRESA&quot; = ?, &quot;STATO&quot; = ?, &quot;BOLLETINO&quot; = ?, &quot;DATA_FATT&quot; = ?, &quot;ENTRATAM&quot; = ?, &quot;OSSERVAZIONI&quot; = ?,
        &quot;ID_RNC&quot; = ?, &quot;FATTURA_TERZI&quot; = ?, &quot;FATTURA&quot; = ?, &quot;RESPONSABILE&quot; = ?, &quot;ID_IND_FATTURAZIONE&quot; = ?,
        &quot;TOTALE_ORDINE_IVA&quot; = ? WHERE &quot;ID_ORDINE&quot; = ? AND &quot;ID_COMMESSA&quot; = ?">
        <DeleteParameters>
            <asp:Parameter Name="ID_ORDINE" Type="Decimal" />
            <asp:Parameter Name="ID_COMMESSA" Type="Decimal" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="ID_ORDINE" Type="Decimal" />
            <asp:Parameter Name="ID_COMMESSA" Type="Decimal" />
            <asp:Parameter Name="ID_INDIRIZZO" Type="Decimal" />
            <asp:Parameter Name="SIGLA" Type="String" />
            <asp:Parameter Name="DATA_ORD" Type="DateTime" />
            <asp:Parameter Name="COGNOME" Type="String" />
            <asp:Parameter Name="NOME" Type="String" />
            <asp:Parameter Name="TERMINE" Type="DateTime" />
            <asp:Parameter Name="DATA_RICEZ" Type="DateTime" />
            <asp:Parameter Name="ORD_TELEF" Type="String" />
            <asp:Parameter Name="DATA_PFATT" Type="DateTime" />
            <asp:Parameter Name="IMP_PFATT" Type="Decimal" />
            <asp:Parameter Name="PAGAMENTO_TRAMITE" Type="String" />
            <asp:Parameter Name="TRAS_VAL" Type="Decimal" />
            <asp:Parameter Name="SUPP_VAL" Type="Decimal" />
            <asp:Parameter Name="TOTALE_ORDINE" Type="Decimal" />
            <asp:Parameter Name="SCONTO" Type="Decimal" />
            <asp:Parameter Name="IVA_COMPRESA" Type="String" />
            <asp:Parameter Name="STATO" Type="String" />
            <asp:Parameter Name="BOLLETINO" Type="String" />
            <asp:Parameter Name="DATA_FATT" Type="DateTime" />
            <asp:Parameter Name="ENTRATAM" Type="String" />
            <asp:Parameter Name="OSSERVAZIONI" Type="String" />
            <asp:Parameter Name="ID_RNC" Type="Decimal" />
            <asp:Parameter Name="FATTURA_TERZI" Type="String" />
            <asp:Parameter Name="FATTURA" Type="String" />
            <asp:Parameter Name="RESPONSABILE" Type="String" />
            <asp:Parameter Name="ID_IND_FATTURAZIONE" Type="Decimal" />
            <asp:Parameter Name="TOTALE_ORDINE_IVA" Type="Decimal" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="ID_INDIRIZZO" Type="Decimal" />
            <asp:Parameter Name="SIGLA" Type="String" />
            <asp:Parameter Name="DATA_ORD" Type="DateTime" />
            <asp:Parameter Name="COGNOME" Type="String" />
            <asp:Parameter Name="NOME" Type="String" />
            <asp:Parameter Name="TERMINE" Type="DateTime" />
            <asp:Parameter Name="DATA_RICEZ" Type="DateTime" />
            <asp:Parameter Name="ORD_TELEF" Type="String" />
            <asp:Parameter Name="DATA_PFATT" Type="DateTime" />
            <asp:Parameter Name="IMP_PFATT" Type="Decimal" />
            <asp:Parameter Name="PAGAMENTO_TRAMITE" Type="String" />
            <asp:Parameter Name="TRAS_VAL" Type="Decimal" />
            <asp:Parameter Name="SUPP_VAL" Type="Decimal" />
            <asp:Parameter Name="TOTALE_ORDINE" Type="Decimal" />
            <asp:Parameter Name="SCONTO" Type="Decimal" />
            <asp:Parameter Name="IVA_COMPRESA" Type="String" />
            <asp:Parameter Name="STATO" Type="String" />
            <asp:Parameter Name="BOLLETINO" Type="String" />
            <asp:Parameter Name="DATA_FATT" Type="DateTime" />
            <asp:Parameter Name="ENTRATAM" Type="String" />
            <asp:Parameter Name="OSSERVAZIONI" Type="String" />
            <asp:Parameter Name="ID_RNC" Type="Decimal" />
            <asp:Parameter Name="FATTURA_TERZI" Type="String" />
            <asp:Parameter Name="FATTURA" Type="String" />
            <asp:Parameter Name="RESPONSABILE" Type="String" />
            <asp:Parameter Name="ID_IND_FATTURAZIONE" Type="Decimal" />
            <asp:Parameter Name="TOTALE_ORDINE_IVA" Type="Decimal" />
            <asp:Parameter Name="ID_ORDINE" Type="Decimal" />
            <asp:Parameter Name="ID_COMMESSA" Type="Decimal" />
        </UpdateParameters>
    </asp:SqlDataSource>

    <asp:SqlDataSource ID="SqlDataSource2" runat="server"
        ConnectionString="<%$ ConnectionStrings:ConnessioneOfficine %>"
        ProviderName="<%$ ConnectionStrings:ConnessioneOfficine.ProviderName %>"
        SelectCommand="SELECT [ID_ORDINE], [QTA_COM], [GRORD], [DESCR_RORD], [MATERIALE], [LARGH], [TRATTAMENTO], [ALTEZZA], [SPESSORE], [LUNGH], [KG_UTA], [FR_UTA], [QTA_PREZZO], [UTA_PREZZO],
        [SCONTO], [PREZZO_TOT], [OSSERVAZ], [STATO], [QTA_OK1], [NO_INV], [QTA_RESA], [MAGAZZINO], [QTA_PARZIALE], [DATA_RICEZIONE], [TASSO_IVA], [POSIZIONE_CAPITOLATO], [ID_COMMESSA], [ROWID]
        FROM [RORDINI] WHERE ([ID_ORDINE] = TO_NUMBER('@id_ordine'))">
        <SelectParameters>
            <asp:ControlParameter ControlID="RadGrid1"  Name="id_ordine" PropertyName="SelectedValue" Type="Decimal" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>

Thanks for the help!!
clo
Top achievements
Rank 1
 answered on 02 Sep 2011
3 answers
192 views
My problem is how do I connect  the TextBox within the RadListView whit the connection that I created so that they could display data from the table. I know that I use ... but then I do not know how ... someone can help me? I attach the key file with one of my experiments!

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.Adapters;
using Oracle.DataAccess.Client;
using Telerik.OpenAccess.Config.Sql;
using System.Data;
using Telerik.Web.UI;

namespace WebApplication1
{
    //ccc i due pezzi commentati in questo caso non servono



    public partial class WebForm1 : System.Web.UI.Page
    {
        private OracleConnection conn = new OracleConnection(); //ccc creo una nuova istanza OracleConnection
        private OracleCommand cmd;  //ccc creo una nuova istanza OracleCommand
        private OracleDataReader dr;
        private OracleDataAdapter da;
        private OracleCommandBuilder cb;
        private DataSet ds;

        string sql = " select tasso_iva, max(data_inizio), data_fine from tassi_iva";   //dichiaro una variabile e le associo la query
        //+ "where data_inizio = to_date('01.01.01', 'DD.MM.YY')";

        
        protected void Page_Load(object sender, EventArgs e)
        {
            string ConnString = "data source=OG_DB2;password=ghid101;user id=OG_GHIDONI";

            conn.ConnectionString = ConnString; //ccc associo la connection string con un connection object

            

            try
            {
                conn.Open();    //ccc apro la connessione                                   

                
                OracleCommand cmd = new OracleCommand(sql, conn); // ccc creo un oggetto di tipo Oracle Command

                cmd.CommandType = CommandType.Text;

                /*da = new OracleDataAdapter(cmd);
                cb = new OracleCommandBuilder(da);
                ds = new DataSet();

                da.Fill(ds);*/

                //RgIva.DataSource = ds.Tables[0];

                OracleDataReader dr = cmd.ExecuteReader();  // ccc creo un oggetto ORacleDataReader e gli associo il metodo ripreso dalla
                                                            //ccc classe OracleCommand

                while (dr.Read())
                {

                    /*tb_iva.Text = dr["tasso_iva"].ToString();
                    rdp_inizio.SelectedDate = Convert.ToDateTime(dr["data_inizio"]);
                    rdp_fine.SelectedDate = Convert.ToDateTime(dr["data_fine"]);*/
                }


            }

            catch (Exception ex) // ccc catches any error
            {
                MessageBox.Show(ex.Message.ToString());
            }

            conn.Close();
        }

        protected void RadListView1_ItemCreated(object sender, RadListViewItemEventArgs e)
        {

            if (e.Item is RadListViewDataItem)
            {
                TextBox tb_iva = e.Item.FindControl("TbIVA") as TextBox;
                RadDatePicker rdp_inizio = e.Item.FindControl("RdpInizio") as RadDatePicker;
                RadDatePicker rdp_fine = e.Item.FindControl("RdpFine") as RadDatePicker;

                tb_iva.Text = dr["tasso_iva"].ToString();
                rdp_inizio.SelectedDate = Convert.ToDateTime(dr["data_inizio"]);
                rdp_fine.SelectedDate = Convert.ToDateTime(dr["data_fine"]);

            }
        }

        private OracleDataReader ReadRecords(string query)
        {
            conn.Open();    //ccc apro la connessione                                   

            OracleCommand cmd = new OracleCommand(sql, conn); // ccc creo un oggetto di tipo Oracle Command

            cmd.CommandType = CommandType.Text;

            OracleDataReader dr = cmd.ExecuteReader();

            return dr;
        }

        protected void RadListView1_NeedDataSource(object source, Telerik.Web.UI.RadListViewNeedDataSourceEventArgs e)
        {
            RadListView1.DataSource = ReadRecords(sql);
        }

        protected void RadListView1_DataBound(object sender, System.EventArgs e)
        {
            dr.Close();
        }

    }
}
Thanks a lot
Clo
clo
Top achievements
Rank 1
 answered on 02 Sep 2011
1 answer
115 views
Hi,

This is the first time that i used Telerik Rad Controls, so i'm quite confused with some features.

What i want to do is :
I have 3 asp:TextBox, let's say, tbUserName, tbPostalCode and tbEmail.

And i would like to do a validation through 2 web services :
CheckUserNameExist(string email, string userName) and CheckUserRight(string email, string postalCode, string userName)

Actually i want to do it onBlur event, and call the web service only if the textboxes have values. I mean if the user enter email and username, it will call the first web service and if the user enter all the values in textboxes, then it will call the second web service.

I'm quite confuse on how i can achieve it ?

How can i pass the required parameters (email, username and postalcode) to my web service ? Must i do it through javascript ?

I'm thinking about this code.

<telerik:RadInputManager ID="radManager" runat="server">
        <telerik:TextBoxSetting Validation-IsRequired="true" Validation-Location="UserService.asmx"
            Validation-Method="CheckUserNameExist" Validation-ValidateOnEvent="Blur"
            BehaviorID="tbBehavior1"
        >
            <TargetControls>
                <telerik:TargetInput ControlID="tbEmail" />
                <telerik:TargetInput ControlID="tbUserName" />               
            </TargetControls>
        </telerik:TextBoxSetting>
       <telerik:TextBoxSetting Validation-IsRequired="true" Validation-Location="UserService.asmx"
            Validation-Method="CheckUserRight" Validation-ValidateOnEvent="Blur"
            BehaviorID="tbBehavior2"
        >
            <TargetControls>
                <telerik:TargetInput ControlID="tbEmail" />
                <telerik:TargetInput ControlID="tbUserName" />               
                <telerik:TargetInput ControlID="tbPostalCode" />               
            </TargetControls>
        </telerik:TextBoxSetting>
    </telerik:RadInputManager>
 
<asp:TextBox ID="tbEmail" runat="server"></asp:TextBox>
<asp:TextBox ID="tbUserName" runat="server"></asp:TextBox>
<asp:TextBox ID="tbPostalCode" runat="server"></asp:TextBox>

Thanks in advance, i hope you can help me out with this.

Regards,
Al
Vasil
Telerik team
 answered on 02 Sep 2011
1 answer
76 views
Hello,

In my RadGrid all my items are always in edit mode; I use gridtemplatecolumn with radtextbox for editing. I want to get values of whole columns and sum it up, to show user new sum of the column in label outside radgrid, after any cell is changed - i use onblur function. I ve tried to use dataItem.getDataKeyValue("column_name") but it returns original values, not the ones after edit. Any suggestions on how can i do it in javascript?
Marin
Telerik team
 answered on 02 Sep 2011
1 answer
48 views
Hi there,

This does not work in IE7, IE8, but does in Firefox.

var dock = $find("<%= RadDock1.ClientID %>");

dock is null.

Any ideas?
Princy
Top achievements
Rank 2
 answered on 02 Sep 2011
2 answers
102 views
Hi,

I'm having a problem with the paging buttons. The initial buttons 1-10 works just fine, but when I go to "..." (landing at 11), all the buttons will update their text, but will still be bound to the same events as their previous button IDs had, meaning that if I press 17, I end up back on back 8.

I've searched your forums for similar issues and found http://www.telerik.com/community/forums/aspnet-ajax/grid/355586-radgrid-paging-problem.aspx however this did not help me on the way to a solution.

In order to do some error searching, I've dumbed down an example as much as possible, leaving me with :

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="SimpleView.ascx.cs" Inherits="AccessToWeb.Web.SimpleView" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
 
<telerik:RadScriptManager ID="RadScriptManager" runat="server"></telerik:RadScriptManager>
<!-- content start -->
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="RadGrid1">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
            </UpdatedControls>
        </telerik:AjaxSetting>
    </AjaxSettings>
</telerik:RadAjaxManager>
<div style="padding-left:20px;">
    <telerik:RadGrid ID="RadGrid1" AllowPaging="True" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource" GridLines="None" EnableViewState="true">
      <MasterTableView EnableViewState="true" />
      <PagerStyle Mode="NumericPages" />
    </telerik:RadGrid>
</div>

And codebehind:

namespace AccessToWeb.Web
{
    public partial class SimpleView : System.Web.UI.UserControl
    {
        private string _con, _query;
 
        protected void Page_Load(object sender, EventArgs e)
        {
            _con = Sitecore.Context.Item["Connectionstring"];
            _query = Sitecore.Context.Item["Select statement"];
 
            if (string.IsNullOrEmpty(_con) || string.IsNullOrEmpty(_query))
            {
                this.Visible = false;
                return;
            }
        }
 
        public DataTable GetDataTable(string query)
        {
            SqlConnection conn = new SqlConnection(_con);
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = new SqlCommand(query, conn);
 
            DataTable myDataTable = new DataTable();
 
            conn.Open();
            try
            {
                adapter.Fill(myDataTable);
            }
            finally
            {
                conn.Close();
            }
 
            return myDataTable;
        }
 
        protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
        {
            RadGrid1.DataSource = GetDataTable(_query);
        }
    }
}


If I instead of NumericPages use NextPrevAndNumeric, the same problem exists, but the Next button will always point at page 2, no matter which page I am on.
Marin
Telerik team
 answered on 02 Sep 2011
1 answer
307 views
Hi,

   Iam using treeview when we click the node in the treeview based on the node value it will display the data in the radgrid. In the below code we are using list to bind the data.In the list we are getting the data but when we bind it is not displaying any data.Can you please do the needful.

 List<LegacyResource> result = null;

protected void rdCategory_NodeClick(object sender, RadTreeNodeEventArgs e)
    {
        try
        {

            if (e.Node != null)
            {
                

                if (int.TryParse(e.Node.Value, out ResourceID))
                {
                    result = LegacyResourceAgent.GetResourceLinks(LinkResourceData, ResourceID);
                    //result.
                    if (result != null)                   
                   this.ManageTootipsGrid.Rebind();
                }
                else
                {
                    this.ManageTootipsGrid.DataSource = result;
                    this.ManageTootipsGrid.DataBind();
                }

            }
        }
        catch (Exception ex)
        {

        }

    }


 protected void manageTooltips_onNeedDataSource(object source, GridNeedDataSourceEventArgs e)
    {
        //refresh data for grid (needed when user performs update, sort, etc...
        this.ManageTootipsGrid.DataSource = result;

    }
Jayesh Goyani
Top achievements
Rank 2
 answered on 02 Sep 2011
8 answers
290 views
Hello.

I am trying to sort a RadGrid by GridHyperLinkColumn . I enabled the sorting and created sorting expression.

I want to make the header clickable in order to change it from ascending/descending  order .
however I cant make the header of the GridHyperLinkColumn clickable  . Can somebody offer me a solution? It does work on theGridBoundColumn  when I enable sorting .

Also after sorting ,the style of the header is changed  . Is there any way to stop it ?

Thank you

Joe 

Joseph
Top achievements
Rank 1
 answered on 02 Sep 2011
1 answer
99 views
When i minimize my window in a tabstrip like your demo and I click on tab to show window like this, The content of my window is reloaded and i lost all my change before minimize. If i look in source of my page, i see change i've made but restore cause a reload. Why ?

 

 

function ShowWindow(win) {

 

 

 

 

if (!win.isVisible()) {

 

 

win.show();

 

win.restore();

 

 

 

//if the window was maximized before client minimizes it, we need to restore

 

 

 

//its maximized state

 

 

 

if (win._Maximized) {

 

 

win.maximize();

 

win._Maximized =

 

null;

 

 

}

 

}

 

 

 

//ensure that the currently active RadWindow will have the highest z-Index.

 

 

 

var popupElem = win.get_popupElement();

 

 

 

 

var oldZindex = parseInt(popupElem.style.zIndex);

 

 

 

 

var styleZIndex = win.get_stylezindex();

 

 

 

 

var newZIndex = (styleZIndex) ? styleZIndex : Telerik.Web.UI.RadWindowUtils.get_newZindex(oldZindex);

 

 

popupElem.style.zIndex =

 

"" + newZIndex;

 

 

win.setActive(

 

true);

 

 

}

Collin
Top achievements
Rank 1
 answered on 01 Sep 2011
Narrow your results
Selected tags
Tags
+? more
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?