Telerik Forums
UI for ASP.NET AJAX Forum
6 answers
148 views
I'm trying to present a boolean column from a MySql table graphically with a GridImageColumn.  I added a the GridImageColumn (myauth) and set it to emulate the boolean column (authorized).  (myauth) GroupByExpression="Group By authorized" and SortExpression="authorized". 

This works well, I can click on the (myauth) column header to change the sorting of the column, and I can drag the (myauth) column header to the group panel and group records.  If however I try to click the sort icon on the (myauth) button added to the group panel, then the button is reduced to just a few pixels, and I loose the ability to group, ungroup, or sort by that column or any others on the grid.


<%@ Page Language="Oxygene" AutoEventWireup="true" CodeBehind="Default.aspx.pas" Inherits="RadGridGroupSortTest._Default" %>
<%@ Register Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Namespace="System.Web.UI" TagPrefix="asp" %>
<%@ Register Assembly="Devart.Data.MySql.Web, Version=5.50.79.0, Culture=neutral, PublicKeyToken=09af7300eec23701" Namespace="Devart.Data.MySql.Web" TagPrefix="cc1" %>
<%@ Register Assembly="Telerik.Web.UI, Version=2010.1.519.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
 
 
<head runat="server">
  <title>Untitled Page</title>
</head>
 
<body>
  <form id="form1" runat="server">
  <telerik:RadScriptManager ID="ScriptManager1" runat="server" EnableTheming="True">
  </telerik:RadScriptManager>
  <div>
 
    <cc1:MySqlDataSource ID="MySqlDataSource1" runat="server" ConnectionString="User Id=livewire3server;Password=lw3server;Host=192.168.1.5;Database=livewire3;Persist Security Info=True;"
      OldValuesParameterFormatString="Original_{0}" SelectCommand="select id,sender,receiver,authorized from dummydata_testbank" DeleteCommand="DELETE FROM livewire3.dummydata_testbank WHERE ((id = :Original_id))"
      InsertCommand="INSERT INTO livewire3.dummydata_testbank (sender, receiver, authorized) VALUES (:sender, :receiver, :authorized)" UpdateCommand="UPDATE livewire3.dummydata_testbank SET sender = :sender, receiver = :receiver, authorized = :authorized WHERE ((id = :Original_id))">
      <DeleteParameters>
        <asp:Parameter Name="Original_id" Type="String" />
      </DeleteParameters>
      <UpdateParameters>
        <asp:Parameter Name="sender" Type="String" />
        <asp:Parameter Name="receiver" Type="String" />
        <asp:Parameter Name="authorized" Type="Byte" />
        <asp:Parameter Name="Original_id" Type="String" />
      </UpdateParameters>
      <InsertParameters>
        <asp:Parameter Name="sender" Type="String" />
        <asp:Parameter Name="receiver" Type="String" />
        <asp:Parameter Name="authorized" Type="Byte" />
      </InsertParameters>
    </cc1:MySqlDataSource>
 
    <telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="MySqlDataSource1" GridLines="None" ShowGroupPanel="True">
      <MasterTableView DataKeyNames="id" DataSourceID="MySqlDataSource1">
        <RowIndicatorColumn>
          <HeaderStyle Width="20px"></HeaderStyle>
        </RowIndicatorColumn>
        <ExpandCollapseColumn>
          <HeaderStyle Width="20px"></HeaderStyle>
        </ExpandCollapseColumn>
        <Columns>
          <telerik:GridBoundColumn DataField="id" HeaderText="id" ReadOnly="True" SortExpression="id" UniqueName="id">
          </telerik:GridBoundColumn>
          <telerik:GridBoundColumn DataField="sender" HeaderText="sender" SortExpression="sender" UniqueName="sender">
          </telerik:GridBoundColumn>
          <telerik:GridBoundColumn DataField="receiver" HeaderText="receiver" SortExpression="receiver" UniqueName="receiver">
          </telerik:GridBoundColumn>
          <telerik:GridBoundColumn DataField="authorized" DataType="System.Int16" HeaderText="authorized" SortExpression="authorized" UniqueName="authorized">
          </telerik:GridBoundColumn>
          <telerik:GridImageColumn GroupByExpression="Group By authorized" HeaderText="myauth" SortExpression="authorized" UniqueName="myauth">
          </telerik:GridImageColumn>
        </Columns>
      </MasterTableView>
      <ClientSettings AllowDragToGroup="True">
      </ClientSettings>
    </telerik:RadGrid>
 
  </div>
  </form>
</body>
 
</html>


Raymond Andrews
Top achievements
Rank 1
 answered on 02 Nov 2010
1 answer
101 views
Hi,
I've got a problem with Tooltip on chart bar, i will describe how I use it.
I've got application which uses Telerik popups for showing content (other pages through iframe).

One page contains chart with click able bars and I added tooltip for each bar. I use Telerik tooltip manager.
In general it works fine, but there is one problem which causes only in IE 8. When I maximaze popup, tooltip is not shown.
In IE7, FF, it works fine.

Do you have any idea where could be a problem?
Thanks a lot for answer or suggestions.

Radoslav Robes
Svetlina Anati
Telerik team
 answered on 02 Nov 2010
1 answer
168 views
Hi,

Now RadAjaxLoadingPanel is rendered in browser in main div containing two child divs.One for Image with class raDiv and other to disable page with class raColor raTransp.

Now i have a RadMenu in my page which has default z-index to 7000 now how to set the z-index to div with class raColor raTransp to z-index more than 7000 so that it appears above of RadMenu.

Thanks in advance for helping...
Dimo
Telerik team
 answered on 02 Nov 2010
6 answers
181 views
Hi ,
                 I am using Radupload control for uploading multiple files .
I have set the ControlObjectsVisibility property of upload control as Default" .
So in the upload control there is check box for each file . I just want these check box to
checked by default( it is not checked by default ) . It will be really helpful if there is a way to do that .



Regards,
Sankardeep.V
Associate Software Engineer
Digital Mesh Pvt Limited
Genady Sergeev
Telerik team
 answered on 02 Nov 2010
1 answer
89 views
I have a dataset that is return to my ASPX page to be used by a RadListView Control. 

messageListCurrent.DataSource = LoadData(

True)         'this is the dataset

 

messageListCurrent.DataBind()


Now I need to access the columns and set up the ItemTemplate for RadListView in code, not in design view.  How do I do this????  I can not find any examples of this.
Vasil
Telerik team
 answered on 02 Nov 2010
1 answer
122 views


I have a sample Application with XML as DataSource and followed the example at the link :-
http://www.telerik.com/help/aspnet-ajax/schedule_databindingimplementingaprovider.html

There is MethodName GetAppointments(RadScheduler owner) which has a method in a "Resources" Case known as
LoadAppointmentResources(owner, appointment, appointmentData).

The defintion for LoadAppointmentResources method is not provided anywhere in the example.

Can you please provide it,

Thanks
Shaan
Peter
Telerik team
 answered on 02 Nov 2010
7 answers
330 views
I am trying to use the scheduler to add events on the admin side and then show a read only version of the same scheduler on the public site.  I am trying to setup the scheduler on the admin side first.  I went and looked at the demo site, then went to the documention / help area and read about using a data provider and then Implementing a provider.  I put the code into the web.config, but not sure if I put the following code in the right spot of the web.config.
<telerik.web.ui>
  
<radScheduler defaultAppointmentProvider="Integrated">
      
<appointmentProviders>
          
<add name="XmlSchedulerProvider1"
               
type="Telerik.Web.UI.XmlSchedulerProvider"
               
fileName="~/App_Data/Appointments.xml"
               
persistChanges="true"/>
      
</appointmentProviders>
  
</radScheduler>
</
telerik.web.ui>

Is there a specific section to put the code in.  It doesn't really say in the help section.  also I copied the code from "Implementing a DataProvider" section as well.  I am getting an error in Public Overloads Overrides Sub Initialize sub "config = Nothing".  Error says Operator '=' is not defined for types System.Collections.Specialized.NameValueCollection.   I get another error in the Private Sub EnsureFilePath sub owner.Page = Nothing Operator '=' is not defined for types System.Web.UI.Page.  The last error is in Public Overloads Overrides Function GetAppointments LoadAppointmentResources in not declared.

Not sure where to go from here.  I don't know enough about these errors to try and troubleshoot.  I have copied the code exactly from the VB sections.

I changed 
Public Class MyXmlSchedulerProvider
  Inherits SchedulerProviderBase
 End Class
to XmlScheduleProvider1 as that is what is in the web.config file.

Any help?
Peter
Telerik team
 answered on 02 Nov 2010
9 answers
229 views
Good Day

I have a radSchedular that is Defined like this

  
     
        <telerik:RadScheduler ID="RadScheduler1" runat="server" Height="388px" TimeZoneOffset="03:00:00" 
            SelectedDate="2007-03-30" DayStartTime="08:00:00" DayEndTime="18:00:00" 
            OnDataBound="RadScheduler1_DataBound" 
            Skin="Vista" Width="1006px" DataEndField="ENDDATE" DataKeyField="ID"  
            DataSourceID="XmlDataSource1" DataStartField="STARTDATE"  
            DataSubjectField="SUBJECTS"
        </telerik:RadScheduler> 
     
  
        <asp:XmlDataSource ID="XmlDataSource1" runat="server"  
            DataFile="~/App_Data/TimeTable.xml"></asp:XmlDataSource> 
     


and my XML nodes looks like this

<Root> 
  <Datarow> 
    <ID>1</ID> 
    <DY>25</DY> 
    <SESS>2</SESS> 
    <CODE>CMH10431</CODE> 
    <DESCRIPTION>CMH10431</DESCRIPTION> 
    <ABREV>P</ABREV> 
    <TYPE>P</TYPE> 
    <NUMBER>1</NUMBER> 
    <GRPNAME>V0022012</GRPNAME> 
    <GRPNUMBER>1</GRPNUMBER> 
    <DURATION>1</DURATION> 
    <STUDENTS>1</STUDENTS> 
    <VENUE>V0022012</VENUE> 
    <CAPACITY>50</CAPACITY> 
    <MODLID>641</MODLID> 
    <TERM>Oct2008</TERM> 
    <STAFFTERM>Oct2008</STAFFTERM> 
    <STARTDATE>2008-10-30T17:00:00</STARTDATE> 
    <ENDDATE>2008-10-30T17:00:00</ENDDATE> 
    <LENGTH>180</LENGTH> 
  </Datarow> 
  <Datarow> 
    <ID>2</ID> 
    <DY>1</DY> 
    <SESS>1</SESS> 
    <CODE>PVL101Q1</CODE> 
    <DESCRIPTION>PVL101Q1</DESCRIPTION> 
    <ABREV>P</ABREV> 
    <TYPE>P</TYPE> 
    <NUMBER>1</NUMBER> 
    <GRPNAME>V0022012</GRPNAME> 
    <GRPNUMBER>1</GRPNUMBER> 
    <DURATION>1</DURATION> 
    <STUDENTS>4</STUDENTS> 
    <VENUE>V0022012</VENUE> 
    <CAPACITY>50</CAPACITY> 
    <MODLID>2634</MODLID> 
    <TERM>Oct2008</TERM> 
    <STAFFTERM>Oct2008</STAFFTERM> 
    <STARTDATE>2008-10-06T08:00:00</STARTDATE> 
    <ENDDATE>2008-10-06T08:00:00</ENDDATE> 
    <LENGTH>180</LENGTH> 
  </Datarow> 
</Root> 




and when i run my test app , i get an Error

DataBinding: 'System.Web.UI.WebControls.XmlDataSourceNodeDescriptor' does not contain a property with the name 'ID'.


Thanks
Peter
Telerik team
 answered on 02 Nov 2010
3 answers
82 views
Hi,

I have used Rad Uplaod control in my web application developed using Visual Studio 2005. However i am not able to view the progress details such as progress percentage, estimated time.. etc.  I tried uploading files of size 6 MB. 
Please let me now  whether the upload control will automatically display the details or should i need to manually write code to display the required.

Thanks,
Divya
Genady Sergeev
Telerik team
 answered on 02 Nov 2010
1 answer
63 views
Hi,

I am setting selected dates from a database during the DayRender event.

When I then fire the SelectedDateChange, the selected dates I have added are no there. It will only give me the new dates that have been subsequently selected.

My Code in the DayRender event is:

foreach (DateTime dt in Session["DBBookedDays"] as ArrayList)
        {
            if ((e.Day.Date >= Convert.ToDateTime(jStartDate.Text) && e.Day.Date <= Convert.ToDateTime(jEndDate.Text)) && e.Day.Date.ToShortDateString() == dt.ToShortDateString())
            {
                e.Cell.CssClass = "rcSelected";
                e.Cell.ToolTip = "Already booked in for this job";
                renderedDay.IsSelected = true;
                break;
            }
        }


If I then loop through selected dates on the SelectedDateChange event then this selected date no longer exists.

Thanks in advance
Iana Tsolova
Telerik team
 answered on 02 Nov 2010
Narrow your results
Selected tags
Tags
+? more
Top users last month
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Hiba
Top achievements
Rank 1
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Top users last month
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Hiba
Top achievements
Rank 1
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?