Greets.

We currently have a system in place for creating and maintaining schedules that leverages the built in job and scheduling features of Sql Server.

Sql Server is able to create jobs and schedules very easily and accepts various recurrence parameters and such when creating these tasks.

I'm looking into this right now but I'm wondering how easy it is to integrate the RadScheduler with Sql Server's scheduling system.
Does the recurrence data that we get out of the control easily map to what Sql Server's scheduling system expects?

I want to use RadSchedule to set up an appointment for say Today at Noon. At noon I want Sql Server's job to fire and put some piece of information on some SchedulerTask queue.
I'm wondering if I need to prepare myself to do a lot of custom stuff to translate data from the RadSchedule control in order to have Sql understand that information when creating a scheduled job.

Has anyone tried this?

Dear All,

Hi all

I'm after some help with achieving the following.

I am programmatically creating my RadGrid and it is to contain GridBoundColumns and a GridButtonColumn. The grid button column is to allow for clicking and opening another page. However I would like the ImageUrl for the grid button column to be dependant upon a column value in the datatable. For instance if the value in the column of the row in the datatable is true then show one image but if it is false then show another.

At this point my ascx page looks like so:

<

 

telerik:RadGrid ID="radGrid1" runat="server" OnItemDataBound="DataBoundMethod">

 

 

 

<MasterTableView>

 

 

 

<RowIndicatorColumn>

 

 

 

<HeaderStyle Width="20px"></HeaderStyle>

 

 

 

</RowIndicatorColumn>

 

 

 

<ExpandCollapseColumn>

 

 

 

<HeaderStyle Width="20px"></HeaderStyle>

 

 

 

</ExpandCollapseColumn>

 

 

 

</MasterTableView>

 

 

 

<ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True">

 

 

 

</ClientSettings>

 

</

 

 

telerik:RadGrid>

 

 

My ascx.cs page then includes (amongst other btis of code) the following method where I thought I could do what I wanted

protected

 

void DataBoundMethod(object sender, Telerik.Web.UI.GridItemEventArgs e)

 

{

 

 

    if (e.Item is GridDataItem)

 

    {

 

 

        GridDataItem dataItem = e.Item as GridDataItem;

 

 

 

        
        //Need to do something here to alter the ImageUrl
     }

 

}

Any thoughts on this? If I am going down the wrong road that is ok, I'm fairly new to the Telerik stuff so am still learning. Any help be would be greatly appreciated.

Many thanks

 

Aggregates are blank when binding server-side.

I Have the following GridBoundColumn:

 <telerik:GridBoundColumn Aggregate="Sum" SortExpression="UNIT_PRICE" HeaderText="UNIT_PRICE"
HeaderButtonType="TextButton" DataField="UNIT_PRICE" DataFormatString="{0:$###,###.##}"
FooterAggregateFormatString="TOTAL: {0:C}">
</telerik:GridBoundColumn>

On the server I have.

Protected

 

Sub RadGrid1_DetailTableDataBind(ByVal source As Object, ByVal e As Telerik.Web.UI.GridDetailTableDataBindEventArgs) Handles RadGrid1.DetailTableDataBind

 

 

Dim dataItem As GridDataItem = CType(e.DetailTableView.ParentItem, GridDataItem)

 

 

Dim OrderID As String = dataItem.GetDataKeyValue("WORK_ORDER").ToString()

 

 

Dim openstockDetail As SqlDataReader = DealerOpenStocks.GetOpenStockDetail(OrderID)

 

e.DetailTableView.DataSource = openstockDetail

 

End Sub

 

 

Protected Sub RadPanelBar1_ItemClick(ByVal sender As Object, ByVal e As Telerik.Web.UI.RadPanelBarEventArgs) Handles RadPanelBar1.ItemClick

 

 

Dim openstock As SqlDataReader = DealerOpenStocks.GetOpenStock(e.Item.Text)

 

Radgrid1.DataSource = openstock

RadGrid1.DataBind()

 

'ProductImage.Src = "images/" & e.Item.Text & ".jpg"

 

 

End Sub


Everything works fine except that my footer totals are not showing up. Any ideas?


Below is all the code if needed.

 

<

 

telerik:RadGrid ID="RadGrid1" runat="server" Width="100%" ShowStatusBar="True" AutoGenerateColumns="False"

 

 

ShowFooter="True" GridLines="Horizontal" Skin="Outlook">

 

 

<MasterTableView Width="100%" ClientDataKeyNames="WORK_ORDER" DataKeyNames="WORK_ORDER"

 

 

Name="Master">

 

 

<DetailTables>

 

 

<telerik:GridTableView DataKeyNames="WORK_ORDER" Name="Sub" Width="100%">

 

 

<Columns>

 

 

<telerik:GridBoundColumn SortExpression="WORK_ORDER" HeaderText="WORK_ORDER ID" HeaderButtonType="TextButton"

 

 

DataField="WORK_ORDER">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn SortExpression="PART_ID" HeaderText="PART ID" HeaderButtonType="TextButton"

 

 

DataField="PART_ID">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn SortExpression="DESCRIPTION" HeaderStyle-Width="250px" HeaderText="DESCRIPTION"

 

 

HeaderButtonType="TextButton" DataField="DESCRIPTION" UniqueName="DESCRIPTION">

 

 

<HeaderStyle Width="250px"></HeaderStyle>

 

 

<ItemStyle Width="250px" />

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn Aggregate="Sum" SortExpression="UNIT_PRICE" HeaderText="UNIT_PRICE"

 

 

HeaderButtonType="TextButton" DataField="UNIT_PRICE" DataFormatString="{0:$###,###.##}"

 

 

FooterAggregateFormatString="TOTAL: {0:C}">

 

 

</telerik:GridBoundColumn>

 

 

 

 

</Columns>

 

 

</telerik:GridTableView>

 

 

</DetailTables>

 

 

<Columns>

 

 

<telerik:GridBoundColumn DataField="WORK_ORDER" HeaderText="WORK_ORDER" SortExpression="WORK_ORDER"

 

 

UniqueName="WORK_ORDER">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="DESCRIPTION" HeaderText="DESCRIPTION" SortExpression="DESCRIPTION"

 

 

UniqueName="DESCRIPTION">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="MODEL" HeaderText="MODEL" SortExpression="MODEL"

 

 

UniqueName="MODEL">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="UNIT_PRICE" DataType="System.Decimal" HeaderText="UNIT_PRICE"

 

 

SortExpression="UNIT_PRICE" UniqueName="UNIT_PRICE" DataFormatString="{0:C}">

 

 

</telerik:GridBoundColumn>

 

 

</Columns>

 

 

</MasterTableView>

 

 

<ClientSettings ReorderColumnsOnClient="True" AllowColumnsReorder="True">

 

 

<Selecting AllowRowSelect="True"></Selecting>

 

 

</ClientSettings>

 

 

</telerik:RadGrid>

 

 

 

 

Any estimates on when this bug will be fixed (ie, not searching child nodes)?

Need help!!!

I have the radEditor inside the webpage and when I click on the spellcheck button within Editor, below error shows up..

The webpage runs on a sharepoint 2007 server (MOSS). Not sure anything is different with this/

I have verified the handler within the web.config file

<httpHandlers>
      <!-- Telerik Toolbox handlers -->
      <add path="Telerik.RadUploadProgressHandler.ashx" verb="*" type="Telerik.Web.UI.Upload.RadUploadProgressHandler, Telerik.Web.UI, Version=2009.3.1103.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4" validate="false" />
      <add path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" validate="false" />
      <add path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" validate="false" />
      <add path="Telerik.Web.UI.DialogHandler.axd" type="Telerik.Web.UI.DialogHandler" verb="*" validate="false" />
      <!-- Telerik Toolbox handlers -ENDS HERE -->
 </httpHandlers>

LOCATION DETAILS

 <location path="Telerik.Web.UI.WebResource.axd">
    <system.web>
      <authorization>
        <allow users="*"/>
      </authorization>
    </system.web>
  </location>
  <location path="Telerik.Web.UI.SpellCheckHandler.axd">
    <system.web>
      <authorization>
        <allow users="*"/>
      </authorization>
    </system.web>
  </location>

Under handler section

<handlers>
          <!-- Telerik Controls UI Handlers -->
      <add name="Telerik_Web_UI_SpellCheckHandler_axd" verb="*" preCondition="integratedMode" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" />
      <add name="Telerik_Web_UI_DialogHandler_aspx" verb="*" preCondition="integratedMode" path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" />
      <add name="Telerik.Web.UI.DialogHandler_axd" verb="*" preCondition="integratedMode" path="Telerik.Web.UI.DialogHandler.axd" type="Telerik.Web.UI.DialogHandler" />
      <!-- Telerik Controls UI Handlers - Ends here-->
    </handlers>


----------------------

ERROR

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; MS-RTC LM 8; OfficeLiveConnector.1.4; OfficeLivePatch.1.3)
Timestamp: Fri, 13 Nov 2009 22:01:36 UTC


Message: Sys.ArgumentException: Cannot deserialize. The data does not correspond to valid JSON.
Parameter name: data
Line: 6
Char: 62099
Code: 0
URI: http://rmdev1.development.org/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=ctl00_RadScriptManager1_HiddenField&compress=1&_TSM_CombinedScripts_=%3b%3bSystem.Web.Extensions%2c+Version%3d3.5.0.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d31bf3856ad364e35%3aen-US%3a0d787d5c-3903-4814-ad72-296cea810318%3aea597d4b%3ab25378d2%3bTelerik.Web.UI%2c+Version%3d2009.2.826.35%2c+Culture%3dneutral%2c+PublicKeyToken%3d121fae78165ba3d4%3aen-US%3ad2d891f5-3533-469c-b9a2-ac7d16eb23ff%3ae330518b%3a16e4e7cd%3af7645509%3a24ee1bba%3a1e771326%3ac8618e41%3bTelerik.Web.UI%2c+Version%3d2009.3.1103.35%2c+Culture%3dneutral%2c+PublicKeyToken%3d121fae78165ba3d4%3aen-US%3a4552b812-caf7-4129-9b53-8f199b5bce6c%3a16e4e7cd%3a874f8ea2%3af7645509%3a24ee1bba%3a19620875%3a33108d14%3abd8f85e4%3aed16cbdc%3a11a04f7e%3a1e771326%3ae524c98b%3ae330518b%3ac8618e41%3ae4f8f289%3a39040b5c%3adc7e0bd%3a1569bb5f%3a63b115ed%3ac408cfaa

--------------------

My dictionary files are in APP_DATA\RadSpell\*.tdf

I have used fiddler to check the response but not helped much --

raw response -

POST /Alerts/_layouts/rm/Telerik.Web.UI.SpellCheckHandler.axd HTTP/1.1
Accept: */*
Accept-Language: en-us
Referer: http://rmdev1.development.org/Alerts/_layouts/rm/SendAlertByRole.aspx
Content-Type: application/x-www-form-urlencoded; charset=utf-8
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; MS-RTC LM 8; OfficeLiveConnector.1.4; OfficeLivePatch.1.3)
Host: rmdev1.development.org
Content-Length: 501
Proxy-Connection: Keep-Alive
Pragma: no-cache
Cookie: WSS_KeepSessionAuthenticated=80; ASP.NET_SessionId=hjgw1qyu0oezta45pl43s155; MSOWebPartPage_AnonymousAccessCookie=80
Authorization: Basic VmlqYXlhZG1pbjpWaWpheTEyMw==

DictionaryLanguage=en-US&Configuration=F3FcUiFxLkRWWX86VRAAWFR%2BXzJkKQcyWgYRQHR1OWIjKnpfH2AlB1EEYn5nLgMYJ35XQh9yDFlRY3A6fxIAaWN%2BandvPgd1dFkCampcA1sQdGJPEV0iRVYVQG9iLgcrCAZATxJaKn1tBnc3fRE2UWd%2FVHViA3ASW3MWR29YD1kLdHIFEVolB34GSEN5HCkjIFtUCxJzFHVQBncEfxMUamd%2Fci5hARsKWHI0dG1YJVEQd1BPEXMDD2MXRHVXKQN2E256SwlzGFpWfHcvfAIDQ2ZSXBZVdTEYaloGW1xiF2kRKFx%2FImAcYFJwZmF7dA8xHF1UDBdxBHpiWUkrfQEqX2lUCRJVdTEYamwSaW5xKUI%3D&CommandArgument=%26nbsp%3Bsadf%20asdf%20dsaf%20sf%20sadfds%20f&CommandName=SpellCheck

HTTP/1.1 200 OK
Cache-Control: private
Transfer-Encoding: chunked
Content-Type: text/html; charset=utf-8
Content-Encoding: gzip
Vary: Accept-Encoding
Server: Microsoft-IIS/7.0
X-AspNet-Version: 2.0.50727
SharePointError: 0
Set-Cookie: WSS_KeepSessionAuthenticated=80; path=/
Set-Cookie: MSOWebPartPage_AnonymousAccessCookie=80; expires=Fri, 13-Nov-2009 22:31:27 GMT; path=/
X-Powered-By: ASP.NET
Date: Fri, 13 Nov 2009 22:01:28 GMT

ab0
?

I am attempting to use a BindingList as my datasource as a temporary holding source until I put the data into my SQL database.  Displaying the data works just fine, the problem I am having is actually adding/inserting data.  Here is the flow:

1. I create 10 records on page load, they display fine, the DataSource is assigned in the NeedDataSource event.
2. Using an ASP.NET button, I invoke the RadGrid.MasterTableView.InsertItem() function which loads the default insert template.
3. After putting in the data and clicking the Insert link, the InsertCommand event is fired and I create a new record and add it to my BindingList and call RadGrid.Rebind().
4. The data gets added but the insert template does not go away and if I click on cancel to get it to go away, the data is no longer in the grid.

How can I get the Insert Template to close after I insert an item using the BindingList?

Seth

Hi,

If you have a treeview like below:

+ Parent Node

   +child A

   +child B

   +childC
        - cc

 
when i checked (cc), the (childC) also checked ,  
how do you unchecked (childC)

During OnInit of my page I programmatically create a RadGrid and create the columns to be added to the grid.  Some of the columns being created are GridTemplateColumn's in which I have created my own ITemplate.  The column show up fine and all the GridBonudColumns appear to be sorting, grouping, and filtering fine, however my ITemplate column results in a javascript error: Sys.WebForms.PageRequestManagerServerErrorException; Expression cannot be null or empty.  I'm not sure what I need to do in order for this to work on my Template column.  I looked over the programmatic creation example in the help document but I didn't see anything that I am not doing already.

When I add it to DATABASE I do following

Dim

 

wwctetime1 As Date

wwctetime1=RadDateTimePicker1.Text

cmd.Parameters.Add(

"@wtime1", SqlDbType.Int).Value = Hour(wwctetime1)

Now I want to read from Database and Assigen value back to RadDateTimePicker1

So how I want to do is

 

 

RadDateTimePicker1.SelectedDate = dta.Rows(0)(

"wwctetime1")


In my data base I'm just saving time ex 2, 7, 23,22 etc

 I would really appreciate any help