Questions on UI for ASP.NET AJAX Forum

1 answer

693 views

Hi

I Have Bind Records From the database to Ex Id,Name,Empno to <telerik:RadGrid Here all filed using <telerik:GridBoundColumn here i need how to change
my Id column using Hyperlink from <telerik:GridBoundColumn then when i click my Id column hyperlink corresponding record fetch the new radwindow show the
records in the same page i shown radwindow no need refer other aspx how will do this

I search Telerik Url some code this

window.radopen("page.aspx?OrderID=" + id, "RadWindowDetails");

This code i do not need i need radwindow open exists page only.

Grid

answered on 10 Feb 2015

2 answers

528 views

Filter Icon is not fully showing in RadGrid?

Hi,

I applied filter part to my radgrid. but it's not showing filter icon fully.

Code :

<telerik:RadGrid ID="RadGrid1" AllowFilteringByColumn="true" runat="server" AutoGenerateColumns="False" AllowSorting="True"

AllowPaging="True" GridLines="None" ShowGroupPanel="True" CellSpacing="0">

<MasterTableView ShowFooter="true">

<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>

<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">

</RowIndicatorColumn>

<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">

</ExpandCollapseColumn>

<Columns>

<telerik:GridTemplateColumn Aggregate="Count" FooterAggregateFormatString="Total : {0:N0}"

SortExpression="TaskNo" FooterText="Total :" UniqueName="TaskNo" HeaderText="Task Id"

DataField="TaskNo" DataType="System.string" HeaderTooltip="TaskNo">

<ItemStyle Width="70px" Wrap="false" />

<HeaderStyle Width="70px" Wrap="false" />

<ItemTemplate>

<asp:HyperLink ID="HyperLink2" runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "TaskNo")%>'

NavigateUrl='<%#"~/MyTasksHierarchyMain.aspx?TaskNo=" + DataBinder.Eval(Container.DataItem, "TaskNo").ToString()%>'

Target="_blank"></asp:HyperLink>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="FileName" FilterControlAltText="Filter FileName column"

HeaderText="File Name" UniqueName="FileName" SortExpression="FileName" ReadOnly="True">

</telerik:GridBoundColumn>

Current Output display :

Thanks in advance..

Grid

answered on 09 Feb 2015

5 answers

487 views

Problem in Exporting RadGrid data to Excel

we are having an application with large number of data.

while exporting the data from rad grid to excel format we are getting the error :
Exception type: OutOfMemoryException
the Rad Grid contains the 25 columns and nearly 35,000 rows

there is one aspx page on that page load the data will fetch into the RadGrid and then the data will export to Excel or CSV
i pasted the HTML and cs code

can you please assist us on this

<telerik:RadGrid ID="radGrid" runat="server" Visible="false" AutoGenerateColumns="false" OnGridExporting="radGrid_GridExporting"
    OnExcelExportCellFormatting="RadGrid1_ExcelExportCellFormatting">
     <ExportSettings HideStructureColumns="true" />

       </telerik:RadGrid>

the .CS Code :

protected void Page_Load(object sender, EventArgs e)
{
        if (Request.QueryString["downloadoption"] != null)
         {
              LoadData();
          }
}

private void LoadData()
        {
            Logger.LogInformation("Start", "btnSaveAs_Click", "DownloadFormat");
            if (Request.QueryString["ReportPagerName"] != null)
            {
                ReportPager = Request.QueryString["ReportPagerName"];
            }
            if (Session[ReportPager] != null)
            {
                int reportIntId = 0;
                Int32.TryParse(Request.QueryString[ReportID], out reportIntId);
                //string reportID = Request.QueryString[ReportID];
                this.CheckDataAccess(DataAccessType.Report, null, null, null, null, null, null, null, reportIntId);
                if (!IsTransactionDetailsPage(reportIntId))
                {
                    reportPager = (ReportPager)Session[ReportPager];
                    AddColumnsToGrid();
                    SetExportSettings();
                    BindDataTable();
                }
                else
                {
                    if (Session["TransactionDetails"] != null)
                    {
                        DataTable dt = (DataTable)Session["TransactionDetails"];
                        this.radGrid.MasterTableView.Columns.Clear();
                        foreach (DataColumn dc in dt.Columns)
                        {

                            GridBoundColumn gbc1 = new GridBoundColumn();
                            gbc1.DataField = dc.ColumnName;
                            gbc1.HeaderText = string.Empty;
                            this.radGrid.MasterTableView.Columns.Add(gbc1);
                        }

                        this.radGrid.DataSource = dt;
                        this.radGrid.DataBind();
                    }
                }

                DownloadDataGrid();
            }
            Logger.LogInformation("End", "btnSaveAs_Click", "DownloadFormat");
        }

private void AddColumnsToGrid()
        {
            Logger.LogInformation("Start", "AddColumnsToGrid", "DownloadFormat");

            this.radGrid.MasterTableView.Columns.Clear();
            foreach (GridField entry in reportPager.ColumnDictionary.Values)
            {
                if (entry.IsDisplayField)
                {
                    GridBoundColumn gbc1 = new GridBoundColumn();
                    gbc1.DataField = entry.DataField;
                    gbc1.HeaderText = entry.HeaderText;
                    this.radGrid.MasterTableView.Columns.Add(gbc1);
                }
            }

            Logger.LogInformation("End", "AddColumnsToGrid", "DownloadFormat");
        }

private void SetExportSettings()
        {
            Logger.LogInformation("Start", "SetExportSettings", "DownloadFormat");

            this.radGrid.ExportSettings.ExportOnlyData = true;
            this.radGrid.ExportSettings.IgnorePaging = true;
            this.radGrid.ExportSettings.OpenInNewWindow = true;
            this.radGrid.ExportSettings.FileName = ConfigurationManager.AppSettings["DownloadDataFileName"];

            Logger.LogInformation("End", "SetExportSettings", "DownloadFormat");
        }

private void BindDataTable()
        {
            Logger.LogInformation("Start", "BindDataTable", "DownloadFormat");

            this.reportPager.StartRow = 1;
            this.reportPager.EndRow = this.reportPager.GetRowCount();
            DataTable dt;
            //Excel
            if (Request.QueryString["downloadoption"].ToString() == "EXCEL")
                dt = this.reportPager.GetDataTable(false, false);
            else
                dt = this.reportPager.GetDataTable(false);

            this.radGrid.DataSource = dt;
            this.radGrid.DataBind();

            Logger.LogInformation("End", "BindDataTable", "DownloadFormat");
        }

private void DownloadDataGrid()
        {
            Logger.LogInformation("Start", "DownloadData", "DownloadFormat");
            this.radGrid.Visible = true;
            //CSV
            if (Request.QueryString["downloadoption"].ToString() == "CSV")
            {
                //if (SelRadioButtonList1.SelectedItem.Text == SelRadioButtonList1.Items[2].Text){

                this.SetCSVDelimiter();
                this.radGrid.MasterTableView.ExportToCSV();
            }
            //Excel
            else if (Request.QueryString["downloadoption"].ToString() == "EXCEL")
            {
                //else if (SelRadioButtonList1.SelectedItem.Text == SelRadioButtonList1.Items[0].Text)
                //{
                this.radGrid.MasterTableView.ExportToExcel();
            }
}

protected void radGrid_GridExporting(object source, GridExportingArgs e)
        {
            Logger.LogInformation("Start", "radGrid_GridExporting", "DownloadFormat");
            Response.ClearContent();
            Response.ClearHeaders();
            Response.Clear();
            Response.BufferOutput = true;
            if (e.ExportType == ExportType.Excel || e.ExportType == ExportType.Csv)
            {
                string filename = radGrid.ExportSettings.FileName;
                string fileExtension = radGrid.ExportSettings.Excel.FileExtension;
                if (e.ExportType == ExportType.Csv)
                    fileExtension = radGrid.ExportSettings.Csv.FileExtension;

                this.Response.AddHeader("Content-Disposition", "attachment;filename=\"" + filename + "." + fileExtension + "\"");

                if (e.ExportType == ExportType.Excel)
                {

                    //specify the number decimal separator and group separator being used.
                    string css = "<style type='text/css'> </style>";
                    //css += @"<script type=""text/javascript"" language=""javascript"">window.opener.Invoked();</script>";
                    e.ExportOutput = e.ExportOutput.Replace("</head>", css + "</head>");
                }
            }
            if (Request.QueryString["downloadoption"].ToString() == "CSV")
            {

                Response.ContentType = "application/octet-stream";
                Response.AddHeader("Content-Type", "text/csv");
                Response.BinaryWrite(new UnicodeEncoding().GetBytes(e.ExportOutput));
                Response.Flush();
                Response.End();
            }
            Logger.LogInformation("End", "radGrid_GridExporting", "DownloadFormat");

        }

Grid

answered on 09 Feb 2015

1 answer

392 views

Export Excel out of memory issue with 70 columns

Hello Team,

I am using Rad grid, that is having more then 100000 records with 70 columns,

I tried with even 10000 records only to check export issues but, Export to excel is not working, it slows down the page, and after waiting for 20 mins, its still not exporting the data.

Can anyone help me out with this?

Thanks and Regards,
Ruchi Patel

Grid

answered on 09 Feb 2015

2 answers

114 views

Upload document issue

Hello Team ,

I am using the Telerik RadAsyncUpload , where I am client facing the problem during the upload, yellow indicator is not getting turn into green during file browse.
and I am getting stuck on upload.

Please do help to rid this issue, as it is very important for business.
I have attached the screen shot

AsyncUpload

answered on 09 Feb 2015

3 answers

304 views

Horizontal Panelbar?

Hi there,

I was wondering if you could tell me whether there are any plans to create a panelbar that expands horizontally - my thinking is an accordion-style menu capability where the tabs (vertical) slide the panels out along the x axis such as here:

http://www.g4enterprises.com/

(I realise that one is flash-based, but you get the idea!)

PanelBar

answered on 09 Feb 2015

2 answers

110 views

Problem when I try to edit an specific row

Hi mates,

I have a radgrid and a external textbox and button to search specifics rows in the radgrid. Basically I change the SelectCommand of the RadGrid DataSource when I use the search button.

The first column of the radgrid is the following:

<telerik:GridTemplateColumn UniqueName="EditarEstado" ItemStyle-HorizontalAlign="Center" AutoPostBackOnFilter="false">
    <HeaderStyle Width="50px" />
    <ItemTemplate>
          <asp:ImageButton ID="btnEditarEstado" CommandName="Edit" runat="server" ImageUrl="~/img/buttons/edit.png"
          CommandArgument='<%# Eval("id") %>' ToolTip="Modificar" />
    </ItemTemplate>
</telerik:GridTemplateColumn>

If I search an specific row using the textbox and the search button, the row is showed successfully in the radgrid. The issue happens if I try to edit that row using the btnEditarEstado ImageButton. When I clic on it, autopostback is executed and the default SelectCommand of the radgrid datasource is set, so, it's like if I try to edit the first row and not the row that I searched.

How could I edit the selected row and not the default first one, please?

Please, let me know if you have any problem to understand my problem.

Thanks a lot in advance.

Cheers.

Grid

answered on 09 Feb 2015

1 answer

95 views

RadGrid does not adjust height when groups are collapsed

Hi,

I have a RadGrid with height=300px, it does not adjust it's height when groups are collapsed. I would like it's height to be 300px or less and show scrollbars when needed. When groups are collapsed, it shows whitespace as seen in given image to fill grid height. How can I adjust grid height when groups are collapsed?

I want grid height to adjust like in this demo.
http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/grouping/grouping/defaultcs.aspx

Thanks,
Prava

Grid

answered on 09 Feb 2015

1 answer

137 views

RadRating becomes read only and losses style after postback using a Modal popup

I have a RadRating on a page that if clicked runs javascript that opens a modal. The modal pop-up contains a "separate" RadRating module. Everything work fine until the form on the modal popup is submitted. This asp:Button-based submission saves to db; generates a postback; and runs javascript that hides the modal.

What javascript do I need to use to reload my RadRating after postback from a Foundation 5 reveal modal popup? (more about modal http://foundation.zurb.com/docs/components/reveal.html)

var prm = Sys.WebForms.PageRequestManager.getInstance();
prm.add_endRequest(function () {
// What do I put here to re-initialize the RadRating on the main page?
});

Rating

answered on 09 Feb 2015

2 answers

92 views

On Demand web service call retry?

We're trying to work around a possible network/browser issue at a client site. Occasionally the on demand web service call is failing. The request the browser makes is completely empty. Any subsequent call succeeds. Is there any way to retry the web service call up to 3 times before returning an error? It's easy enough in jQuery, but I can't find how to manage the calls myself with the RadComboBox

Thanks.

ComboBox

answered on 09 Feb 2015