Hi,
I have a rad grid displaying on the screen with some rows.When Expand each row i am presenting with three tabs(Detals,compartments,products).See attachment
When I click on Compartmrents tab need to display the grid based on the LoadId.
Presently i am displaying this grid based on shipment id but i need this grid based on the LoadId.

I am facing issue in pasing loadId value to storedprocedure for displaying this grid.

aspx File
GetDischargeDetailWSListByDischargeId(dischargeID);
<telerik:RadPane ID="LoadingPane" runat="server" CssClass="noOverflow" >
                        <div id="LoadingPanelHeader" class="paneHeader">
                            <span class="headerPaneText">
                                <asp:Label ID="lbl_LoadingHeader" runat="server"></asp:Label></span>
                        </div>
                        <!------------------------------------
                           ---------LOADING SECTION -----------
                           ------------------------------------->
                        <telerik:RadAjaxPanel ID="LoadingPanel" runat="server" CssClass="radPaneContent TransferHeader">
                                                    </telerik:RadAjaxPanel>
                        <telerik:RadGrid ID="LoadingRadGrid" OnItemDataBound="LoadingRadGridFormat_OnItemDataBound"
                            runat="server" AutoGenerateColumns="false" CssClass="TransferGridPanel" Height="275px"
                            Width="375px" OnNeedDataSource="LoadingRadGrid_NeedDataSource">
                            <MasterTableView ShowHeadersWhenNoRecords="true">
                           
                                <NestedViewTemplate>
                                
                                    <telerik:RadTabStrip runat="server" ID="LoadTabStip" MultiPageID="LoadMultipage"
                                        SelectedIndex="0" OnTabClick="LoadTabStip_TabClick" Orientation="HorizontalTop">
                                        <Tabs runat="server">
                                            <telerik:RadTab runat="server" Text="Details" PageViewID="RadPageViewDetails">
                                            </telerik:RadTab>
                                            <telerik:RadTab runat="server" Text="Compartments" PageViewID="RadPageViewCompartments">
                                            </telerik:RadTab>
                                            <telerik:RadTab runat="server" Text="Products" PageViewID="RadPageViewProducts">
                                            </telerik:RadTab>
                                        </Tabs>
                                    </telerik:RadTabStrip>
                                    <telerik:RadMultiPage runat="server" ID="LoadMultipage" SelectedIndex="0" RenderSelectedPageOnly="false">
                                   
                                        <telerik:RadPageView runat="server" ID="RadPageViewDetails">
                                       
                                            <div class="contactWrap">
                                                <table cellpadding="0" cellspacing="0">
                                                    <tr>
                                                       <td><asp:Label ID="lbl_TerminalId" runat="server" Text='Terminal Id:' Font-Bold="true"></asp:Label></td>
                                                       <td><asp:Label ID="lbl_TerminalIdValue" runat="server"></asp:Label> </td> 
                                                    </tr>
                                                    <tr>
                                                        <td><asp:Label ID="lbl_TerminalName" runat="server" Text='TerminalName:' Font-Bold="true"></asp:Label></td>
                                                        <td><asp:Label ID="lbl_TerminalNameValue" runat="server"></asp:Label> </td>
                                                       
                                                    </tr>
                                                </table>
                                            </div>
                                        </telerik:RadPageView>
                                        <telerik:RadPageView runat="server" ID="RadPageViewCompartments">
                                       
                                            <telerik:RadGrid ID="LoadTabRadGrid" runat="server" AutoGenerateColumns="false" CssClass="TransferGridPanel"
                                                Height="233px" Width="475px" >
                                                <MasterTableView ShowHeadersWhenNoRecords="true">                                               
                                                    <Columns>
                                                        <telerik:GridBoundColumn UniqueName="CompNo" DataField="CompartmentIndex" HeaderText="Comp No.">
                                                        </telerik:GridBoundColumn>
                                                        <telerik:GridBoundColumn UniqueName="PlannedLoadProd" DataField="PlannedProductName" HeaderText="Planned Product">
                                                        </telerik:GridBoundColumn>
                                                        <telerik:GridBoundColumn UniqueName="ActualLoadProd" DataField="ActualProductName" HeaderText="Actual Product">
                                                        </telerik:GridBoundColumn>
                                                        <telerik:GridBoundColumn UniqueName="PlannedLoadQty" DataField="PlannedQuantity" HeaderText="Planned Quantity">
                                                        </telerik:GridBoundColumn>
                                                        <telerik:GridBoundColumn UniqueName="ActualLoadQty" DataField="ActualQuantity" HeaderText="Actual Quantity">
                                                        </telerik:GridBoundColumn>
                                                    </Columns>
                                                </MasterTableView>
                                            </telerik:RadGrid>
                                           
                                        </telerik:RadPageView>
                                    </telerik:RadMultiPage>
                                 
                                </NestedViewTemplate>
                               
                                <Columns>
                                    <telerik:GridBoundColumn UniqueName="LoadId" DataField="Loading_ID">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn UniqueName="TerminalId" DataField="Plant_ID">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn UniqueName="TerminalName" DataField="TerminalName">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn UniqueName="LoadingStartTime" DataField="LoadingStartTime">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn UniqueName="LoadingEndTime" DataField="LoadingEndTime">
                                    </telerik:GridBoundColumn>
                                </Columns>
                            </MasterTableView>
                            <ClientSettings>
                                <Scrolling AllowScroll="true" />
                            </ClientSettings>
                        </telerik:RadGrid>
                      
                    </telerik:RadPane>

aspx.cs file:

protected void LoadTabStip_TabClick(object sender, RadTabStripEventArgs e)
    {
        //AddPageView(e.Tab.Text);
        e.Tab.PageView.Selected = true;
        string selectedtabindex = e.Tab.Text;
        Int64 shipmentID = Convert.ToInt64(ShiftTreeView.SelectedNode.Value);
        switch (selectedtabindex)
        {
            case "Details":
                {
                        break;
                }
            case "Compartments":
                {
                    RadPageView page = (RadPageView)e.Tab.PageView;
                    RadGrid grdLoad = (RadGrid)page.FindControl("LoadTabRadGrid");
                    List<LoadingDetailExtraEntity> loadingTabListinstance = new List<LoadingDetailExtraEntity>();
                    loadingTabListinstance = loadingDetailManager.GetLoadingDetailExtraListByShipmentId(shipmentID);
                    grdLoad.DataSource = loadingTabListinstance;
                    grdLoad.DataBind();
                    //e.Tab.Controls.Add(grdLoad);
                    break;
                }
            case "Products":
                {
                    break;
                }
        }
    }

I am using WebUserControls (ascx files) for editing a rad grid in two cases (Product Items and Order detail rows)

I would appreciate if someone can give me an idea on why in the fisrt case the Public Property DataItem() contains a DataRowView object, while in the second case the Public Property DataItem() contains a DynamicClass1 type with the values of the row fields {field1 = value1, field2 = value2...} (as exaclty works in the Telerik example)

In the DataBinding event...

in the first case I am accessing the values of the edited row as:  CType(editedItem.DataItem, DataRowView).Item(#) (!!)
in the second case I am accessing the values of the edited row as:  editedItem.DataItem.field1  (as exaclty works in the Telerik example)

I show you some relative code:

-----------------------
first case
-----------------------
ascx.vb
Imports System.Data.SqlClient
Imports System
Imports System.Data
Imports System.Collections
Imports System.Web.UI
Imports Telerik.Web.UI

Namespace EditFormItemDetails

  Class ItemDetails
    Inherits System.Web.UI.UserControl

    Private _dataItem As Object = Nothing


#Region "Web Form Designer generated code"

    Protected Overrides Sub OnInit(ByVal e As EventArgs)
      InitializeComponent()
      MyBase.OnInit(e)
    End Sub

    Private Sub InitializeComponent()
      AddHandler DataBinding, AddressOf Me.ItemDetails_DataBinding
    End Sub

#End Region

    Protected Sub Page_Load(sender As Object, e As EventArgs)
    End Sub

    Public Property DataItem() As Object
      Get
        Return Me._dataItem
      End Get
      Set(ByVal value As Object)
        Me._dataItem = value
      End Set
    End Property

ascx
<%@ Control Language="VB" AutoEventWireup="false" CodeFile="ItemDetails.ascx.vb"
  Inherits="EditFormItemDetails.ItemDetails" %>

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

aspx

<telerik:RadGrid ID="grdItems"
....
    <EditFormSettings UserControlName="ItemDetails.ascx"
              EditFormType="WebUserControl">
              <EditColumn ButtonType="ImageButton"/>   
              <PopUpSettings Width="1228px" Modal="true"/>
    </EditFormSettings>

-----------------------
second case
-----------------------
ascx.vb
Imports System.Data.SqlClient
Imports System
Imports System.Data
Imports System.Collections
Imports System.Web.UI
Imports Telerik.Web.UI

Namespace EditFormOrderDetails

  Class OrderDetails
    Inherits System.Web.UI.UserControl

    Private _dataItem As Object = Nothing


#Region "Web Form Designer generated code"

    Protected Overrides Sub OnInit(ByVal e As EventArgs)
      InitializeComponent()
      MyBase.OnInit(e)
    End Sub

    Private Sub InitializeComponent()
      AddHandler DataBinding, AddressOf Me.OrderDetails_DataBinding
    End Sub

#End Region

    Protected Sub Page_Load(sender As Object, e As EventArgs)
    End Sub

    Public Property DataItem() As Object
      Get
        Return Me._dataItem
      End Get
      Set(ByVal value As Object)
        Me._dataItem = value
      End Set
    End Property

ascx
<%@ Control Language="VB" AutoEventWireup="false" CodeFile="OrderDetails.ascx.vb"
  Inherits="EditFormOrderDetails.OrderDetails" %>

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

aspx

<telerik:RadGrid ID="grdItems"
....
    <EditFormSettings UserControlName="OrderDetails.ascx"
              EditFormType="WebUserControl">
              <EditColumn ButtonType="ImageButton"/>   
              <PopUpSettings Width="800px" Modal="true"/>
    </EditFormSettings>


I would appreciate if someone understands the reason of the dataitem difference.

(I am not really sure which other part of my code is relative. Please ask me to post whatever is useful.)

Thanks

this is my updatecommand code , i get new values but i want old value also how can i get it

Thanks

Hi,

I have the following challenge ;-), I have a radgrid and editing using Editform  I have a radbinary image and radasyncupload in the editform. I am able to store the image in the data base after the "update command". But after selecting I only see the filename but not the selected image.  it is NOT user friendly NOT showing the selected image when clicking on the radasyncupload. Question is how to display the selected value in the radbinary image  using asyncupload.in the edit template.

Thanks,

Henk

Hi, I am using

<MasterTableView AutoGenerateColumns="true" AllowFilteringByColumn="True"

to auto generate columns in grid and allow filtering, I would like to allow user to press enter to apply filter, and limit each filter by to 50px only for their width.

I was using this when i used to predefine the columns :

<telerik:GridBoundColumn FilterControlWidth="50px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo"

how to do this with auto generated columns?  Thanks.

Regards,
Alex

I have two asp panels with ID's Panelcombo and PanelGrid .Panelcombo contains 6 comboxes and Panel Grid contains 1 radgrid. After filling all comboboxes I am showing Radgrid.I have RadAjaxManger with the following setting
                   Radgrid contains RadNumerictextbox which has Client event as follows     which is not firing

Hi,
When I set the hierarchyloadmode to client I am having a strange issue. The first row is supposed to have one detail table row but it has over 50 blank ones. The problem only seems to happen for the first row of the master table, the rest are fine. When I set the mode back to default, the issue is not there. Has anyone else seen this?

I need some control like Image Manager from RadEditor. Does telerik have seperate control like ImageManager because i do not want to use it with RadEditor.

i need to exactly same funcationality like Image Manager

hi everybody,
i am tring to refill the marker.
when the page first loading no problem very thing works perfect. But if i want to re bind the maps. Markers again same place how can i solve this problem


    Private Sub FillHareket(ByVal Usrid As String, ByVal strv As String)
        Try
            bastar = StartDate.SelectedDate
            BitTar = EndDate.SelectedDate
        Catch ex As Exception

        End Try

        Dim str As String = ""
        If CheckBox1.Checked Then
            str = "0"
        End If

        If CheckBox2.Checked Then
            If str <> "" Then
                str += ",1"
            Else
                str = "1"
            End If
        End If

        Dim test As String = " "
        'Usrid = "HEPSI"

        Dim ds As DataSet
        test = " SELECT * FROM ("
        If Usrid = "HEPSI" Then
            test += "SELECT (CASE WHEN THareket.Boylam=0 THEN 1 ELSE 0 END) as renk,Userid, tarih, (CASE WHEN tipi=0 THEN 'Ziyaret' ELSE 'Sipariş' END) AS Tipi, TCari.Unvan, (CASE WHEN THareket.Enlem=0 THEN 41.058175  ELSE THareket.Enlem END) AS Enlem , (CASE WHEN THareket.Boylam=0 THEN 28.80995+RAND(ROW_NUMBER() OVER (ORDER BY Tarih))/1000 ELSE THareket.Boylam END) AS Boylam, Miktar, Tutar,cast( resim1 as nvarchar(200)) as resim1,cast( resim2 as nvarchar(200)) as resim2,cast( resim3 as nvarchar(200)) as resim3,cast( resim4 as nvarchar(200)) as resim4,THareket.EvrakNo, (CASE WHEN THareket.Boylam=0 THEN 1 ELSE 0 END) AS GPSYOK ,'' as carino ,'' as BolgeKodu FROM THareket INNER JOIN TCari ON THareket.CariNo=TCari.CariNo  WHERE (Tarih>=@Tarihbas AND Tarih<@Tarihbit) and thareket.tipi in (" + str + ") "
            'test += "SELECT (CASE WHEN THareket.Boylam=0 THEN 1 ELSE 0 END) as renk,Userid, tarih, (CASE WHEN tipi=0 THEN 'Ziyaret' ELSE 'Sipariş' END) AS Tipi, TCari.Unvan, (CASE WHEN THareket.Enlem=0 THEN 41.058175  ELSE THareket.Enlem END) AS Enlem , (CASE WHEN THareket.Boylam=0 THEN 28.80995+RAND(ROW_NUMBER() OVER (ORDER BY Tarih))/1000 ELSE THareket.Boylam END) AS Boylam, Miktar, Tutar,cast( resim1 as nvarchar(200)) as resim1,cast( resim2 as nvarchar(200)) as resim2,cast( resim3 as nvarchar(200)) as resim3,cast( resim4 as nvarchar(200)) as resim4,THareket.EvrakNo, (CASE WHEN THareket.Boylam=0 THEN 1 ELSE 0 END) AS GPSYOK ,'' as carino ,'' as BolgeKodu FROM THareket INNER JOIN TCari ON THareket.CariNo=TCari.CariNo  WHERE thareket.tipi='0' "
        Else
            test += "SELECT (CASE WHEN THareket.Boylam=0 THEN 1 ELSE 0 END) as renk,Userid, tarih, (CASE WHEN tipi=0 THEN 'Ziyaret' ELSE 'Sipariş' END) AS Tipi, TCari.Unvan, (CASE WHEN THareket.Enlem=0 THEN 41.058175  ELSE THareket.Enlem END) AS Enlem , (CASE WHEN THareket.Boylam=0 THEN 28.80995+RAND(ROW_NUMBER() OVER (ORDER BY Tarih))/1000 ELSE THareket.Boylam END) AS Boylam, Miktar, Tutar,cast( resim1 as nvarchar(200)) as resim1,cast( resim2 as nvarchar(200)) as resim2,cast( resim3 as nvarchar(200)) as resim3,cast( resim4 as nvarchar(200)) as resim4,THareket.EvrakNo, (CASE WHEN THareket.Boylam=0 THEN 1 ELSE 0 END) AS GPSYOK ,'' as carino ,'' as BolgeKodu FROM THareket INNER JOIN TCari ON THareket.CariNo=TCari.CariNo  WHERE " & IIf(Usrid <> "", "Userid='" & Usrid & "' AND", "") & "  (Tarih>=@Tarihbas AND Tarih<@Tarihbit) and thareket.tipi in (" + str + ") "
        End If

        If CheckBox3.Checked Then
            test += IIf(CheckBox1.Checked Or CheckBox2.Checked, " union ", "")
            test += "SELECT '3' as renk,'' as Userid,''as tarih,'Bayi' as Tipi, TCari.Unvan AS Unvan, MAX(TDHareket.Enlem) AS Enlem, MAX(TDHareket.Boylam) AS Boylam,0 as Miktar,0 as Tutar,'' as resim1,'' as  resim2,'' as resim3,'' as resim4,'' as EvrakNo,0 as GPSYOK  ,TDHareket.carino AS CariNo, TCari.BolgeKodu FROM TDHareket INNER JOIN TCari ON TDHareket.Carino=TCari.carino where   TDHareket.Enlem<>0 AND TDHareket.Boylam<>0 "
            If Usrid = "HEPSI" Then
                test += " GROUP BY TDHareket.carino, TCari.Unvan, TCari.BolgeKodu"
            Else
                test += " and TCari.BolgeKodu='" + HiddenField5.Value + "' GROUP BY TDHareket.carino, TCari.Unvan, TCari.BolgeKodu"
            End If

        End If

        Dim _param(1) As SqlParameter
        _param(0) = New SqlParameter("@Tarihbas", bastar)
        _param(1) = New SqlParameter("@Tarihbit", BitTar)
        test += " )as G ORDER BY GPSYOK,Tipi desc,Tarih desc"
        ds = GetData(test, _param, Nothing)

        If ds.Tables.Count > 0 Then
            RadGrid2.DataSource = ds
            RadGrid2.DataBind()
        End If

        RadMap1.DataSource = ds
        RadMap1.DataBind()

    End Sub

Hi all,
I have a RadGrid to display all the data from a SqlDataSource which is calling a stored procedure that generate dynamic column name and data.
The first column of the RadGrid is a link column and the following column is generated from the SP.
Due to the dynamic columns, so i cannot pre-set any column setting in the RadGrid such as $ currency sign and thousand separator,
I have to set it during the RadGrid1_ItemDataBound event, but the RadGrid doesn't show the currency format when it first load,
the RadGrid only show the correct currency format after Column Grouping (Ajax).

Anyway to show the correct currency format during the RadGrid first load?

Thanks!
George




Code Behind: