Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
65 views

Hi,

The user enters some data in Grid Numeric Column and checks some other open tab in browser and when user returns to that page, the Grid Numeric column value gets auto selected & it leads to data loss of autoselected value.. Please help me in preventing the auto selection. Thanks in advance.

Code: 

<telerik:GridNumericColumn DataField="Price" UniqueName="Price" MaxLength="15" DataFormatString="{0:#,##0.#0}"
                                DataType="System.Double" HeaderText="Price*" ItemStyle-Width="60px" HeaderStyle-Font-Bold="true">
                            </telerik:GridNumericColumn>

 

Viktor Tachev
Telerik team
 answered on 25 May 2015
1 answer
98 views

This work!

 

If (TryCast(e.Node.DataItem, DataRowView))("NodeId").ToString() = 3 Then
    e.Node.AllowDrag = False
End If

 

 This is not work

 

If (TryCast(e.Node.DataItem, DataRowView))("ParentNodeId").ToString() = 3 Then
    e.Node.AllowDrag = False
End If

Get: Exception Details: System.FormatException: Input string was not in a correct format.

Dimitar
Telerik team
 answered on 25 May 2015
1 answer
83 views

Hello. I have a problem. I created Layout by splitters and put the Tabstrip into the central area. In TabStrip I creates 2 tabs. In one tab I put PageView with UserControl and the second tab is empty UserControl. When page is loaded in first tab I see my UserControl. But after switch into the second tab and return into first I see an empty tab. The code is following.

Default.aspx:

 

<style type=css
html, body, form 
   height: 100%; 
   margin: 0px; 
   padding: 0px; 
</style>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Default" %>
<%@ Register Src="~/ChartUC.ascx" TagPrefix="uc1" TagName="Chart" %>
 
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<head runat="server">
    <title></title>
    <telerik:RadStyleSheetManager id="RadStyleSheetManager1" runat="server" />
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        <Scripts>
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />
        </Scripts>
    </telerik:RadScriptManager>
    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
        <script type="text/javascript">
         /* <![CDATA[ */
         function onTabSelecting(sender, args) {
             var tab = args.get_tab();
             if (tab.get_pageView())
             {
                 tab.set_postBack(false);
             }
         }
        /* ]]> */
        </script>
    </telerik:RadCodeBlock>
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" EnablePageHeadUpdate="true">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadTabStrip1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadTabStrip1"></telerik:AjaxUpdatedControl>
                    <telerik:AjaxUpdatedControl ControlID="RadMultiPage1" LoadingPanelID="LoadingPanel1"></telerik:AjaxUpdatedControl>
                </UpdatedControls>
            </telerik:AjaxSetting>
            <telerik:AjaxSetting AjaxControlID="RadMultiPage1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadMultiPage1"></telerik:AjaxUpdatedControl>
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
    <div>
        <telerik:RadSplitter ID="RadSplitter1" runat="server" Height="100%" LiveResize="true" Width="100%">
            <telerik:RadPane ID="navigationPane" runat="server" Width="25%" Height="100%">
                <p>Left</p>
            </telerik:RadPane>
            <telerik:RadSplitBar ID="RadSplitbar1" runat="server" CollapseMode="Forward" Height="100%">
            </telerik:RadSplitBar>
            <telerik:RadPane ID="contentPane" runat="server" Width="75%" Height="100%">
                <telerik:RadSplitter ID="RadSplitter2" runat="server" Orientation="Horizontal" Height="70%" LiveResize="true">
                    <telerik:RadPane ID="topPane" runat="server">
                         
                        <telerik:RadTabStrip ID="RadTabStrip1" runat="server" Skin="Glow" MultiPageID="RadMultiPage1"
                            Width="100%" SelectedIndex="0" OnTabClick="RadTabStrip1_TabClick" ClickSelectedTab="True"
                            OnClientTabSelecting="onTabSelecting" Align="Justify">
                        </telerik:RadTabStrip>
 
                        <telerik:RadMultiPage runat="server" ID="RadMultiPage1" SelectedIndex="0" RenderSelectedPageOnly="true"
                            OnPageViewCreated="RadMultiPage1_PageViewCreated" CssClass="RadMultiPage">
                        </telerik:RadMultiPage>
 
                    </telerik:RadPane>
                    <telerik:RadSplitBar ID="RadSplitbar2" runat="server" CollapseMode="Backward"/>
                    <telerik:RadPane ID="bottomPane" runat="server" Height="30%">
                         Nested Splitter Bottom Content
                    </telerik:RadPane>
                </telerik:RadSplitter>
            </telerik:RadPane>
        </telerik:RadSplitter>
    </div>
    </form>
</body>
</html>

Default.aspx.cs

 

using System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
 
using System.Data;
using System.Configuration;
using System.Web.Security;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Telerik.Web.UI;
 
public partial class Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            AddTab("Диаграмма Парето", "ChartUC");
            AddPageView(RadTabStrip1.FindTabByText("Диаграмма Парето"));
            AddTab("Таблица", "GridUC");
        }
    }
    protected void RadTabStrip1_TabClick(object sender, RadTabStripEventArgs e)
    {
        AddPageView(e.Tab);
        e.Tab.PageView.Selected = true;
    }
    protected void RadMultiPage1_PageViewCreated(object sender, RadMultiPageEventArgs e)
    {
        string userControlName = e.PageView.ID + ".ascx";
        Control userControl = Page.LoadControl(userControlName);
        userControl.ID = e.PageView.ID + "_userControl";
        e.PageView.Controls.Add(userControl);
    }
    private void AddPageView(RadTab tab)
    {
        RadPageView pageView = new RadPageView();
        pageView.ID = tab.PageViewID;
        RadMultiPage1.PageViews.Add(pageView);
        tab.PageViewID = pageView.ID;
    }
    private void AddTab(string tabName, string sId)
    {
        RadTab tab = new RadTab();
        tab.Text = tabName;
        tab.PageViewID = sId;
        tab.Width = Unit.Percentage(100);
        RadTabStrip1.Tabs.Add(tab);
    }
}

ChartUC.ascx

 

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="ChartUC.ascx.cs" Inherits="ChartUC" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<div class="contentWrapper">
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" UpdateInitiatorPanelsOnly="true" OnAjaxRequest="RadAjaxManager1_AjaxRequest">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadAjaxManager1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="gridLoadingPanel"></telerik:AjaxUpdatedControl>
                </UpdatedControls>
            </telerik:AjaxSetting>
            <telerik:AjaxSetting AjaxControlID="RadGrid1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />
                </UpdatedControls>
        </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
    <telerik:RadCodeBlock ID="RadCodeBlock2" runat="server">
        <script type="text/javascript">
            function SeriesClicked(e) {
                if (e.originalEvent.type === "contextmenu") {
                    // Disable browser context menu
                    e.originalEvent.preventDefault();
                    return;
                }
                var ajaxManager = $find("<%= RadAjaxManager1.ClientID %>");
                ajaxManager.ajaxRequest('Chart1SC' + '$' + e.series.index + '$' + e.point.categoryIx);
            }
        </script>
    </telerik:RadCodeBlock>
    <div style="width: 700px; height: 500px; float: left;">
        <telerik:RadHtmlChart runat="server" ID="m_ParetoChart" Height="400" Width="600">
            <ChartTitle Text="Дефекты ППМ. Диаграмма Парето">
            </ChartTitle>
            <ClientEvents OnSeriesClick="SeriesClicked" />
            <PlotArea>
                <Series>
                    <telerik:ColumnSeries Name="Дефекты">
                        <TooltipsAppearance Color="White" />
                    </telerik:ColumnSeries>
                    <telerik:LineSeries Name="Проценты">
                        <TooltipsAppearance Color="White" />
                    </telerik:LineSeries>
                </Series>
                <YAxis Width="3">
                    <TitleAppearance Text="Количество">
                        <TextStyle Color="Black" />
                    </TitleAppearance>
                    <LabelsAppearance>
                        <TextStyle Color="Black" />
                    </LabelsAppearance>
                </YAxis>
                    <AdditionalYAxes>
                    <telerik:AxisY Name="AdditionalAxis" Color="Black" Width="3" MaxValue="1.2">
                        <TitleAppearance Text="Проценты">
                            <TextStyle Color="Black" />
                        </TitleAppearance>
                        <LabelsAppearance>
                            <TextStyle Color="Black" />
                        </LabelsAppearance>
                        <LabelsAppearance DataFormatString="P" />
                    </telerik:AxisY>
                </AdditionalYAxes>
                <XAxis>
                    <TitleAppearance Text="Дефекты">
                        <TextStyle Color="Black" />
                    </TitleAppearance>
                    <LabelsAppearance>
                        <TextStyle Color="Black" />
                    </LabelsAppearance>
                    <AxisCrossingPoints>
                        <telerik:AxisCrossingPoint Value="0" />
                        <telerik:AxisCrossingPoint Value="9" />
                    </AxisCrossingPoints>
                </XAxis>
            </PlotArea>
            <Legend>
                <Appearance BackgroundColor="White" Position="Right" Visible="true" />
            </Legend>
        </telerik:RadHtmlChart>
    </div>
    <div style="width: 700px; height: 500px; float: left;">
        <h2>Дефекты ППМ. Таблица</h2>
        <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" AllowPaging="true"
            AllowSorting="true" AllowFilteringByColumn="true" GridLines="Both" PageSize="10"
            ClientSettings-Scrolling-AllowScroll="true"
            AllowCustomPaging="True" OnNeedDataSource="RadGrid1_NeedDataSource">
            <ClientSettings AllowKeyboardNavigation="True">
                <Scrolling AllowScroll="True" UseStaticHeaders="True" />
            </ClientSettings>
            <MasterTableView TableLayout="Fixed">
                <Columns>
                    <telerik:GridBoundColumn HeaderText="Вид дефектов на печатной плате" DataType="System.String"
                        DataField="CategoryID"/>
                    <telerik:GridBoundColumn HeaderText="Процент от общего числа дефектов" DataType="System.Double"
                        DataField="Percents"/>
                    <telerik:GridBoundColumn HeaderText="Дата обнаружения" DataType="System.DateTime"
                        DataField="Date"/>
                    <telerik:GridBoundColumn HeaderText="Контроллер" DataType="System.String"
                        DataField="Checker"/>
                </Columns>
            </MasterTableView>
        </telerik:RadGrid>
    </div>
</div>

Chart.ascx.cs

 

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml.Linq;
using Telerik.Web.UI;
 
public partial class ChartUC : System.Web.UI.UserControl
{
    public ChartUC()
    {
        m_SelectedSeries.SeriesIdx = -1;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            PopulateChart2();
        }
    }
    public struct SelectedSeries
    {
        public int SeriesIdx;
        public int ItemIdx;
    }
    private SelectedSeries m_SelectedSeries;
    protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
    {
        if (m_SelectedSeries.SeriesIdx == -1)
        {
            int startRowIndex = RadGrid1.CurrentPageIndex * RadGrid1.PageSize;
            int maximumRows = RadGrid1.PageSize;
            DataTable dt = PopulateGrid2(false);
            var v = dt.AsEnumerable().Skip(startRowIndex).Take(maximumRows);
            RadGrid1.DataSource = v.Any() ? v.CopyToDataTable() : dt.Clone();
        }
        else
        {
            DataTable dt = PopulateGrid2(false);
            var grps = dt.AsEnumerable().GroupBy(a => a.Field<string>("CategoryID")).OrderByDescending(b => b.Count());
            //var v = m_SelectedSeries.ItemIdx == 0 ? grps.Take(1) : grps.Skip(m_SelectedSeries.ItemIdx - 1).Take(1);
            var v = grps.Skip(m_SelectedSeries.ItemIdx).Take(1);
            var dt_ = v.First().CopyToDataTable();
            RadGrid1.VirtualItemCount = dt_.Rows.Count;
            RadGrid1.DataSource = dt_;
        }
    }
    private void PopulateChart2()
    {
        DataTable dt = PopulateGrid2(false);
        var grps = dt.AsEnumerable().GroupBy(a => a.Field<string>("CategoryID")).OrderByDescending(b => b.Count());
        RadHtmlChart chart = m_ParetoChart;
        var colSeries = chart.PlotArea.Series[0] as ColumnSeries;
        decimal sum = 0;
 
        foreach (var grp in grps)
        {
            //string sName = grp.Key;
            decimal ct = grp.Count();
            sum += ct;
            var csi = new CategorySeriesItem(ct);
            colSeries.SeriesItems.Add(csi);
        }
        //colSeries.TooltipsAppearance.ClientTemplate = "#=dataItem." + tooltipColumn + "#";
        var weights = new List<decimal>();
        foreach (var grp in grps)
        {
            decimal ct = grp.Count();
            weights.Add(ct / sum * 100);
        }
        var lineSeries = chart.PlotArea.Series[1] as LineSeries;
        decimal weight = 0;
        foreach (var val in weights)
        {
            weight += val;
            if (weight > 100) weight = 100;
            var v = Math.Round(weight);
            var csi = new CategorySeriesItem(v);
            lineSeries.SeriesItems.Add(csi);
        }
 
    }
    private DataTable PopulateGrid(bool a_bSetDataSource = true)
    {
        DataTable dt = new DataTable();
        DataColumn col = new DataColumn("CategoryID", typeof(string));
        dt.Columns.Add(col);
        col = new DataColumn("Percents", typeof(double));
        dt.Columns.Add(col);
        col = new DataColumn("Date", typeof(DateTime));
        dt.Columns.Add(col);
        col = new DataColumn("Checker", typeof(string));
        dt.Columns.Add(col);
        DataRow row = dt.NewRow();
        row["CategoryID"] = "Недостаток припоя";
        row["Percents"] = 60;
        row["Date"] = DateTime.Now;
        row["Checker"] = "Иванов И. И.";
        dt.Rows.Add(row);
        row = dt.NewRow();
        row["CategoryID"] = "Трещины";
        row["Percents"] = 10;
        row["Date"] = DateTime.Now;
        row["Checker"] = "Иванов И. И.";
        dt.Rows.Add(row);
        row = dt.NewRow();
        row["CategoryID"] = "Царапины";
        row["Percents"] = 10;
        row["Date"] = DateTime.Now;
        row["Checker"] = "Иванов И. И.";
        dt.Rows.Add(row);
        row = dt.NewRow();
        row["CategoryID"] = "Пятна припоя";
        row["Percents"] = 5;
        row["Date"] = DateTime.Now;
        row["Checker"] = "Иванов И. И.";
        dt.Rows.Add(row);
        row = dt.NewRow();
        row["CategoryID"] = "Тепловая деформация";
        row["Percents"] = 5;
        row["Date"] = DateTime.Now;
        row["Checker"] = "Иванов И. И.";
        dt.Rows.Add(row);
        row = dt.NewRow();
        row["CategoryID"] = "Расслоение платы";
        row["Percents"] = 7;
        row["Date"] = DateTime.Now;
        row["Checker"] = "Иванов И. И.";
        dt.Rows.Add(row);
        row = dt.NewRow();
        row["CategoryID"] = "Прочее";
        row["Percents"] = 3;
        row["Date"] = DateTime.Now;
        row["Checker"] = "Иванов И. И.";
        dt.Rows.Add(row);
        if (a_bSetDataSource)
        {
            RadGrid1.DataSource = dt;
            RadGrid1.DataBind();
        }
        return dt;
    }
 
    private DataTable PopulateGrid2(bool a_bSetDataSource = true)
    {
        DataTable dt = new DataTable();
        DataColumn col = new DataColumn("CategoryID", typeof(string));
        dt.Columns.Add(col);
        col = new DataColumn("Percents", typeof(double));
        dt.Columns.Add(col);
        col = new DataColumn("Date", typeof(DateTime));
        dt.Columns.Add(col);
        col = new DataColumn("Checker", typeof(string));
        dt.Columns.Add(col);
 
        var xd = XDocument.Load("D:/Work/ASP.Net/telerikt1/SimpleChart/bin/defects.xml");
        foreach (XElement xe in xd.Root.Elements())
        {
            var dr = dt.NewRow();
            dr["CategoryID"] = xe.Attribute("Type").Value;
            dr["Percents"] = 0;
            dr["Date"] = DateTime.Parse(xe.Attribute("Date").Value);
            dr["Checker"] = xe.Attribute("Checker").Value; ;
            dt.Rows.Add(dr);
        }
        RadGrid1.VirtualItemCount = dt.Rows.Count;
        if (a_bSetDataSource)
        {
            RadGrid1.DataSource = dt;
            RadGrid1.DataBind();
        }
        return dt;
    }
    public void RadAjaxManager1_AjaxRequest(object sender, AjaxRequestEventArgs e)
    {
        string[] a = e.Argument.Split('$');
        if (a[0] == "Chart1SC")
        {
            m_SelectedSeries.SeriesIdx = int.Parse(a[1]);
            m_SelectedSeries.ItemIdx = int.Parse(a[2]);
            RadGrid1.Rebind();
        }
    }
}

GridUC.ascx

 

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="GridUC.ascx.cs" Inherits="GridUC" %>

GridUC.ascx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
 
public partial class GridUC : System.Web.UI.UserControl
{
    public GridUC()
    {
 
    }
    protected void Page_Load(object sender, EventArgs e)
    {
 
    }
}

 

 

Nencho
Telerik team
 answered on 25 May 2015
4 answers
217 views

Hi All,

 

I have a radgrid which has DateTimeColumn with format as "dd-MMM-yyyy HH:MM:SS AM/PM" (eg - 18-May-2015 10:20:45 AM).

I want the format to be same when exported to excel.
Please help.

 NB - I donot want to use export fomat as 'Biff'

 

Best Regards ,

Anurag

Kostadin
Telerik team
 answered on 25 May 2015
5 answers
126 views

hi..

how i can validate other fields before showing file selection dialog of  RadAsyncUpload. 

Peter Filipov
Telerik team
 answered on 24 May 2015
15 answers
224 views
Is it possible to use Visual Style Builder to modify the "Clear" skin which the Car Rental Demo uses?  Specifically, I'd like to change out the Red color for another.  I've tried to upload the Clear.zip file into the VSB page, but get an HTTP 400 error.  Really love this skin and would very much like to use it elsewhere w/"tweaks" here and there (i.e., colorization and ajax image sprites).

Thanks in advance!
Jim
Tom
Top achievements
Rank 1
 answered on 23 May 2015
0 answers
80 views

Hello,

 I need help.

I'm try connect with MySQL, and not appear connection... can help me?

 

I install --> http://dev.mysql.com/downloads/file.php?id=407493

nugget package :

Install-Package MySql.Data
Install-Package MySQL.Data.Entities

Install-Package MySql.NET

 

and not work?

 

Anybody can help me?

Adler
Top achievements
Rank 1
 asked on 22 May 2015
1 answer
242 views

I have a Checkbox in a gridtemplatecolumn. When checked I would like it to auto post back. Everything seems to work, however I cannot get the DataKeyValue.

 

<telerik:RadGrid ID="rgd_OrdersNew" runat="server" DataSourceID="sds_ETP_OrdersShipped"
                                        AllowSorting="True" Width="800px">
                                        <MasterTableView AutoGenerateColumns="False" DataSourceID="sds_ETP_OrdersShipped"
                                            DataKeyNames="IDOrder, InvoiceNumber" ClientDataKeyNames="IDOrder, InvoiceNumber"
                                            HeaderStyle-Wrap="False" HeaderStyle-HorizontalAlign="Center">
                                            <Columns>
                                                <telerik:GridTemplateColumn DefaultInsertValue="" HeaderText=" " UniqueName="TemplateColumn"
                                                    ItemStyle-HorizontalAlign="Center" ItemStyle-Width="10px" ItemStyle-CssClass="radgrid_count"
                                                    FooterStyle-CssClass="radgrid_count">
                                                    <ItemTemplate>
                                                        <%# Container.ItemIndex+1 %>
                                                    </ItemTemplate>
                                                    <FooterStyle CssClass="radgrid_count"></FooterStyle>
                                                    <ItemStyle HorizontalAlign="Center" CssClass="radgrid_count" Width="10px"></ItemStyle>
                                                </telerik:GridTemplateColumn>
                                                <telerik:GridBoundColumn DataField="InvoiceNumber" DataType="System.Int32" FilterControlAltText="Filter InvoiceNumber column"
                                                    HeaderText="Invoice" SortExpression="InvoiceNumber" UniqueName="InvoiceNumber"
                                                    ItemStyle-HorizontalAlign="Center" DataFormatString="ETP-{0}" ItemStyle-ForeColor="#597791"
                                                    ItemStyle-Width="60px" ItemStyle-Wrap="False">
                                                    <ItemStyle HorizontalAlign="Center" Wrap="False" ForeColor="#597791" Width="60px">
                                                    </ItemStyle>
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn DataField="IDOrder" DataType="System.Int32" FilterControlAltText="Filter IDOrder column"
                                                    HeaderText="Order ID" SortExpression="IDOrder" UniqueName="IDOrder" ItemStyle-HorizontalAlign="Center"
                                                    Visible="True">
                                                    <ItemStyle HorizontalAlign="Center"></ItemStyle>
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn DataField="OrderStatus" FilterControlAltText="Filter OrderStatus column"
                                                    HeaderText="Status" ReadOnly="True" SortExpression="OrderStatus" UniqueName="OrderStatus"
                                                    Visible="False">
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn DataField="TrackingCode" FilterControlAltText="Filter TrackingCode column"
                                                    HeaderText="Tracking Code" ReadOnly="True" SortExpression="TrackingCode" UniqueName="TrackingCode"
                                                    Visible="True">
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn DataField="ShippingMethod" FilterControlAltText="Filter ShippingMethod column"
                                                    HeaderText="Shipping" ReadOnly="True" SortExpression="ShippingMethod" UniqueName="ShippingMethod"
                                                    Visible="True" ItemStyle-Wrap="False">
                                                    <ItemStyle Wrap="False" Width="100px"></ItemStyle>
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn DataField="IDCustomer" DataType="System.Int32" FilterControlAltText="Filter IDCustomer column"
                                                    HeaderText="Customer ID" SortExpression="IDCustomer" UniqueName="IDCustomer"
                                                    ItemStyle-HorizontalAlign="Center" Visible="False">
                                                    <ItemStyle HorizontalAlign="Center"></ItemStyle>
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn DataField="DateOrder" DataType="System.DateTime" FilterControlAltText="Filter DateOrder column"
                                                    HeaderText="Order Date" SortExpression="DateOrder" UniqueName="DateOrder" ItemStyle-HorizontalAlign="Right">
                                                    <ItemStyle HorizontalAlign="Right" Wrap="False"></ItemStyle>
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn DataField="OrderLastName" FilterControlAltText="Filter OrderLastName column"
                                                    HeaderText="Last Name" SortExpression="OrderLastName" UniqueName="OrderLastName">
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn DataField="OrderFirstName" FilterControlAltText="Filter OrderFirstName column"
                                                    HeaderText="First Name" SortExpression="OrderFirstName" UniqueName="OrderFirstName">
                                                </telerik:GridBoundColumn>
                                                <telerik:GridHyperLinkColumn DataNavigateUrlFields="TrackingCode" HeaderText=" "
                                                    DataNavigateUrlFormatString="https://tools.usps.com/go/TrackConfirmAction_input?qtc_tLabels1=[{0}]"
                                                    Text="Track" UniqueName="TrackingCode" AllowFiltering="False" ItemStyle-HorizontalAlign="Center"
                                                    Target="BLANK">
                                                    <ItemStyle Width="75px" CssClass="tbltdbutton" />
                                                </telerik:GridHyperLinkColumn>
                                                <telerik:GridTemplateColumn>
                                                    <ItemTemplate>
                                                        <asp:CheckBox ID="cbx_Deliverd" Checked='<%# Convert.ToBoolean(Eval("Delivered")) %>'
                                                            AutoPostBack="true" OnCheckedChanged="cbx_Deliverd_CheckedChanged" runat="server" />
                                                    </ItemTemplate>
                                                </telerik:GridTemplateColumn>
                                            </Columns>
                                        </MasterTableView>
                                        <ClientSettings EnablePostBackOnRowClick="true" AllowColumnsReorder="true" ReorderColumnsOnClient="true"
                                            EnableRowHoverStyle="true">
                                            <Selecting AllowRowSelect="true" />
                                        </ClientSettings>
                                    </telerik:RadGrid>

 

 

Protected Sub cbx_Deliverd_CheckedChanged(sender As Object, e As EventArgs)
 
    Dim cbx_Deliverd As CheckBox = DirectCast(sender, CheckBox)
    Dim item As GridDataItem = DirectCast(cbx_Deliverd.NamingContainer, GridDataItem)
    Dim Deliverd As CheckBox = DirectCast(cbx_Deliverd.FindControl("cbx_Deliverd"), CheckBox)
    Dim IDOder As String = item.GetDataKeyValue("IDOder").ToString()
 
    If Deliverd.Checked Then
 
        Dim sql As String
        Dim strConnString As [String] = System.Configuration.ConfigurationManager.ConnectionStrings("ETP_OPS_ConnectionString").ConnectionString()
        sql = "UPDATE Orders_Shipping SET Delivered = @Delivered WHERE IDOder = @IDOder"
        Dim connection As New SqlConnection(strConnString)
        Dim command As New SqlCommand(sql, connection)
 
        command.Parameters.Add("@IDOder", SqlDbType.Int).Value = IDOder
        command.Parameters.Add("@Delivered", SqlDbType.Int).Value = 1
        command.Connection.Open()
        command.ExecuteNonQuery()
        command.Connection.Close()
 
    End If
 
End Sub

 

 As always, any help much appreciated.

 

 

 

Allan
Top achievements
Rank 2
 answered on 22 May 2015
1 answer
79 views

Hello,

I need help to finish process.

I have 10 pages that call process that generate pdfs, above.

Exemple:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="P1.aspx.cs" Inherits="P1" %>

<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=9.0.15.225, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div align="center">
            <telerik:ReportViewer ID="ReportViewer1" runat="server" Width="100%" Height="530px" ProgressText="Generate...">
                <typereportsource typename="Project.Relatorios.Page1, Project.Relatorios, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"></typereportsource>
            </telerik:ReportViewer>
        </div>
    </form>
</body>
</html> 

public partial class Page1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            ReportViewer1.ReportSource.Parameters.Add("Id", User.Session().Id);
        }
    }
}

I need generate this process programmatically for one diretory, to generate 10 pdfs this diretory,

and concatenet this 10 pdf in one pdf, and show this pdf in one click of button.

 Anybody can help me?

 

Adler
Top achievements
Rank 1
 answered on 22 May 2015
3 answers
574 views

I would like to set the raddatepicker calendar to today's date if the DbSelectedDate = "1/1/1900"

 Here is my control ASPX

 

<telerik:RadDatePicker ID="rdp_ShipDate" runat="server" Culture="English (United States)"
    DbSelectedDate='<%#Bind("DateShipped")%>'
    SkipMinMaxDateValidationOnServer="True"  MinDate="1/1/1800 12:00:00 AM">
    <Calendar ID="Calendar1" runat="server" UseColumnHeadersAsSelectors="False" UseRowHeadersAsSelectors="False"
        ViewSelectorText="x">
        <SpecialDays>
            <telerik:RadCalendarDay Repeatable="Today" ItemStyle-BackColor="Green">
            </telerik:RadCalendarDay>
        </SpecialDays>
    </Calendar>
    <DatePopupButton HoverImageUrl="" ImageUrl="" />
</telerik:RadDatePicker>

 

 Here is my attempted code behind

 

Protected Sub fvw_OrderDetails_DataBound(sender As Object, e As System.EventArgs) Handles fvw_OrderDetails.DataBound
 
    If fvw_OrderDetails.CurrentMode = FormViewMode.Edit Then
        Dim DateShipped As RadDatePicker = DirectCast(fvw_OrderDetails.FindControl("rdp_ShipDate"), RadDatePicker)
        If DateShipped.DbSelectedDate = "1/1/1900" Then
            CType(fvw_OrderDetails.FindControl("rdp_ShipDate"), RadDatePicker).Calendar.FocusedDate = DateTime.Now
        End If
    End If
 
End Sub

 Any help much appreciated.

 

 

 

Eyup
Telerik team
 answered on 22 May 2015
Narrow your results
Selected tags
Tags
+? more
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?