or
15 answers
374 views
Hi All
Is there a way to rebind the Scheduler Client side?
I am currently calling the Ajax Manager to rebind this,
The only problem with that is the Ajax manager rebinds all my Grids at the same time because they are updated controls of the Ajax Manager!
Many Thanks
Regards
Is there a way to rebind the Scheduler Client side?
I am currently calling the Ajax Manager to rebind this,
The only problem with that is the Ajax manager rebinds all my Grids at the same time because they are updated controls of the Ajax Manager!
Many Thanks
Regards
3 answers
131 views
Any solution???
Bozhidar
Telerik team
answered
on
26 May 2011
3 answers
168 views
I have a page in development that is basically a large hierarchical radgrid. What is happening is any sort of AJAX request is causing the page to scroll to the top. The loading panel is also not working. Please help!
Also, please note that there is a script manager inside the "DashboardSelector" user control.
ASP:
Code Behind:
Also, please note that there is a script manager inside the "DashboardSelector" user control.
ASP:
<%@ Page Title="" Language="VB" MasterPageFile="~/All/Site.master" EnableEventValidation="false" AutoEventWireup="false" CodeFile="Orders.aspx.vb" Inherits="Management_Dashboard_AllOrders" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><%@ Register src="../../Controls/DashboardSelector.ascx" tagname="DashboardSelector" tagprefix="uc1" %><asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server"></asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server"> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server" MinDisplayTime="5" Skin="Default" Transparency="20"> </telerik:RadAjaxLoadingPanel> <telerik:RadAjaxManager ID="RadAjaxManager" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="OrdersGrid"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="OrdersGrid" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <uc1:DashboardSelector ID="DashboardSelector1" runat="server" /> <h4>New Orders</h4> <telerik:RadButton ID="btnExportToExcel" runat="server" Text="Export to Excel"> </telerik:RadButton> <telerik:RadGrid ID="OrdersGrid" runat="server" AllowFilteringByColumn="True" AllowPaging="True" DataSourceID="GPOrderHeadersDataSource" GridLines="None" Skin="Telerik" AllowSorting="True" ShowGroupPanel="True"> <ExportSettings FileName="OrdersExport" IgnorePaging="True" ExportOnlyData="True"> <Excel Format="ExcelML" /><Excel Format="ExcelML"></Excel> </ExportSettings> <ClientSettings AllowColumnsReorder="True" AllowDragToGroup="True" ReorderColumnsOnClient="True"> </ClientSettings><MasterTableView AutoGenerateColumns="False" DataKeyNames="SOPNUMBE" DataSourceID="GPOrderHeadersDataSource" PageSize="50"> <DetailTables> <telerik:GridTableView runat="server" DataKeyNames="SOPNUMBE" AllowFilteringByColumn="False" AllowPaging="False" AutoGenerateColumns="False" DataSourceID="DetailsDataSource"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="SOPNUMBE" MasterKeyField="SOPNUMBE" /> </ParentTableRelation> <CommandItemSettings ExportToPdfText="Export to Pdf" /><CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings> <Columns> <telerik:GridBoundColumn DataField="SOPNUMBE" HeaderText="SOPNUMBE" SortExpression="SOPNUMBE" UniqueName="SOPNUMBE" Visible="False"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ITMSHNAM" HeaderText="ITMSHNAM" SortExpression="ITMSHNAM" UniqueName="ITMSHNAM"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ITEMDESC" HeaderText="ITEMDESC" SortExpression="ITEMDESC" UniqueName="ITEMDESC"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="STATUS" HeaderText="STATUS" SortExpression="STATUS" UniqueName="STATUS"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Qty" DataFormatString="{0:0}" DataType="System.Double" HeaderText="Qty" SortExpression="Qty" UniqueName="Qty"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ATYALLOC" DataFormatString="{0:0}" DataType="System.Double" HeaderText="ATYALLOC" SortExpression="ATYALLOC" UniqueName="ATYALLOC"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="QTYFULFI" DataFormatString="{0:0}" DataType="System.Double" HeaderText="QTYFULFI" SortExpression="QTYFULFI" UniqueName="QTYFULFI"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="LOCNCODE" HeaderText="LOCNCODE" SortExpression="LOCNCODE" UniqueName="LOCNCODE"> </telerik:GridBoundColumn> </Columns> </telerik:GridTableView> </DetailTables><CommandItemSettings ExportToPdfText="Export to Pdf" ShowAddNewRecordButton="False" ShowExportToExcelButton="True" ShowExportToPdfButton="True"></CommandItemSettings> <ExpandCollapseColumn Visible="True"> </ExpandCollapseColumn> <Columns> <telerik:GridTemplateColumn UniqueName="Color" AllowFiltering="False" Groupable="False"> <ItemTemplate> <telerik:RadComboBox ID="cboColorChanger" Runat="server" AutoPostBack="True" DataTextField="Color" DataValueField="SOPNUMBE" onselectedindexchanged="cboColorChanger0_SelectedIndexChanged" SelectedValue='<%# GetColor() %>' Skin="Telerik" Width="65px" > <Items> <telerik:RadComboBoxItem runat="server" Owner="cboColorChanger" Text="None" Value="None" /> <telerik:RadComboBoxItem runat="server" BackColor="Red" ForeColor="Red" Owner="cboColorChanger" Text="Red" Value="Red" /> <telerik:RadComboBoxItem runat="server" BackColor="#FF8000" ForeColor="#FF8000" Owner="cboColorChanger" Text="Orange" Value="Orange" /> <telerik:RadComboBoxItem runat="server" BackColor="Yellow" ForeColor="Yellow" Owner="cboColorChanger" Text="Yellow" Value="Yellow" /> <telerik:RadComboBoxItem runat="server" BackColor="Lime" ForeColor="Lime" Owner="cboColorChanger" Text="Green" Value="Green" /> <telerik:RadComboBoxItem runat="server" BackColor="Cyan" ForeColor="Cyan" Owner="cboColorChanger" Text="Blue" Value="Blue" /> <telerik:RadComboBoxItem runat="server" BackColor="Fuchsia" ForeColor="Fuchsia" Owner="cboColorChanger" Text="Pink" Value="Pink" /> </Items> </telerik:RadComboBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="CUSTNMBR" HeaderText="CUSTNMBR" ReadOnly="True" SortExpression="CUSTNMBR" UniqueName="CUSTNMBR" HeaderTooltip="Customer Number"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CUSTNAME" HeaderText="CUSTNAME" ReadOnly="True" SortExpression="CUSTNAME" UniqueName="CUSTNAME" Visible="False"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="SOPNUMBE" HeaderText="SOP" ReadOnly="True" SortExpression="SOPNUMBE" UniqueName="SOPNUMBE" HeaderTooltip="SOP Number"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="PO" HeaderText="PO" ReadOnly="True" SortExpression="PO" UniqueName="PO"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ReqShipDate" DataFormatString="{0:MM/dd/yyyy}" HeaderText="RSD" ReadOnly="True" SortExpression="ReqShipDate" UniqueName="ReqShipDate" HeaderTooltip="Required Ship Date"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ORDRDATE" DataFormatString="{0:MM/dd/yyyy}" HeaderText="OD" ReadOnly="True" SortExpression="ORDRDATE" UniqueName="ORDRDATE" HeaderTooltip="Order Date"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CITY" HeaderText="CITY" ReadOnly="True" SortExpression="CITY" UniqueName="CITY"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="STATE" HeaderText="ST" ReadOnly="True" SortExpression="STATE" UniqueName="STATE" HeaderTooltip="State"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DOCID" HeaderText="DOCID" ReadOnly="True" SortExpression="DOCID" UniqueName="DOCID"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="OREMSUBT" DataFormatString="{0:C}" HeaderText="OREMSUBT" ReadOnly="True" SortExpression="OREMSUBT" UniqueName="OREMSUBT" HeaderTooltip="Original Remaining Subtotal"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="NumLines" DataType="System.Int32" HeaderText="NL" ReadOnly="True" SortExpression="NumLines" UniqueName="NumLines" HeaderTooltip="Number of Lines"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn AllowFiltering="False" Groupable="False" HeaderText="Notes" Reorderable="False" UniqueName="Notes" Visible="False"> <%--<ItemTemplate> <table style="border-width: 0px; border-style: none; text-align: center;"> <tr><td> <telerik:RadTextBox ID="txtNotes" Runat="server" Height="50px" Skin="Telerik" Text="<%# GetNotes() %>" TextMode="MultiLine" Width="250px"> </telerik:RadTextBox> </td></tr> <tr><td> <telerik:RadButton ID="btnUpdateNotes" runat="server" Skin="Telerik" Text="Update Notes" onclick="btnUpdateNotes_Click"> </telerik:RadButton> </td></tr> </table> </ItemTemplate>--%> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn AllowFiltering="False" HeaderText="Note" Resizable="False" UniqueName="Notes Icon"> <ItemTemplate> <asp:Panel ID="NotesPanel" Visible="true" runat="server"> <asp:ImageButton ID="imgNote" runat="server" AlternateText="<%# GetNotes() %>" ImageUrl="<%# NoteImage() %>" onclick="ImageButton1_Click" ToolTip="<%# GetNotes() %>" /> </asp:Panel> <asp:Panel ID="EditNotesPanel" Visible="false" runat="server"> <table style="border-width: 0px; border-style: none; text-align: center;"> <tr><td> <telerik:RadTextBox ID="txtNotes" Runat="server" Height="50px" Skin="Telerik" Text="<%# GetNotes() %>" TextMode="MultiLine" Width="250px"> </telerik:RadTextBox> </td></tr> <tr><td> <telerik:RadButton ID="btnUpdateNotes" runat="server" Skin="Telerik" Text="Update Notes" onclick="btnUpdateNotes_Click"> </telerik:RadButton> </td></tr> </table> </asp:Panel> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> <PagerStyle Mode="NextPrevNumericAndAdvanced" /></MasterTableView><HeaderContextMenu EnableImageSprites="True" CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu> </telerik:RadGrid> <asp:SqlDataSource ID="GPOrderHeadersDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:OrdersConString %>" SelectCommand="SELECT RTRIM(SOP10100.CUSTNAME) AS CUSTNAME, RTRIM(SOP10100.SOPNUMBE) AS SOPNUMBE, RTRIM(SOP10100.CSTPONBR) AS PO, (SOP10100.ReqShipDate) AS ReqShipDate, (SOP10100.ORDRDATE) AS ORDRDATE, RTRIM(SOP10100.CITY) AS CITY, RTRIM(SOP10100.STATE) AS STATE, RTRIM(SOP10100.CUSTNMBR) AS CUSTNMBR, RTRIM(SOP10100.DOCID) AS DOCID, (SOP10100.OREMSUBT) AS OREMSUBT, COUNT(SOP10200.ITEMNMBR) AS NumLinesFROM SOP10100 INNER JOIN SOP10200 ON SOP10100.SOPNUMBE = SOP10200.SOPNUMBE AND SOP10100.SOPTYPE = SOP10200.SOPTYPEWHERE (SOP10100.CUSTNMBR NOT LIKE 'WALCANA') AND (SOP10100.CUSTNMBR NOT LIKE 'WALMART') AND (SOP10100.SOPTYPE = 2) AND VOIDSTTS = 0 GROUP BY RTRIM(SOP10100.CUSTNAME), RTRIM(SOP10100.SOPNUMBE), RTRIM(SOP10100.CSTPONBR), (SOP10100.ReqShipDate), (SOP10100.ORDRDATE), RTRIM(SOP10100.CITY), RTRIM(SOP10100.STATE), RTRIM(SOP10100.CUSTNMBR), RTRIM(SOP10100.DOCID), (SOP10100.OREMSUBT)ORDER BY RTRIM(SOP10100.CUSTNAME)"></asp:SqlDataSource> <asp:SqlDataSource ID="DetailsDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:OrdersConString %>" SelectCommand="SELECT RTRIM(SOP10100.SOPNUMBE) AS SOPNUMBE, RTRIM(IV00101.ITMSHNAM) AS ITMSHNAM, RTRIM(SOP10200.ITEMDESC) AS ITEMDESC, RTRIM(IV00101.USCATVLS_5) AS STATUS, ROUND(SOP10200.QTYREMAI,0) AS Qty, ROUND(SOP10200.ATYALLOC,0) AS ATYALLOC, ROUND(SOP10200.QTYFULFI,0) AS QTYFULFI, RTRIM(SOP10200.LOCNCODE) AS LOCNCODE FROM SOP10200 INNER JOIN IV00101 ON SOP10200.ITEMNMBR = IV00101.ITEMNMBR INNER JOIN SOP10100 ON SOP10200.SOPNUMBE = SOP10100.SOPNUMBE AND SOP10200.SOPTYPE = SOP10100.SOPTYPE WHERE (SOP10100.CUSTNMBR NOT LIKE 'WALCANA') AND (SOP10100.CUSTNMBR NOT LIKE 'WALMART') AND (SOP10200.SOPTYPE = 2) AND (SOP10100.VOIDSTTS = 0) AND (SOP10100.SOPNUMBE = @SOPNUMBE) ORDER BY SOPNUMBE DESC"> <SelectParameters> <asp:Parameter Name="SOPNUMBE" /> </SelectParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="ColorsDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:IntranetConnectionString %>" SelectCommand="SELECT * FROM [OrdersTableRowColor]"></asp:SqlDataSource> <telerik:RadWindowManager ID="RadWindowManager1" runat="server" Skin="Black"> <Windows> <telerik:RadWindow ID="NotesWindow" runat="server" Animation="Fade" AutoSize="True" EnableShadow="True" KeepInScreenBounds="True" Skin="Telerik" style="display:none;" VisibleStatusbar="False" DestroyOnClose="True" Overlay="True" Title="Update Note" Behavior="Close" Behaviors="Close" Modal="True"> </telerik:RadWindow> </Windows> </telerik:RadWindowManager> </asp:Content>Code Behind:
Imports Telerik.Web.UIImports System.DataImports System.Data.SqlClientPartial Class Management_Dashboard_AllOrders Inherits System.Web.UI.Page Dim conString As String = "Data Source=PDC-SQL1;Initial Catalog=Intranet;Integrated Security=True" Dim conn As SqlConnection = New SqlConnection(conString) Dim notesURL As String = "images/Note.png" Dim noNotesURL As String = "images/noNote.png" Protected Sub RadButton1_Click(sender As Object, e As System.EventArgs) Handles btnExportToExcel.Click OrdersGrid.MasterTableView.ExportToExcel() End Sub Protected Function GetNotes() As String Dim getTheNotes As SqlCommand = New SqlCommand("SELECT Notes FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn) Dim notes As String = "" Dim s As String = "" Try s = Eval("SOPNUMBE") Catch Try s = Session("SOP") Catch End Try End Try Try getTheNotes.Connection.Open() getTheNotes.Parameters.AddWithValue("@sopnumbe", s) notes = If(TypeOf getTheNotes.ExecuteScalar() Is DBNull, "", getTheNotes.ExecuteScalar()) Catch MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR") Finally getTheNotes.Connection.Close() End Try If notes <> Nothing Then Return notes Else Return "" End If End Function Protected Function GetColor() As String Dim getTheColor As SqlCommand = New SqlCommand("SELECT color FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn) Dim col As String = "" Try getTheColor.Connection.Open() getTheColor.Parameters.AddWithValue("@sopnumbe", Eval("SOPNUMBE").ToString) col = getTheColor.ExecuteScalar() Catch MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR") Finally getTheColor.Connection.Close() End Try If col <> Nothing Then Return col Else Return "None" End If End Function Protected Sub ColorRow(ByVal r As GridDataItem, col As String) Select Case col Case "None" r.BackColor = Drawing.Color.Empty Case "Red" r.BackColor = Drawing.Color.Red Case "Orange" r.BackColor = Drawing.Color.Orange Case "Yellow" r.BackColor = Drawing.Color.Yellow Case "Green" r.BackColor = Drawing.Color.Lime Case "Blue" r.BackColor = Drawing.Color.Cyan Case "Pink" r.BackColor = Drawing.Color.Fuchsia Case Else r.BackColor = Drawing.Color.Empty End Select End Sub Protected Sub cboColorChanger0_SelectedIndexChanged(sender As Object, e As Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs) Dim color As String = CType(sender, RadComboBox).SelectedValue Dim r As GridDataItem = CType(sender.parent.parent, GridDataItem) Dim sop As String = r("SOPNUMBE").Text Dim colorPresent As SqlCommand = New SqlCommand("SELECT * FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn) Dim getColor As SqlCommand = New SqlCommand("SELECT color FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn) Dim insertColor As SqlCommand = New SqlCommand("INSERT INTO [OrdersTableEX] ([SOPNUMBE],[color]) VALUES (@sopnumbe,@col)", conn) Dim updateColor As SqlCommand = New SqlCommand("UPDATE [OrdersTableEX] SET [color] = @col WHERE SOPNUMBE = @sopnumbe", conn) colorPresent.Parameters.AddWithValue("@sopnumbe", sop) Dim present As String = "" Try colorPresent.Connection.Open() present = colorPresent.ExecuteScalar() Catch MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR") Finally colorPresent.Connection.Close() End Try If present <> sop Then Try insertColor.Connection.Open() insertColor.Parameters.AddWithValue("@sopnumbe", sop) insertColor.Parameters.AddWithValue("@col", color) insertColor.ExecuteNonQuery() Catch MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR") Finally insertColor.Connection.Close() End Try Else Try updateColor.Connection.Open() updateColor.Parameters.AddWithValue("@col", color) updateColor.Parameters.AddWithValue("@sopnumbe", sop) updateColor.ExecuteNonQuery() Catch MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR") Finally updateColor.Connection.Close() End Try End If Dim col As String = "" Try getColor.Connection.Open() getColor.Parameters.AddWithValue("@sopnumbe", sop) col = getColor.ExecuteScalar() Catch MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR") Finally getColor.Connection.Close() End Try ColorRow(r, col) End Sub Protected Sub OrdersGrid_DataBound(sender As Object, e As System.EventArgs) Handles OrdersGrid.DataBound For Each r As GridDataItem In OrdersGrid.Items ColorRow(r, CType(r("Color").FindControl("cboColorChanger"), RadComboBox).SelectedValue) Next End Sub Protected Sub btnUpdateNotes_Click(sender As Object, e As System.EventArgs) Dim notes As String = CType(CType(sender.parent.parent, GridTableCell).FindControl("txtNotes"), RadTextBox).Text Dim r As GridDataItem = CType(sender.parent.parent.parent, GridDataItem) Dim sop As String = r("SOPNUMBE").Text Dim colorPresent As SqlCommand = New SqlCommand("SELECT * FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn) Dim getNotes As SqlCommand = New SqlCommand("SELECT Notes FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn) Dim insertNotes As SqlCommand = New SqlCommand("INSERT INTO [OrdersTableEX] ([SOPNUMBE],[Notes]) VALUES (@sopnumbe,@col)", conn) Dim updateNotes As SqlCommand = New SqlCommand("UPDATE [OrdersTableEX] SET [Notes] = @col WHERE SOPNUMBE = @sopnumbe", conn) colorPresent.Parameters.AddWithValue("@sopnumbe", sop) Dim present As String = "" Try colorPresent.Connection.Open() present = colorPresent.ExecuteScalar() Catch MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR") Finally colorPresent.Connection.Close() End Try If present <> sop Then Try insertNotes.Connection.Open() insertNotes.Parameters.AddWithValue("@sopnumbe", sop) insertNotes.Parameters.AddWithValue("@col", notes) insertNotes.ExecuteNonQuery() Catch MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR") Finally insertNotes.Connection.Close() End Try Else Try updateNotes.Connection.Open() updateNotes.Parameters.AddWithValue("@col", notes) updateNotes.Parameters.AddWithValue("@sopnumbe", sop) updateNotes.ExecuteNonQuery() Catch MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR") Finally updateNotes.Connection.Close() End Try End If CType(CType(sender.parent.parent, GridTableCell).FindControl("NotesPanel"), Panel).Visible = True CType(CType(sender.parent.parent, GridTableCell).FindControl("EditNotesPanel"), Panel).Visible = False Session("SOP") = sop CType(CType(sender.parent.parent, GridTableCell).FindControl("imgNote"), ImageButton).DataBind() End Sub Protected Function NoteImage() As String Dim getTheNotes As SqlCommand = New SqlCommand("SELECT Notes FROM OrdersTableEX WHERE SOPNUMBE = @sopnumbe", conn) Dim notes As String = "" Dim s As String = "" Try s = Eval("SOPNUMBE") Catch Try s = Session("SOP") Catch End Try End Try Try getTheNotes.Connection.Open() getTheNotes.Parameters.AddWithValue("@sopnumbe", s) notes = If(TypeOf getTheNotes.ExecuteScalar() Is DBNull, "", getTheNotes.ExecuteScalar()) Catch MsgBox("ERROR: Please contact IT", MsgBoxStyle.Critical, "ERROR") Finally getTheNotes.Connection.Close() End Try If notes <> Nothing Then Return notesURL Else Return noNotesURL End If End Function Protected Sub ImageButton1_Click(sender As Object, e As System.Web.UI.ImageClickEventArgs) Dim r As GridDataItem = CType(sender.parent.parent.parent, GridDataItem) Dim c As GridTableCell = CType(sender.parent.parent, GridTableCell) CType(c.FindControl("NotesPanel"), Panel).Visible = False CType(c.FindControl("EditNotesPanel"), Panel).Visible = True 'RadWindowManager1.Windows(0).NavigateUrl = "notesEditor.aspx?SOP=" + r("SOPNUMBE").Text 'RadWindowManager1.Windows(0).VisibleOnPageLoad = True End Sub Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load If IsPostBack Then RadWindowManager1.Windows(0).VisibleOnPageLoad = False End If End SubEnd Class
Pavlina
Telerik team
answered
on
26 May 2011
1 answer
27 views
Hi
I wanted to write some piece of server code inside the ImageManger.ascx file.For example i wanted to call some server side method by adding some simple <script runat="server">.and adding code withing <%%> But none of this seems to be working?
I also wanted to know why can not i access Session object within these user control?
i tried using codeblock etc but nothing worked Plz help?
I wanted to write some piece of server code inside the ImageManger.ascx file.For example i wanted to call some server side method by adding some simple <script runat="server">.and adding code withing <%%> But none of this seems to be working?
I also wanted to know why can not i access Session object within these user control?
i tried using codeblock etc but nothing worked Plz help?
Rumen
Telerik team
answered
on
26 May 2011
1 answer
102 views
I have two schedulers embedded in one page. It is very slow when I try to load the page in IE7. However, the loading speed inside Google Chrome was very fast. My customer doesn't satisfy with the loading speed in IE. Can you help with this?
Thanks.
Thanks.
Veronica
Telerik team
answered
on
26 May 2011
2 answers
105 views
Hello, I have a wide RadGrid (> 16 cols) that I am trying to export to PDF. When I export to PDF, the grid overflows out of the PDF width. Is there a way to make it use more than 1 page for the width of the table (e.g. 3 pages wide by N pages long)? I want to get something similar to what I get with the RadReport (in another page I am using the RadReport control and it renders the report 3p wide by N pages long). Included is the body of the RadGrid and the code-behind in which I format it. The RadGrid is ajaxified. Thanks for any help you can provide.
Private Sub PDFButton_Click(sender As Object, e As System.EventArgs) Handles PDFButton.Click _isExport = True For Each column As Telerik.Web.UI.GridColumn In ReportGrid.MasterTableView.Columns If column.UniqueName = "SelectCheckbox" Or column.UniqueName = "ViewButton" Then column.Visible = False EndIf Next ReportGrid.Width = New Unit(22) ReportGrid.MasterTableView.ExportToPdf() End Sub Private Sub ReportGrid_ItemCreated(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles ReportGrid.ItemCreated If _isExport Then If TypeOf (e.Item) Is GridHeaderItem Then Dim headerItem As GridHeaderItem = e.Item headerItem.Style("font-size") = "8pt" headerItem.Style("color") = "white" headerItem.Style("background-color") = "gray" headerItem.Style("vertical-align") = "bottom" For Each cell As TableCell In headerItem.Cells cell.Style("text-align") = "left" cell.Style("font-weight") = "bold" cell.Style("border-color") = "red" Next ElseIf TypeOf (e.Item) Is GridDataItem Then Dim bodyItem As GridDataItem = e.Item bodyItem.Style("font-size") = "8pt" bodyItem.Style("vertical-align") = "bottom" For Each cell As TableCell In bodyItem.Cells cell.Style("text-align") = "left" Next End If End If End Sub<telerik:RadGrid ID="ReportGrid" runat="server" Height="99%" AllowPaging="True" GridLines="None" PageSize="50" AllowSorting="True" AllowFilteringByColumn="false" AllowMultiRowSelection="true" AutoGenerateColumns="false"> <ClientSettings AllowColumnsReorder="true"> <Scrolling AllowScroll="true" UseStaticHeaders="true" /> <Selecting AllowRowSelect="true" /> <Resizing AllowColumnResize="true" AllowResizeToFit="false" ClipCellContentOnResize="true" ResizeGridOnColumnResize="true" EnableRealTimeResize="false" /> <ClientEvents OnRowDeselected="ReportGrid_OnRowDeselected" OnRowSelected="ReportGrid_OnRowSelected" /> </ClientSettings> <MasterTableView> <Columns> <telerik:GridClientSelectColumn UniqueName="SelectCheckbox" HeaderStyle-Width="30" /> <telerik:GridButtonColumn DataTextField="FullFileName" CommandName="View" ButtonType="ImageButton" UniqueName="ViewButton" ImageUrl="/Images/preview.png" HeaderStyle-Width="30" /> <telerik:GridBoundColumn DataField="DocArchiveSysKey" DataType="System.String" HeaderText="DocArchiveSysKey" SortExpression="DocArchiveSysKey" UniqueName="DocArchiveSysKey" /> <telerik:GridBoundColumn DataField="Division" DataType="System.String" HeaderText="Division" SortExpression="Division" UniqueName="Division" /> <telerik:GridBoundColumn DataField="Route" DataType="System.String" HeaderText="Route" SortExpression="Route" UniqueName="Route" /> <telerik:GridBoundColumn DataField="Outlet" DataType="System.String" HeaderText="Outlet" SortExpression="Outlet" UniqueName="Outlet" /> <telerik:GridBoundColumn DataField="OutletName" DataType="System.String" HeaderText="OutletName" SortExpression="OutletName" UniqueName="OutletName" /> <telerik:GridBoundColumn DataField="DocType" DataType="System.String" HeaderText="DocType" SortExpression="DocType" UniqueName="DocType" /> <telerik:GridBoundColumn DataField="DisplayDocType" DataType="System.String" HeaderText="DisplayDocType" SortExpression="DisplayDocType" UniqueName="DisplayDocType" /> <telerik:GridBoundColumn DataField="DocID" DataType="System.String" HeaderText="DocID" SortExpression="DocID" UniqueName="DocID" /> <telerik:GridBoundColumn DataField="DisplayDocDate" DataType="System.String" HeaderText="DisplayDocDate Date" SortExpression="DisplayDocDate" UniqueName="DisplayDocDate" /> <telerik:GridBoundColumn DataField="FileName" DataType="System.String" HeaderText="FileName" SortExpression="FileName" UniqueName="FileName" /> <telerik:GridBoundColumn DataField="FullFileName" DataType="System.String" HeaderText="FullFileName" SortExpression="FullFileName" UniqueName="FullFileName" /> <telerik:GridBoundColumn DataField="DisplaySettlementDate" DataType="System.DateTime" HeaderText="DisplaySettlementDate" SortExpression="DisplaySettlementDate" UniqueName="DisplaySettlementDate" /> <telerik:GridBoundColumn DataField="RC2Code" DataType="System.String" HeaderText="RC2Code" SortExpression="RC2Code" UniqueName="RC2Code" /> <telerik:GridBoundColumn DataField="RC3Code" DataType="System.String" HeaderText="RC3Code" SortExpression="RC3Code" UniqueName="RC3Code" /> <telerik:GridBoundColumn DataField="RC4Code" DataType="System.String" HeaderText="RC4Code" SortExpression="RC4Code" UniqueName="RC4Code" /> <telerik:GridBoundColumn DataField="RC5Code" DataType="System.String" HeaderText="RC5Code" SortExpression="RC5Code" UniqueName="RC5Code" /> <telerik:GridBoundColumn DataField="EA1Code" DataType="System.String" HeaderText="EA1Code" SortExpression="EA1Code" UniqueName="EA1Code" /> <telerik:GridBoundColumn DataField="EA2Code" DataType="System.String" HeaderText="EA2Code" SortExpression="EA2Code" UniqueName="EA2Code" /> <telerik:GridBoundColumn DataField="EA3Code" DataType="System.String" HeaderText="EA3Code" SortExpression="EA3Code" UniqueName="EA3Code" /> <telerik:GridBoundColumn DataField="EA4Code" DataType="System.String" HeaderText="EA4Code" SortExpression="EA4Code" UniqueName="EA4Code" /> <telerik:GridBoundColumn DataField="EA5Code" DataType="System.String" HeaderText="EA5Code" SortExpression="EA5Code" UniqueName="EA5Code" /> <telerik:GridBoundColumn DataField="EA6Code" DataType="System.String" HeaderText="EA6Code" SortExpression="EA6Code" UniqueName="EA6Code" /> <telerik:GridBoundColumn DataField="EA7Code" DataType="System.String" HeaderText="EA7Code" SortExpression="EA7Code" UniqueName="EA7Code" /> <telerik:GridBoundColumn DataField="EA8Code" DataType="System.String" HeaderText="EA8Code" SortExpression="EA8Code" UniqueName="EA8Code" /> <telerik:GridBoundColumn DataField="EA9Code" DataType="System.String" HeaderText="EA9Code" SortExpression="EA9Code" UniqueName="EA9Code" /> <telerik:GridBoundColumn DataField="EA10Code" DataType="System.String" HeaderText="EA10Code" SortExpression="EA10Code" UniqueName="EA10Code" /> </Columns> </MasterTableView> <ExportSettings HideStructureColumns="true" ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true"> <Pdf PageWidth="11in" PageHeight="8.5in" PageLeftMargin=".5in" PageRightMargin=".5in" PageTopMargin=".5in" PageBottomMargin=".5in" AllowCopy="true" AllowModify="true" AllowPrinting="true" /> </ExportSettings> </telerik:RadGrid>1 answer
73 views
Hello. I have a simple page containing a text box and a rad grid. I have attached a delete button on the grid row has a confirm text displayed on click of the btn.
The problem I am having is: If I have the cursor on the text box and I hit enter, its invoking the rad grid delete event, strating with delete confirm prompt. I do not want this to happen. I need to hook the enter key to some other events. And this is happening only on Mozilla. rest of the browsers do not invoke the delete event.
Any clues/fixes for this behaviour. Appreciate your help. thanks
code below:
<asp:textbox id="txtMLSNumber" runat="server" Width="110px"></asp:textbox> <telerik:RadGrid ID="grdPartials" DataSourceID ="ObjectDataSource1" CssClass="RemoveBorders" Skin="Outlook" runat="server" GridLines="None" AutoGenerateColumns="False" Width="690px" height="196px"> <AlternatingItemStyle BackColor="#DDECFE" /> <MasterTableView datasourceid="ObjectDataSource1" GridLines=none AllowAutomaticDeletes="true" EnableNoRecordsTemplate=true DataKeyNames ="PartialId,PropType" > <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings> <RowIndicatorColumn> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridHyperLinkColumn HeaderText = "" ItemStyle-HorizontalAlign="Left" Text ="Edit" UniqueName="lnkEdit" HeaderStyle-Font-Bold="false" HeaderStyle-Wrap="false" HeaderStyle-Width="40px"> </telerik:GridHyperLinkColumn> <telerik:GridBoundColumn DataField="PartialId" Visible =true HeaderText="Partial Id" ItemStyle-Width="100px" HeaderStyle-Width="100px" ItemStyle-Wrap=false HeaderStyle-Wrap="false" MaxLength="0" UniqueName="PartialId"> <HeaderStyle Wrap="False"></HeaderStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="StreetNumber" HeaderText="Street Number" ItemStyle-Width="100px" HeaderStyle-Width="100px" ItemStyle-Wrap=false HeaderStyle-Wrap="false" UniqueName="StreetNumber"> <HeaderStyle Wrap="False"></HeaderStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="StreetName" HeaderText="Street Name" ItemStyle-Width="100px" HeaderStyle-Width="100px" ItemStyle-Wrap=false HeaderStyle-Wrap="false" UniqueName="StreetName"> <HeaderStyle Wrap="False"></HeaderStyle> <ItemStyle Wrap="False"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="City" HeaderText="City" UniqueName="City" DataFormatString="<nobr>{0}</nobr>" ItemStyle-Width="100px" HeaderStyle-Width="100px" ItemStyle-Wrap=false HeaderStyle-Wrap="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="PropType" HeaderText="Prop Type" ItemStyle-Width="100px" HeaderStyle-Width="100px" ItemStyle-Wrap=false HeaderStyle-Wrap="false" UniqueName="PropType"> <HeaderStyle Wrap="False"></HeaderStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CreateDate" HeaderText="Create Date" DataFormatString="{0:MM/dd/yyyy}" ItemStyle-Width="100px" HeaderStyle-Width="100px" ItemStyle-Wrap=false HeaderStyle-Wrap="false" UniqueName="CreateDate"> </telerik:GridBoundColumn> <telerik:GridButtonColumn ConfirmText="Delete this record?" ConfirmDialogType="RadWindow" ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete" UniqueName="DeleteColumn"> <ItemStyle HorizontalAlign="Center" CssClass="MyImageButton" /> </telerik:GridButtonColumn> </Columns> <NoRecordsTemplate> <div style="text-align:center;padding-top:70px;font-size:medium">No Partial Listings Found!!!</div> <br /> </NoRecordsTemplate> </MasterTableView> <SelectedItemStyle /> <HeaderStyle BackColor="#D6E7FC" /> <ClientSettings Scrolling-ScrollHeight =200> <Selecting AllowRowSelect="True" /> <Scrolling AllowScroll =true UseStaticHeaders =true /> <Resizing AllowColumnResize="True" AllowRowResize="false" /> </ClientSettings> <ActiveItemStyle BackColor="#CC0099" /> </telerik:RadGrid> <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetPartials" TypeName = "Partials" DeleteMethod ="DeletePartials" > <DeleteParameters> <asp:Parameter Name="PartialId" Type ="String" /> <asp:Parameter Name="PropType" Type ="String" /> </DeleteParameters> </asp:ObjectDataSource>
Tsvetina
Telerik team
answered
on
26 May 2011
1 answer
77 views
Hi,
When expanding weekly recurrence rule wiAth interval =2 it is showing wrong dates between the range.
i am not finding any reply from blogs. it is not problem with cofiguration of 'ExpandRecurrece_UDF' , because all the other events like
day,weekly,monthly,yearly are working fine. only problem with weelky recurrence with interval = 2 and weekly day 'SAT,SUN' not working
can u check this issue. please check below rule and expand the rule you know the problem.
DTSTART:20110505T063000Z DTEND:20110505T073000Z RRULE:FREQ=WEEKLY;COUNT=6;INTERVAL=2;BYDAY=FR,SA,SU
Regards
Shashi...
When expanding weekly recurrence rule wiAth interval =2 it is showing wrong dates between the range.
i am not finding any reply from blogs. it is not problem with cofiguration of 'ExpandRecurrece_UDF' , because all the other events like
day,weekly,monthly,yearly are working fine. only problem with weelky recurrence with interval = 2 and weekly day 'SAT,SUN' not working
can u check this issue. please check below rule and expand the rule you know the problem.
DTSTART:20110505T063000Z DTEND:20110505T073000Z RRULE:FREQ=WEEKLY;COUNT=6;INTERVAL=2;BYDAY=FR,SA,SU
Regards
Shashi...
Veronica
Telerik team
answered
on
26 May 2011
3 answers
130 views
Hi,
While using below weekly recurrence rule not getting exact dates.
DTSTART:20110505T063000Z DTEND:20110505T073000Z RRULE:FREQ=WEEKLY;COUNT=6;INTERVAL=2;BYDAY=FR,SA,SU
Bi-Weekly recurrence not working correctly using ' ExpandRecurrence ' function . can u help in this
It is giving below output :
5/6/2011 (Friday )
5/7/2011 (Saturday)
5/15/2011 (Sunday)
5/20/2011 ( Friday )
5/21/2011 ( Saturday)
5/29/2011 ( Sunday )
Thanks & Regards
Shashi...
Veronica
Telerik team
answered
on
26 May 2011
2 answers
83 views
Hi,
I am trying to create a Radgrid from the codebehind at runtime. The grid works fine with paging, but the problem is i need to have the export functionality I tried the following code along with the grid creation even then the grid header is not displayed.
RadGrid1.MasterTableView.CommandItemSettings.ShowExportToPdfButton = true;
RadGrid1.MasterTableView.CommandItemSettings.ShowExportToExcelButton = true;
RadGrid1.MasterTableView.CommandItemSettings.ShowRefreshButton = true;
RadGrid1.ExportSettings.HideStructureColumns = true;
RadGrid1.ExportSettings.ExportOnlyData = true;
RadGrid1.ExportSettings.IgnorePaging = true;
RadGrid1.ExportSettings.OpenInNewWindow = true;
Am i missing something?
Thanks in advance.
I am trying to create a Radgrid from the codebehind at runtime. The grid works fine with paging, but the problem is i need to have the export functionality I tried the following code along with the grid creation even then the grid header is not displayed.
RadGrid1.MasterTableView.CommandItemSettings.ShowExportToPdfButton = true;
RadGrid1.MasterTableView.CommandItemSettings.ShowExportToExcelButton = true;
RadGrid1.MasterTableView.CommandItemSettings.ShowRefreshButton = true;
RadGrid1.ExportSettings.HideStructureColumns = true;
RadGrid1.ExportSettings.ExportOnlyData = true;
RadGrid1.ExportSettings.IgnorePaging = true;
RadGrid1.ExportSettings.OpenInNewWindow = true;
Am i missing something?
Thanks in advance.
Daniel
Telerik team
answered
on
26 May 2011
