Questions on UI for ASP.NET AJAX Forum

1 answer

91 views

RadGrid - Order of Parameters in DS Random

So I'm using the grid to manage a number of reference tables. Most just have the identity and a text field, one has several text fields. I'm doing it as generically as possible, with one grid and one SQLDataSource on the page, and 4 stored procs with generic parameters for insert, update, delete and select. I have corresponding params for each action defined declaratively in the datasource.

<SelectParameters>

<asp:Parameter Name="itemType" Type="String" />

</SelectParameters>

<InsertParameters>

<asp:Parameter Name="itemType" Type="String" />

<asp:Parameter Name="itemValue" Type="String" />

<asp:Parameter Name="itemValue2" Type="String" />

<asp:Parameter Name="itemValue3" Type="String" />

</InsertParameters>

<DeleteParameters>

<asp:Parameter Name="itemID" Type="Int32" />

<asp:Parameter Name="itemType" Type="String" />

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name="itemID" Type="Int32" />

<asp:Parameter Name="itemType" Type="String" />

<asp:Parameter Name="itemValue" Type="String" />

<asp:Parameter Name="itemValue2" Type="String" />

<asp:Parameter Name="itemValue3" Type="String" />

</UpdateParameters>

I'm handling the Updating, Selecting etc... events for the datasource, and set the value of the datasource params there before it runs each command.

protected void dsActivity_Deleting(object sender, SqlDataSourceCommandEventArgs e)

{

int paramcount = e.Command.Parameters.Count;

e.Command.Parameters["@itemID"].Value = e.Command.Parameters["@" + lstReference.Items[lstReference.SelectedIndex].Value + "ID"].Value.ToString();

e.Command.Parameters["@itemType"].Value = lstReference.Items[lstReference.SelectedIndex].Value;

while (e.Command.Parameters.Count > 2)

e.Command.Parameters.RemoveAt(e.Command.Parameters.Count - 1);

}

The problem I had to work around was that although the grid appends the field values to the params in the datasource events, the order of them is not consistent. So that makes it hard to handle them in a generic manner since I can't use the index to reference them, not knowing what param might be in a given position.

I've worked around this since I ran into it, but it would have been a lot cleaner if I could depend on the parameters to be added in the same order. This would be handy for certain scenarios like this if it would build that with the params in the corresponding order they were originally retrieved.

Grid

answered on 02 Sep 2011

2 answers

76 views

Cut and Paste

Hi,

I am having two radtreeview, i want to do cut and paste the items between the trees. I can do mulitple select. I search for the cut and paste in radtree view. Is it available ?. If not please tell me how can i perform that.

Regards,
Xavier

TreeView

answered on 02 Sep 2011

1 answer

110 views

RadGrid Export - RadCompression.Compress issue

Hi,

I have a radgrid with some smileys which had been inserted from radEditor.
Now when I export the grid to word, it exports it well but throws the below bug:

Error Info:Object reference not set to an instance of an object.
Error URL path:http://www.xtz.com/Smiley/haha.gif
Stack trace: at Telerik.Web.UI.RadCompression.Compress(HttpApplication application) at Telerik.Web.UI.RadCompression.PreRequestHandlerExecute(Object sender, EventArgs e) at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

The Smiley's path is correct, and I am able to see the image on loading the URL path.
But why I get the RadCompression bug?

Grid

answered on 02 Sep 2011

7 answers

97 views

Problem with hourly recurring appointment with reminders.

Hi,

We have created hourly recurring appointments with reminder, we are not getting the exact idea about how to dismiss the appointments?

For these types of appointments, it will fires following events when we press dismiss button,

ReminderDismiss
AppointmentUpdate
AppointmentInsert

can you give us some suggestion about what are the operations we require to perform in these events?

FYI. We have used “AdvancedInsertTemplate” and “AdvancedEditTemplate”.

Thanks

Scheduler

answered on 02 Sep 2011

3 answers

191 views

Rad button controls scroll issue

Hi ;
We have use Radbutton Control in our Project in all popup pages but when we scroll the pages up and down or using horizontal scroll bar Radbutton does not scroll with the pages . Can you let us know how to rectify this issue
please note: we have use Radbutton in asp update panel

General Discussions

answered on 02 Sep 2011

3 answers

153 views

Clearing existing filter expression

how to clear existing filter expression when i filter another column.

in 1st column i had applied filter then when i tried to filter 2nd column it should clear 1st column filter and need to apply 2nd column filter

how to clear that

Grid

answered on 02 Sep 2011

1 answer

113 views

Cannot find Design-time Chart Wizard

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?

Chart (Obsolete)

answered on 02 Sep 2011

4 answers

131 views

Grid / Master/Detail Grids

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 "ORDINI" WHERE "ID_ORDINE" = ? AND "ID_COMMESSA" = ?"
        InsertCommand="INSERT INTO "ORDINI" ("ID_ORDINE", "ID_COMMESSA", "ID_INDIRIZZO", "SIGLA", "DATA_ORD",
        "COGNOME", "NOME", "TERMINE", "DATA_RICEZ", "ORD_TELEF", "DATA_PFATT", "IMP_PFATT",
        "PAGAMENTO_TRAMITE", "TRAS_VAL", "SUPP_VAL", "TOTALE_ORDINE", "SCONTO", "IVA_COMPRESA",
        "STATO", "BOLLETINO", "DATA_FATT", "ENTRATAM", "OSSERVAZIONI", "ID_RNC", "FATTURA_TERZI",
        "FATTURA", "RESPONSABILE", "ID_IND_FATTURAZIONE", "TOTALE_ORDINE_IVA")
        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
        ProviderName="<%$ ConnectionStrings:ConnessioneOfficine.ProviderName %>"
        SelectCommand="SELECT "ID_ORDINE", "ID_COMMESSA", "ID_INDIRIZZO", "SIGLA", "DATA_ORD", "COGNOME",
        "NOME", "TERMINE", "DATA_RICEZ", "ORD_TELEF", "DATA_PFATT", "IMP_PFATT", "PAGAMENTO_TRAMITE",
        "TRAS_VAL", "SUPP_VAL", "TOTALE_ORDINE", "SCONTO", "IVA_COMPRESA", "STATO", "BOLLETINO", "DATA_FATT", "ENTRATAM", "OSSERVAZIONI", "ID_RNC", "FATTURA_TERZI", "FATTURA", "RESPONSABILE", "ID_IND_FATTURAZIONE", "TOTALE_ORDINE_IVA" FROM "ORDINI""
        UpdateCommand="UPDATE "ORDINI" SET "ID_INDIRIZZO" = ?, "SIGLA" = ?, "DATA_ORD" = ?, "COGNOME" = ?,
        "NOME" = ?, "TERMINE" = ?, "DATA_RICEZ" = ?, "ORD_TELEF" = ?, "DATA_PFATT" = ?, "IMP_PFATT" = ?,
        "PAGAMENTO_TRAMITE" = ?, "TRAS_VAL" = ?, "SUPP_VAL" = ?, "TOTALE_ORDINE" = ?, "SCONTO" = ?,
        "IVA_COMPRESA" = ?, "STATO" = ?, "BOLLETINO" = ?, "DATA_FATT" = ?, "ENTRATAM" = ?, "OSSERVAZIONI" = ?,
        "ID_RNC" = ?, "FATTURA_TERZI" = ?, "FATTURA" = ?, "RESPONSABILE" = ?, "ID_IND_FATTURAZIONE" = ?,
        "TOTALE_ORDINE_IVA" = ? WHERE "ID_ORDINE" = ? AND "ID_COMMESSA" = ?">
        <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!!

Grid

answered on 02 Sep 2011

3 answers

230 views

[Solved] How do I connect the textbox with data from DB

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

ListView

answered on 02 Sep 2011

1 answer

140 views

Beginner - RadInputManager

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"