Telerik Forums
UI for ASP.NET AJAX Forum
0 answers
90 views
Hi,
i am D.Srinivasa,

                       in my project i have a RadGrid to Display a Data from the DataBase, in my RadGrid i have a RadDatePicker Control to display a date from backend,  here enabled the maximum date condition in Raddatepicker,

the following coding is the condition for maximum date operation in RadDatePicker, it checks whether the database can have the data or not, if data is available then it sets the maximum date to that RadDatePicker,

some times it works perfectly but some times it returns error.. 

it returns an error is Specified Cast in Not Valid..

Code Is : 

<telerik:GridTemplateColumn UniqueName="gridActStart" HeaderText="Actual Start" AllowFiltering="false" ItemStyle-HorizontalAlign="Center"><br>
 <
ItemTemplate><br>                      
 <
telerik:RadDatePicker ID="actstart" runat="server" MaxDate='<%#If((Eval("early_start_display") IsNot DBNull.Value), Convert.ToDateTime(Eval("early_start_display")), CType("10/10/2011", System.Nullable(Of DateTime))) %>' Width="100px" Calendar-ShowOtherMonthsDays="false" Calendar-ShowRowHeaders="false" DbSelectedDate='<%# Bind("actual_start") %>' DateInput-DateFormat="MM/dd/yyyy">                     
</
telerik:RadDatePicker><br>                       
</
ItemTemplate><br>                   
 </
telerik:GridTemplateColumn>

and the following attachment is the database for my application. How to resolve this problem,
D.SRINIVASA
Top achievements
Rank 2
 asked on 27 Aug 2011
17 answers
1.8K+ views
I saw a post in Todd Anglin's blog from September about how to format output (font size, etc) of a grid export to PDF.  But I tried the suggestion and the suggested code had no effect on the output.  Is there anywhere I can go for a better discussion of this?
Jorge
Top achievements
Rank 1
 answered on 27 Aug 2011
1 answer
124 views

Hi,
   I have just started using the Telerik controls recently had a question which was frustrating me. I have a grid with a popup edit form. Inside the edit form I want to certain table rows depending on if the user clicks a button. I have registered the Jquery library in my masterpage already, and when i click the button the change happens only for a second then dissapears and the original rows are back. How can I persist the jquery change im trying to make? I even tried with an html button but it still does the same thing.  There has to be a way to do simple functions like hide/show table rows, can someone point that out please look below. This is the table in the Edit pop up form and down below is the Radcodeblock with the javascript. Thanks in advance!

 
<table id="tblEditPopup" style="width:100%; height:100%"
  
<tr id="trProduct"
  
<td align="right"
Select Product:
</td
<td
<telerik:RadComboBox ID="cboxCustomers" runat="server" AutoPostBack="true"
<Items
<telerik:RadComboBoxItem Text="Select Product" /> 
   
<telerik:RadComboBoxItem Text="Apple" Value="Apple" /> 
  
<telerik:RadComboBoxItem Text="Bananas" Value="Bananas" /> 
</Items
</telerik:RadComboBox
</td
</tr>
  
<tr id="trService" style="display:none"
<td align="right"
Select Service:
</td
<td
  
<telerik:RadComboBox ID="cboxServices" runat="server" AutoPostBack="true"
<Items
<telerik:RadComboBoxItem Text="Select Service" /> 
<telerik:RadComboBoxItem Text="Deliver Home" Value="Delivery" />
<telerik:RadComboBoxItem Text="Order By Mail" Value="Mail" /> 
</Items
<telerik:RadComboBox>
  
</td
</tr>
<tr>
<td>

<button id="BtnService" onclick="toggle()" >Choose Service</button>

</td>
</tr>
</table>
  
  
<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"
<script type="text/javascript"
  
function toggle() { 
    
$('#trProduct').css('display', 'none'); 
  
  
$('#trService').css('display', 'block'); 
}
  
</script
</telerik:RadCodeBlock
  
   
  
  
Farhan
Top achievements
Rank 1
 answered on 26 Aug 2011
1 answer
609 views
i have 6 charts in one page , everything works on my machine , but when i deploy the project to Server then i get "Specified cast is not valid" Error
the problem is just from one of the charts, when i remove it ,it work at the server too.
i put catch all around my code but i'm not getting any Exception even in the server. let me know if you need more data




Specified cast is not valid.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Specified cast is not valid.  

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidCastException: Specified cast is not valid.]
   System.Data.UnboxT`1.ValueField(Object value) +51
   System.Data.DataRowExtensions.Field(DataRow row, String columnName) +51
   ThinClient.DashBoard.WUC_Collection_Chart.<LinqDataSource_Collections_Selecting>b__2(DataRow Collect) +138
   System.Linq.WhereSelectEnumerableIterator`2.MoveNext() +151
   System.Linq.<SkipIterator>d__4d`1.MoveNext() +86
   System.Linq.<TakeIterator>d__3a`1.MoveNext() +127
   System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +327
   System.Linq.Enumerable.ToList(IEnumerable`1 source) +58

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) +0
   System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner) +72
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +251
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +28
   System.Web.UI.WebControls.QueryableDataSourceHelper.ToList(IQueryable query, Type dataObjectType) +129
   System.Web.UI.WebControls.LinqDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +343
   System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +21
   Telerik.Web.UI.RadChart.PerformSelect() +159
   Telerik.Web.UI.RadChart.DataBind() +98
   System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +66
   Telerik.Web.UI.RadChart.OnPreRender(EventArgs e) +22
   System.Web.UI.Control.PreRenderRecursiveInternal() +103
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Control.PreRenderRecursiveInternal() +175
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2496


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1              

  
Ashim
Top achievements
Rank 1
 answered on 26 Aug 2011
3 answers
856 views

Hi,
I have a grid like following.....I have given only 1 column but there are 10 similar columns which comes from DB..similar in the sense it is rendered similar way this one column is shown below.
ASPX page.

 

 

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server">
<telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="true" Width="1080px" AutoGenerateColumns="false" GridLines="Both" Skin="XYZ" EnableEmbeddedSkins="false">

 

 

 

<MasterTableView Width="1063px" TableLayout="Fixed" ItemStyle-Font-Names="Arial" ItemStyle-Font-Size="11px" AlternatingItemStyle-Font-Size="11px" AlternatingItemStyle-Font-Names="Arial" HeaderStyle-Font-Names="Arial" HeaderStyle-Font-Size="11px" CommandItemDisplay="None">
<Columns>
<telerik:GridTemplateColumn HeaderText="Name" HeaderStyle-HorizontalAlign="Center" HeaderStyle-CssClass="rgcItemName" ItemStyle-CssClass="rgcItemName">

 

 

 

<ItemTemplate> <%#Container.DataItem("name").ToString%> </ItemTemplate> </telerik:GridTemplateColumn>

 

 

 

</Columns>

 

 

 

 

</MasterTableView>

 

 

 

<ClientSettings><Scrolling AllowScroll="true" UseStaticHeaders="true" /></ClientSettings>

 

</telerik:RadGrid>

 

 

 

</telerik:RadAjaxPanel>

 

VB Page

 

Protected Sub RadGrid1_NeedDataSource(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource

 

GetData()

 

End Sub

 

 

 

 

 

Protected

 

Function GetData() As Object

 

 

 

Dim table2 As New DataTable()

 

 

Dim XYZSql As String

 

 

 

XYZSql = ""

 

 

 

Dim XYZComm As New OracleCommand

 

 

Dim XYZConn As New OracleConnection(SQLConnStr)

 

 

Dim adapter As OracleDataAdapter = New OracleDataAdapter

 

adapter.SelectCommand =

New OracleCommand(XYZSql, XYZConn)

 

XYZConn.Open()

 

Try

 

 

 

adapter.Fill(table2)

 

RadGrid1.DataSource = table2

 

Catch ex As Exception

 

---

 

 

 

 

Finally

 

 

 

XYZConn.Close()

 

XYZConn.Dispose()

OracleConnection.ClearPool(XYZConn)

 

End Try

 

 

Return table2

 

 

End Function

 

 

 

On my Page Init Event all i am doing is RadGrid1.DataSource = Nothing like below code snippet shows. I am not calling Radgrid.ReBind(). But the Data still rebinds.

 

 

 

 

 

Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init

 

 

RadGrid1.DataSource = Nothing

 

End

 

Sub

 

WORKING CASE: Everything works fine so far...grid binds and sorts perfectly......

 

HOWEVER CASE: If i put Radgrid1.Rebind() after RadGrid1.DataSource = Nothing my grid does not sort in proper manner. If try to sort Col 1, col 3 sorts or col 2 sorts. I have no sorting event  other than AllowSorting=True in the aspx page. I absolutely dont have any columns to not be visible. Why Does it not sort well if i have Rebind() method called in Page Init.
I happen to read this topic in the link given below.....
http://www.telerik.com/help/aspnet/grid/grdcommandsthatinvokerebindimplicitly.html


Does NeedDataSource implicitly call Rebind method and sort the grid in WORKING CASE. Where does it store the data and binds it to the grid every time i sort the grid. Does it store in Hard Disc memory? If you are going to give me a link for sorting will it have an answer to the Question i just asked about where does it store the data to bind the grid again and again for each sorting. WORKING CASE does not have a direct call to Rebind.

In my HOWEVER CASE I am making an explicit call to Rebind(). Is it messing up the automatic sorting and the grid does not sort well?

References for Radgrid in Master page looks like.....
<telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager>

 

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

</telerik:RadAjaxManager>

 

Your answer will help me greatly
Vidya

Jayesh Goyani
Top achievements
Rank 2
 answered on 26 Aug 2011
3 answers
100 views
I am trying to display a grid with 3 columns. 2 of the columns are updateable. The problem I am having is when the client does a batch update, I dont want to update every record from the grid to the database. I only want to process just the changed records/cells. It is almost like a hybrid Excel grid project demo and the Telerik ClientEditBatchUpdates demo. I dont want the user to have to click edit on every row so that is why I am using the Excel like demo. Anyone have any experience with this?
Jayesh Goyani
Top achievements
Rank 2
 answered on 26 Aug 2011
1 answer
109 views
Below is a code snippit I found in one of your forums.  It was working fine until I turned on filtering.  Now "id" in gridHeader.childNodes[i].id is null so it fails on ".indexOf".   


function BulkOperationRadGrid_GridCreated(sender, eventArgs) {
    var masterTable = sender.get_masterTableView();
    //check whether all items on the active page are selected    
    if (masterTable.get_selectedItems().length == masterTable.get_pageSize()) {
        /*find the checkbox in the header of the GridClientSelectColumn and set checked state for it - will work with AllowMultiRowSelection = true only!*/
        var gridHeader = masterTable.get_element().getElementsByTagName("TH")[0];
        for (var i = 0; i < gridHeader.childNodes.length; i++) {
            if (gridHeader.childNodes[i].id.indexOf("columnSelectCheckBox") > -1) {
                gridHeader.childNodes[i].checked = "true";
            }
        }
    }
Jayesh Goyani
Top achievements
Rank 2
 answered on 26 Aug 2011
1 answer
136 views
Hi,

Can you tell me how to change the selectedrow color of a rad grid?  I tried changing the selected row forecolor to green but If you look at the attached photo I provided you will see where it is just sitting below the gray background. This is strange...can you take a look at the example I provided?

Thanks,
Ron.
Jayesh Goyani
Top achievements
Rank 2
 answered on 26 Aug 2011
1 answer
99 views
I understand why this is happening, but I'm not sure the best way to handle it.  The postback created when a RadDock is drag & dropped, closed, minimized, etc. is returning the HTML and overwriting the data bound RadGrids that are in the RadDocks within the RadDockZone that the RadDock is in.  I don't want to requery the the web methods to repopulate the grids (kinda defeats the benefit of client-side data binding).

I have AutoPostBack enabled on the docks because I want to continuously persist the position/state of the docks.  Is there anyway I can update the state of the docks via AJAX without doing a partial postback that overwrites my grid data (maybe by calling a WebMethod)?  If so, how?

I've created a simple example page that demonstrates this issue (most controls are dynamically created because this is how the real application is).

Thanks!

*.aspx.vb
Imports Telerik.Web.UI
Imports System.Web.UI.WebControls
Partial Class DockClientDataBoundRadGrid
    Inherits System.Web.UI.Page
    Private _DockDataTable As System.Data.DataTable
 
    Protected Sub RadDockLayout1_LoadDockLayout(ByVal sender As Object, ByVal e As Telerik.Web.UI.DockLayoutEventArgs) Handles RadDockLayout1.LoadDockLayout
        Dim zones(1) As RadDockZone
        Dim zone As RadDockZone
        For i As Integer = 0 To zones.Length - 1
            zone = New RadDockZone
            zone.Orientation = Orientation.Vertical
            zone.ID = "RadDockZone" & i
            zones(i) = zone
        Next
 
        RadDockLayout1.Controls.Add(CreateDockContainer(zones))
 
        For Each zone In zones
            RadAjaxManager1.AjaxSettings.AddAjaxSetting(zone, zone)
        Next
 
        Dim docks(DockDataTable.Rows.Count - 1) As RadDock
        Dim dock As RadDock
        Dim rowCount As Integer = 0
        For Each row As System.Data.DataRow In DockDataTable.Rows
            dock = New RadDock
            dock.AutoPostBack = True
            dock.DockMode = DockMode.Docked
            dock.UniqueName = "dock-" & rowCount
            dock.Title = row.Item("title")
 
            Dim _RadGrid As RadGrid = CreateRadGrid("RadGrid-" & rowCount)
            dock.ContentContainer.Controls.Add(_RadGrid)
 
            RadDockLayout1.Controls.Add(dock)
            docks(rowCount) = dock
            rowCount += 1
 
            RadAjaxManager1.AjaxSettings.AddAjaxSetting(dock.ContentContainer, dock.ContentContainer)
        Next
 
        Dim lastZoneId As Integer = 0
        For Each dock In docks
            If zones.Length <= lastZoneId Then lastZoneId = 0
            zone = zones(lastZoneId)
            e.Indices(dock.UniqueName) = zone.Docks.Count
            e.Positions(dock.UniqueName) = zone.ID
            lastZoneId += 1
        Next
    End Sub
 
    Private Function CreateRadGrid(ByVal ControlID As String) As RadGrid
        Dim _RadGrid As New RadGrid
        _RadGrid.ID = ControlID
        _RadGrid.ClientSettings.ClientEvents.OnCommand = "RadGrid1_DataBinding"
        _RadGrid.ClientSettings.DataBinding.Location = "~/DockClientDataBoundRadGrid.aspx"
        _RadGrid.ClientSettings.DataBinding.SelectMethod = "GetData"
        _RadGrid.ClientSettings.DataBinding.SelectCountMethod = "GetDataCount"
        _RadGrid.ClientSettings.DataBinding.StartRowIndexParameterName = "startRowIndex"
        _RadGrid.ClientSettings.DataBinding.MaximumRowsParameterName = "maxRows"
        _RadGrid.ClientSettings.DataBinding.EnableCaching = True
        _RadGrid.PageSize = 10
 
        Dim c1 As New GridBoundColumn
        c1.HeaderText = "Name"
        c1.SortExpression = "Name"
        c1.DataField = "Name"
        c1.UniqueName = "Name"
        c1.DataType = System.Type.GetType("System.String")
 
        _RadGrid.MasterTableView.Columns.Add(c1)
        Return _RadGrid
    End Function
 
    Protected Function CreateDockContainer(ByRef zones As Telerik.Web.UI.RadDockZone()) As System.Web.UI.WebControls.WebControl
        Dim tbl As System.Web.UI.WebControls.Table = New System.Web.UI.WebControls.Table
        tbl.ID = "tblDockContainer"
        tbl.Style.Add("width", "100%")
 
        Dim row As System.Web.UI.WebControls.TableRow = New System.Web.UI.WebControls.TableRow
        Dim cell As System.Web.UI.WebControls.TableCell
        tbl.Rows.Add(row)
 
        Dim colSize As String = Math.Floor(100 / zones.Length).ToString() & "%"
        For Each zone As Telerik.Web.UI.RadDockZone In zones
            cell = New System.Web.UI.WebControls.TableCell
            cell.VerticalAlign = VerticalAlign.Top
            cell.Controls.Add(zone)
            cell.Style.Add("width", colSize)
            row.Cells.Add(cell)
        Next
 
        Return tbl
    End Function
 
    Protected ReadOnly Property DockDataTable() As System.Data.DataTable
        Get
            If _DockDataTable Is Nothing Then
                _DockDataTable = New System.Data.DataTable
                _DockDataTable.Columns.Add(New System.Data.DataColumn("title", System.Type.GetType("System.String")))
 
                Dim row As System.Data.DataRow
                For i As Integer = 0 To 5
                    row = _DockDataTable.NewRow
                    row("title") = "Dock Title " & i
                    _DockDataTable.Rows.Add(row)
                Next
 
                _DockDataTable.AcceptChanges()
            End If
            Return _DockDataTable
        End Get
    End Property
 
    <System.Web.Services.WebMethod()> _
    Public Shared Function GetData(ByVal startRowIndex As Integer, ByVal maxRows As Integer) As IEnumerable
        Dim list As New Generic.List(Of Entity)
        For i As Integer = startRowIndex To maxRows
            Dim e As New Entity
            e.Name = "Entity " & i
            list.Add(e)
        Next
 
        Return list
    End Function
 
    <System.Web.Services.WebMethod()> _
    Public Shared Function GetDataCount() As Integer
        Return 51
    End Function
 
    Public Class Entity
        Public Name As String
    End Class
End Class

*.aspx
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="DockClientDataBoundRadGrid.aspx.vb" Inherits="DockClientDataBoundRadGrid" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
 
<!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>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"></telerik:RadAjaxManager>
<telerik:RadDockLayout ID="RadDockLayout1" runat="server"></telerik:RadDockLayout>
<telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">
    <script type="text/javascript">
        function RadGrid1_DataBinding(sender, args) {}   
    </script>
</telerik:RadScriptBlock>
</form>
</body>
</html>
Josh
Top achievements
Rank 1
 answered on 26 Aug 2011
0 answers
504 views
Hi,
I've been searching the forums and it looks like this is a common problem. Unfortunately, I cannot find a solution, partly because many of these issues were solved with support tickets, but the forum posts never got the details of the fix.

Can you please give me steps to take to troubleshoot it? What should I be looking at? Because of the time involved to strip the project down, I'd rather not submit my project, just looking for the general direction I should take in my troubleshooting.

Related threads: http://www.telerik.com/community/forums/aspnet-ajax/scheduler/radgrid-inside-scheduler-advanced-edit-insert-form.aspx
AND: http://www.telerik.com/community/forums/aspnet-ajax/scheduler/script-control-radajaxmanager1-is-not-a-registered-script-control.aspx

Thanks in advance,
Dan

<edit>
OK, so I have a RadWindowManager in 2 UserControls that are included in my advanced form. I made it past this error, I set each RadWindowManager and each RadWindow to RegisterWithScriptManager="false".

Unfortunately this brought me to the following error if I trigger an action that should show the RadWindow from the User Control: "Multiple controls with the same ID 'RadWindowManager3_alerttemplate' were found..."

I have everything ajaxified. Googling this error tells me that it is probably because my usercontrol is getting added dynamically more than once. How do I fix this?

Thanks,
Dan

</edit>

<edit2>
Hi, I'm preparing to submit a support ticket.
</edit2>
Dan Lehmann
Top achievements
Rank 1
 asked on 26 Aug 2011
Narrow your results
Selected tags
Tags
+? more
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?