Questions on UI for ASP.NET AJAX Forum

7 answers

102 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

211 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

160 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

125 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

139 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

239 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

151 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"

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

Input

answered on 02 Sep 2011

1 answer

88 views

[Solved] Get edited cell value in JS

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?

Grid

answered on 02 Sep 2011

1 answer

59 views

$find not working in IE7, IE8

Hi there,

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

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

dock is null.

Any ideas?

Dock

answered on 02 Sep 2011

2 answers

116 views

Problem with paging buttons > 10

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>

<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.

Grid

answered on 02 Sep 2011