Hi,

This is probably a simple one, but when I use the auto generate to retrieve records from a table, I get all my fields, including an image displayed for an image field when I click the "test query" button.

When I look at the grid however, the image field is missing. How can I add a column to bind to and display the image field from the SQL table?

thx in advance

Hy,

I'm currently working on a webproject for one of our clients and I'm experiencing a strange problem with paging on the RadGrid. Hope someone will be able to help me.

I'm using a RadGrid to show some DB related data wich I have put into a DataTable before filling the RadGrid. When I fill the RadGrid I see the exact amount of rows and I see a certain number of pages at the bottom of my grid. When I click on the next page arrow, I can actually go to the page 2, so far so good. But when I click the next page again (to go to page 3 in this case), nothing happens.
I can navigate between page 1 and 2 without a problem, but I can't get any further.

For your Info I downloaded and installed the latest release and modified my Web.config to use the latest version.

You can find my code below. Fyi, this is the code of the usercontrol that contains the RadGrid. I have no Scriptmanager on the control, since I need to be able to add multiple custom controls to one page, so I added the Scriptmanager to the page. So I do infact have a Scriptmanager present.

Control
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="ARTravelList.ascx.cs" Inherits="Website.Controls.ARTravelList" %>

<telerik:RadAjaxManager ID="ajaxManager" runat="server">
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="grdTravels">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="grdTravels" />
            </UpdatedControls>
        </telerik:AjaxSetting>
    </AjaxSettings>
</telerik:RadAjaxManager>

<div id="pageColorHeader">
    <div class="colorHeaderText">REISOVERZICHT GROEPEN</div>
    <div id="colorHeaderSub">NIEUW</div>
</div>

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server">

<telerik:RadGrid ID="grdTravels" runat="server" OnItemDataBound="grdTravel_ItemDataBound" OnItemCommand="grdTravel_ItemCommand" AutoGenerateColumns="false" AllowAutomaticDeletes="false" AllowAutomaticInserts="false" AllowAutomaticUpdates="false" AllowMultiRowEdit ="false" AllowMultiRowSelection="false" Skin="Hay" AllowPaging="true" AllowSorting="true" OnNeedDataSource="grdTravel_NeedDataSource" PageSize="50">


<MasterTableView DataKeyNames="Id" NoMasterRecordsText="Er zijn geen reizen gevonden van dit type">
       
        <ExpandCollapseColumn Visible="False">
            <HeaderStyle Width="19px"></HeaderStyle>
        </ExpandCollapseColumn>
        <RowIndicatorColumn Visible="False" >
            <HeaderStyle Width="20px"></HeaderStyle>
        </RowIndicatorColumn>
        <Columns>
            <telerik:GridBoundColumn Visible="False" ReadOnly="True" UniqueName="Id" DataField="Id">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn HeaderText="Bestemming" UniqueName="Destination" DataField="Destination">
            </telerik:GridBoundColumn>
            <%-- <telerik:GridBoundColumn HeaderText="Beschrijving" UniqueName="Description" DataField="Description">
            </telerik:GridBoundColumn> --%>
            <telerik:GridTemplateColumn HeaderText="Beschrijving" UniqueName="Description">
                <ItemTemplate>
                    <asp:HyperLink ID="lnkDescription" runat="server" />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridBoundColumn HeaderText="Heen" UniqueName="DepartureDate" DataType=System.DateTime DataFormatString="{0:dd/MM/yy}" DataField="DepartureDate">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn HeaderText="Terug" UniqueName="ReturnDate" DataType=System.DateTime DataFormatString="{0:dd/MM/yy}" DataField="ReturnDate">
            </telerik:GridBoundColumn>
            <telerik:GridTemplateColumn HeaderText="Niveau" UniqueName="NiveauIMG" DataField="Niveau.Grade">
                <ItemTemplate>
                    <asp:Image ID="imgNiveau" runat="server" AlternateText="stapper" />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
       </Columns>
     
      
</MasterTableView>

<PagerStyle PagerTextFormat="{4}    Huidige pagina {0} van {1}, items {2} tot {3} van {5}"/> 

<ClientSettings EnableRowHoverStyle="true" EnablePostBackOnRowClick="true">
 
</ClientSettings>

</telerik:RadGrid>

</telerik:RadAjaxPanel>

Code Behind
public partial class ARTravelList : ControlBase
    {
        private string _TravelType;
        public string TravelType
        {
            get { return _TravelType; }
            set { _TravelType = value; }
        }       
        public string PreviousTravelType
        {
            get { return (Session["TravelType"] == null) ? null : (string)Session["TravelType"]; }
            set { Session["TravelType"] = value; }
        }
       
      
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                PreviousTravelType = Request.QueryString["ReisType"].ToString();
               
            }         
        }

        protected void grdTravel_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
        {
            grdTravels.DataSource =GetAllTravels() ;
        }

        protected void grdTravel_ItemDataBound(object sender, GridItemEventArgs e)
        {
            if (e.Item is GridDataItem)
            {
                DataRowView dvTravel = e.Item.DataItem as DataRowView;

                HyperLink lnkDescription = e.Item.FindControl("lnkDescription") as HyperLink;
                if (lnkDescription == null) return;
                if (lnkDescription != null)
                {
                    lnkDescription.NavigateUrl = "~/nl/ReisDetail/" + _TravelType + "/" + dvTravel["TravelId"] + ".aspx";// "mailto:" + dvInsurance["Email"].ToString();
                    lnkDescription.Text = dvTravel["Description"].ToString();
                }
                Image imgNiveau = e.Item.FindControl("imgNiveau") as Image;
                if (imgNiveau == null) return;
                if (imgNiveau != null)
                {
                    imgNiveau.ImageUrl = dvTravel["Niveau"].ToString();                   
                }
            }
        }

        protected void grdTravel_ItemCommand(object source, GridCommandEventArgs e)
        {
            if (e.CommandName == "RowClick" && e.Item is GridDataItem)
            {
                string url = string.Empty;
                DataRowView oRow = (DataRowView)e.Item.DataItem;
                string TravelId = oRow["TravelId"].ToString();

                if (TravelType == "Default")
                    TravelType = PreviousTravelType;

                url = UrlHelper.Instance.GetSiteUrl() + "/nl/ReisDetail/" +
                   TravelType + "/" + TravelId + ".aspx";

                Response.Redirect(url);               
            }
        }

        private DataTable GetAllTravels()
        {
            return CreateDataTableFromList(GetTravel());
        }

        private DataTable CreateDataTableFromList(List<ARTravel> List)
        {
            DataTable oTable = new DataTable();
            oTable.Columns.Add("Id", typeof(Int32));
            oTable.Columns.Add("TravelId");
            oTable.Columns.Add("Destination");
            oTable.Columns.Add("Description");
            oTable.Columns.Add("DepartureDate");
            oTable.Columns.Add("ReturnDate");
            oTable.Columns.Add("Niveau");           

            foreach (ARTravel oItem in List)
            {
                DataRow oRow = oTable.NewRow();
                oRow["Id"] = oItem.Id;
                oRow["TravelId"] = oItem.TravelId;
                oRow["Destination"] = oItem.Destination.Name;
                oRow["Description"] = oItem.Description;

                oRow["DepartureDate"] = oItem.DepartureDate.ToShortDateString();
                oRow["ReturnDate"] = oItem.ReturnDate.ToShortDateString();

                oRow["Niveau"] = UrlHelper.Instance.GetSiteUrl() + "/img/ventjes" + oItem.Niveau.Grade + ".gif";
                               
                oTable.Rows.Add(oRow);
            }           

            return oTable;
        }

        private List<ARTravel> GetTravel()
        {
            TravelType = Request.QueryString["ReisType"];
            if (TravelType == "Default")
                TravelType = PreviousTravelType;
            ARTravel graph = new ARTravel(new ARNiveau(), new ARType(TravelType),new ARDestination());
            List<ARTravel> reizen = TravelFacade.Instance.GetTravels(true,TravelType, graph);

            return reizen;
        }              
    }

Using 2008.Q3 skins with 2009.Q1 Release : RadUpload

The official Q3 skins for RadUpload are attached to this post (Q3-Skins-RadUpload.zip).

The same instructions can also be applied for custom skins (since the RadUpload did not change its CSS class names).

There are two ways of using the attached skins (SkinName is the skin that you want to use):

ASP.NET Themes

This method is useful if you need to use the skin for all controls of a specific type in the whole web application.

You need to:

                1. change the <pages> declaration in your web.config to <pages theme="SkinName"> e.g.
                               <pages theme="Gray">

                2. add the following lines to the <appSettings> section of your web.config:

                                <add key="Telerik.EnableEmbeddedBaseStylesheet" value="false" />

                                <add key="Telerik.EnableEmbeddedSkins" value="false" />

                               <add key="Telerik.Skin" value="SkinName"/>
                      e.g.

                               <add key="Telerik.Skin" value="Gray"/>

                3. create an ASP.NET Theme, named SkinName and add the following all files and folders from the Q3-Skins-RadUpload archive:

                               Skins/ Upload.css

Skins/SkinName/*
e.g.

Skins/Upload.css
Skins/Gray/Upload.Gray.css
Skins/Gray/Upload/*.*

                              

A sample project, demonstrating this method, is attached to this post (Q3-Skins-ASPNETThemes-RadUpload.zip).

Direct skin registration

This method is useful if you have fewer instances of RadUpload.

You need to:

                1. set the Skin property accordingly

                2. set the EnableEmbeddedSkins and the EnableEmbeddedBaseStylesheet properties to false

                3. register the skin file using the following CSS:

    <link rel="stylesheet" type="text/css" href="~/Skins/ Upload.css" runat="server " />

<link rel="stylesheet" type="text/css" href="~/Skins/SkinName/Upload.SkinName.css" runat="server" />
e.g.

    <link rel="stylesheet" type="text/css" href="~/Skins/ Upload.css" runat="server" />

                    <link rel="stylesheet" type="text/css" href="~/Skins/Gray/Upload. Gray.css" runat="server"/>

A sample project, demonstrating this method, is attached to this post (Q3-Skins-DirectSkinRegistration-RadUpload.zip).

Using 2008.Q3 skins with 2009.Q1 Release : RadTreeView

The official Q3 skins for RadTreeView are attached to this post (Q3-Skins-RadTreeView.zip).

The same instructions can also be applied for custom skins (since the RadTreeView did not change its CSS class names).

There are two ways of using the attached skins (SkinName is the skin that you want to use):

ASP.NET Themes

This method is useful if you need to use the skin for all controls of a specific type in the whole web application.

You need to:

                1. change the <pages> declaration in your web.config to <pages theme="SkinName"> e.g.
                               <pages theme="Gray">

                2. add the following lines to the <appSettings> section of your web.config:

                                <add key="Telerik.EnableEmbeddedBaseStylesheet" value="false" />

                                <add key="Telerik.EnableEmbeddedSkins" value="false" />

                               <add key="Telerik.Skin" value="SkinName"/>
                      e.g.

                               <add key="Telerik.Skin" value="Gray"/>

                3. create an ASP.NET Theme, named SkinName and add the following all files and folders from the Q3-Skins-RadTreeView archive:

                               Skins/ TreeView.css

Skins/SkinName/*
e.g.

Skins/TreeView.css
Skins/Gray/TreeView.Gray.css
Skins/Gray/TreeView/*.*

                              

A sample project, demonstrating this method, is attached to this post (Q3-Skins-ASPNETThemes-RadTreeView.zip).

Direct skin registration

This method is useful if you have fewer instances of RadTreeView.

You need to:

                1. set the Skin property accordingly

                2. set the EnableEmbeddedSkins and the EnableEmbeddedBaseStylesheet properties to false

                3. register the skin file using the following CSS:

    <link rel="stylesheet" type="text/css" href="~/Skins/ TreeView.css" runat="server " />

<link rel="stylesheet" type="text/css" href="~/Skins/SkinName/TreeView.SkinName.css" runat="server" />
e.g.

    <link rel="stylesheet" type="text/css" href="~/Skins/ TreeView.css" runat="server" />

                    <link rel="stylesheet" type="text/css" href="~/Skins/Gray/TreeView. Gray.css" runat="server"/>

A sample project, demonstrating this method, is attached to this post (Q3-Skins-DirectSkinRegistration-RadTreeView.zip).

Using 2008.Q3 skins with 2009.Q1 Release : RadToolBar

The official Q3 skins for RadToolBar are attached to this post (Q3-Skins-RadToolBar.zip).

The same instructions can also be applied for custom skins (since the RadToolBar did not change its CSS class names).

There are two ways of using the attached skins (SkinName is the skin that you want to use):

ASP.NET Themes

This method is useful if you need to use the skin for all controls of a specific type in the whole web application.

You need to:

                1. change the <pages> declaration in your web.config to <pages theme="SkinName"> e.g.
                               <pages theme="Gray">

                2. add the following lines to the <appSettings> section of your web.config:

                                <add key="Telerik.EnableEmbeddedBaseStylesheet" value="false" />

                                <add key="Telerik.EnableEmbeddedSkins" value="false" />

                               <add key="Telerik.Skin" value="SkinName"/>
                      e.g.

                               <add key="Telerik.Skin" value="Gray"/>

                3. create an ASP.NET Theme, named SkinName and add the following all files and folders from the Q3-Skins-RadToolBar archive:

                               Skins/ ToolBar.css

Skins/SkinName/*
e.g.

Skins/ToolBar.css
Skins/Gray/ToolBar.Gray.css
Skins/Gray/ToolBar/*.*

                              

A sample project, demonstrating this method, is attached to this post (Q3-Skins-ASPNETThemes-RadToolBar.zip).

Direct skin registration

This method is useful if you have fewer instances of RadToolBar.

You need to:

                1. set the Skin property accordingly

                2. set the EnableEmbeddedSkins and the EnableEmbeddedBaseStylesheet properties to false

                3. register the skin file using the following CSS:

    <link rel="stylesheet" type="text/css" href="~/Skins/ ToolBar.css" runat="server " />

<link rel="stylesheet" type="text/css" href="~/Skins/SkinName/ToolBar.SkinName.css" runat="server" />
e.g.

    <link rel="stylesheet" type="text/css" href="~/Skins/ ToolBar.css" runat="server" />

                    <link rel="stylesheet" type="text/css" href="~/Skins/Gray/ToolBar. Gray.css" runat="server"/>

A sample project, demonstrating this method, is attached to this post (Q3-Skins-DirectSkinRegistration-RadToolBar.zip).

Using 2008.Q3 skins with 2009.Q1 Release : RadTabStrip

The official Q3 skins for RadTabStrip are attached to this post (Q3-Skins-RadTabStrip.zip).

The same instructions can also be applied for custom skins (since the RadTabStrip did not change its CSS class names).

There are two ways of using the attached skins (SkinName is the skin that you want to use):

ASP.NET Themes

This method is useful if you need to use the skin for all controls of a specific type in the whole web application.

You need to:

                1. change the <pages> declaration in your web.config to <pages theme="SkinName"> e.g.
                               <pages theme="Gray">

                2. add the following lines to the <appSettings> section of your web.config:

                                <add key="Telerik.EnableEmbeddedBaseStylesheet" value="false" />

                                <add key="Telerik.EnableEmbeddedSkins" value="false" />

                               <add key="Telerik.Skin" value="SkinName"/>
                      e.g.

                               <add key="Telerik.Skin" value="Gray"/>

                3. create an ASP.NET Theme, named SkinName and add the following all files and folders from the Q3-Skins-RadTabStrip archive:

                               Skins/ TabStrip.css

Skins/SkinName/*
e.g.

Skins/TabStrip.css
Skins/Gray/TabStrip.Gray.css
Skins/Gray/TabStrip/*.*

                              

A sample project, demonstrating this method, is attached to this post (Q3-Skins-ASPNETThemes-RadTabStrip.zip).

Direct skin registration

This method is useful if you have fewer instances of RadTabStrip.

You need to:

                1. set the Skin property accordingly

                2. set the EnableEmbeddedSkins and the EnableEmbeddedBaseStylesheet properties to false

                3. register the skin file using the following CSS:

    <link rel="stylesheet" type="text/css" href="~/Skins/ TabStrip.css" runat="server " />

<link rel="stylesheet" type="text/css" href="~/Skins/SkinName/TabStrip.SkinName.css" runat="server" />
e.g.

    <link rel="stylesheet" type="text/css" href="~/Skins/ TabStrip.css" runat="server" />

                    <link rel="stylesheet" type="text/css" href="~/Skins/Gray/TabStrip. Gray.css" runat="server"/>

A sample project, demonstrating this method, is attached to this post (Q3-Skins-DirectSkinRegistration-RadTabStrip.zip).

Using 2008.Q3 skins with 2009.Q1 Release : RadScheduler

The official Q3 skins for RadScheduler are attached to this post (Q3-Skins-RadScheduler.zip).

The same instructions can also be applied for custom skins (since the RadScheduler did not change its CSS class names).

There are two ways of using the attached skins (SkinName is the skin that you want to use):

ASP.NET Themes

This method is useful if you need to use the skin for all controls of a specific type in the whole web application.

You need to:

                1. change the <pages> declaration in your web.config to <pages theme="SkinName"> e.g.
                               <pages theme="Gray">

                2. add the following lines to the <appSettings> section of your web.config:

                                <add key="Telerik.EnableEmbeddedBaseStylesheet" value="false" />

                                <add key="Telerik.EnableEmbeddedSkins" value="false" />

                               <add key="Telerik.Skin" value="SkinName"/>
                      e.g.

                               <add key="Telerik.Skin" value="Gray"/>

                3. create an ASP.NET Theme, named SkinName and add the following all files and folders from the Q3-Skins-RadScheduler archive:

                               Skins/ Scheduler.css

Skins/SkinName/*
e.g.

Skins/Scheduler.css
Skins/Gray/Scheduler.Gray.css
Skins/Gray/Scheduler/*.*

                              

A sample project, demonstrating this method, is attached to this post (Q3-Skins-ASPNETThemes-RadScheduler.zip).

Direct skin registration

This method is useful if you have fewer instances of RadScheduler.

You need to:

                1. set the Skin property accordingly

                2. set the EnableEmbeddedSkins and the EnableEmbeddedBaseStylesheet properties to false

                3. register the skin file using the following CSS:

    <link rel="stylesheet" type="text/css" href="~/Skins/ Scheduler.css" runat="server " />

<link rel="stylesheet" type="text/css" href="~/Skins/SkinName/Scheduler.SkinName.css" runat="server" />
e.g.

    <link rel="stylesheet" type="text/css" href="~/Skins/ Scheduler.css" runat="server" />

                    <link rel="stylesheet" type="text/css" href="~/Skins/Gray/Scheduler. Gray.css" runat="server"/>

A sample project, demonstrating this method, is attached to this post (Q3-Skins-DirectSkinRegistration-RadScheduler.zip).

Using 2008.Q3 skins with 2009.Q1 Release : RadPanelBar

The official Q3 skins for RadPanelBar are attached to this post (Q3-Skins-RadPanelBar.zip).

The same instructions can also be applied for custom skins (since the RadPanelBar did not change its CSS class names).

There are two ways of using the attached skins (SkinName is the skin that you want to use):

ASP.NET Themes

This method is useful if you need to use the skin for all controls of a specific type in the whole web application.

You need to:

                1. change the <pages> declaration in your web.config to <pages theme="SkinName"> e.g.
                               <pages theme="Gray">

                2. add the following lines to the <appSettings> section of your web.config:

                                <add key="Telerik.EnableEmbeddedBaseStylesheet" value="false" />

                                <add key="Telerik.EnableEmbeddedSkins" value="false" />

                               <add key="Telerik.Skin" value="SkinName"/>
                      e.g.

                               <add key="Telerik.Skin" value="Gray"/>

                3. create an ASP.NET Theme, named SkinName and add the following all files and folders from the Q3-Skins-RadPanelBar archive:

                               Skins/ PanelBar.css

Skins/SkinName/*
e.g.

Skins/PanelBar.css
Skins/Gray/PanelBar.Gray.css
Skins/Gray/PanelBar/*.*

                              

A sample project, demonstrating this method, is attached to this post (Q3-Skins-ASPNETThemes-RadPanelBar.zip).

Direct skin registration

This method is useful if you have fewer instances of RadPanelBar.

You need to:

                1. set the Skin property accordingly

                2. set the EnableEmbeddedSkins and the EnableEmbeddedBaseStylesheet properties to false

                3. register the skin file using the following CSS:

    <link rel="stylesheet" type="text/css" href="~/Skins/ PanelBar.css" runat="server " />

<link rel="stylesheet" type="text/css" href="~/Skins/SkinName/PanelBar.SkinName.css" runat="server" />
e.g.

    <link rel="stylesheet" type="text/css" href="~/Skins/ PanelBar.css" runat="server" />

                    <link rel="stylesheet" type="text/css" href="~/Skins/Gray/PanelBar. Gray.css" runat="server"/>

A sample project, demonstrating this method, is attached to this post (Q3-Skins-DirectSkinRegistration-RadPanelBar.zip).

Hi,

i want to bind RadSlider from database value,
so how can i bind the RadSlider from Database value.

Using 2008.Q3 skins with 2009.Q1 Release : RadMenu

The official Q3 skins for RadMenu are attached to this post (Q3-Skins-RadMenu.zip).

The same instructions can also be applied for custom skins (since the RadMenu did not change its CSS class names).

There are two ways of using the attached skins (SkinName is the skin that you want to use):

ASP.NET Themes

This method is useful if you need to use the skin for all controls of a specific type in the whole web application.

You need to:

                1. change the <pages> declaration in your web.config to <pages theme="SkinName"> e.g.
                               <pages theme="Gray">

                2. add the following lines to the <appSettings> section of your web.config:

                                <add key="Telerik.EnableEmbeddedBaseStylesheet" value="false" />

                                <add key="Telerik.EnableEmbeddedSkins" value="false" />

                               <add key="Telerik.Skin" value="SkinName"/>
                      e.g.

                               <add key="Telerik.Skin" value="Gray"/>

                3. create an ASP.NET Theme, named SkinName and add the following all files and folders from the Q3-Skins-RadMenu archive:

                               Skins/ Menu.css

Skins/SkinName/*
e.g.

Skins/Menu.css
Skins/Gray/Menu.Gray.css
Skins/Gray/Menu/*.*

                              

A sample project, demonstrating this method, is attached to this post (Q3-Skins-ASPNETThemes-RadMenu.zip).

Direct skin registration

This method is useful if you have fewer instances of RadMenu.

You need to:

                1. set the Skin property accordingly

                2. set the EnableEmbeddedSkins and the EnableEmbeddedBaseStylesheet properties to false

                3. register the skin file using the following CSS:

    <link rel="stylesheet" type="text/css" href="~/Skins/ Menu.css" runat="server " />

<link rel="stylesheet" type="text/css" href="~/Skins/SkinName/Menu.SkinName.css" runat="server" />
e.g.

    <link rel="stylesheet" type="text/css" href="~/Skins/ Menu.css" runat="server" />

                    <link rel="stylesheet" type="text/css" href="~/Skins/Gray/Menu. Gray.css" runat="server"/>

A sample project, demonstrating this method, is attached to this post (Q3-Skins-DirectSkinRegistration-RadMenu.zip).