Telerik Forums
UI for ASP.NET AJAX Forum
3 answers
161 views
Hi all,

I have a RadGrid with a nested table inside. On the main table I have a SqlDataSource with a join clause by which I am trying to retrieve address details from our CRM package, based upon the choice from a GridDropDownColumn. I then need to update a seperate DB with the information.

The datasource details are as follows:

<

 

asp:SqlDataSource ID="SqlDataSource1" runat="server"

 

ConnectionString="<%$ ConnectionStrings:Trident_SLURPConnectionString %>"

 

DeleteCommand="DELETE FROM [Core_Support] WHERE [IssueNumber] = @IssueNumber"

 

InsertCommand="INSERT INTO [Core_Support] ([Customer], [InitialContact], [InitialEngineer], [AddressName], [AddressNumber], [AddressStreet1], [AddressStreet2], [AddressStreet3], [AddressCity], [AddressCounty], [AddressCountry], [AddressPostCode]) VALUES (@Customer, @InitialContact, @InitialEngineer, @AddressName, @AddressNumber, @AddressStreet1, @AddressStreet2, @AddressStreet3, @AddressCity, @AddressCounty, @AddressCountry, @AddressPostCode)"

 

SelectCommand="SELECT * FROM [Core_Support] ORDER BY [IssueNumber]"
SELECT [Address1_Name], [Address1_Line1], [Address1_Line2], [Address1_Line3], [Address1_City], [Address1_County], [Address1_PostalCode], [Address1_Country] FROM Trident_Professional_IT_Services_MSCRM.dbo.Account as CRM

join Core_Support as CS on CS.Customer =CRM.Name"

 

 

 

UpdateCommand="UPDATE [Core_Support] SET [Customer] = @Customer, [InitialContact] = @InitialContact, [InitialEngineer] = @InitialEngineer, [AddressName] = @AddressName, [AddressNumber] = @AddressNumber, [AddressStreet1] = @AddressStreet1, [AddressStreet2] = @AddressStreet2, [AddressStreet3] = @AddressStreet3, [AddressCity] = @AddressCity, [AddressCounty] = @AddressCounty, [AddressCountry] = @AddressCountry, [AddressPostCode] = @AddressPostCode WHERE [IssueNumber] = @IssueNumber">

 

<DeleteParameters>

 

<asp:Parameter Name="IssueNumber" Type="Decimal" />

 

</DeleteParameters>

 

<UpdateParameters>

 

<asp:Parameter Name="Customer" Type="String" />

 

<asp:Parameter Name="InitialContact" Type="String" />

 

<asp:Parameter Name="InitialEngineer" Type="String" />

 

<asp:Parameter Name="AddressName" Type="String" />

 

<asp:Parameter Name="AddressNumber" Type="Int32" />

 

<asp:Parameter Name="AddressStreet1" Type="String" />

 

<asp:Parameter Name="AddressStreet2" Type="String" />

 

<asp:Parameter Name="AddressStreet3" Type="String" />

 

<asp:Parameter Name="AddressCity" Type="String" />

 

<asp:Parameter Name="AddressCounty" Type="String" />

 

<asp:Parameter Name="AddressCountry" Type="String" />

 

<asp:Parameter Name="AddressPostCode" Type="String" />

 

<asp:Parameter Name="IssueNumber" Type="Decimal" />

 

</UpdateParameters>

 

<InsertParameters>

 

<asp:Parameter Name="Customer" Type="String" />

 

<asp:Parameter Name="InitialContact" Type="String" />

 

<asp:Parameter Name="InitialEngineer" Type="String" />

 

<asp:Parameter Name="AddressName" Type="String" />

 

<asp:Parameter Name="AddressNumber" Type="Int32" />

 

<asp:Parameter Name="AddressStreet1" Type="String" />

 

<asp:Parameter Name="AddressStreet2" Type="String" />

 

<asp:Parameter Name="AddressStreet3" Type="String" />

 

<asp:Parameter Name="AddressCity" Type="String" />

 

<asp:Parameter Name="AddressCounty" Type="String" />

 

<asp:Parameter Name="AddressCountry" Type="String" />

 

<asp:Parameter Name="AddressPostCode" Type="String" />

 

</InsertParameters>

 

</asp:SqlDataSource>


I also need the edit form fields which are outlined in the parameters above, to be automatically filled a selection is made in  the GridDropDownBox.

Obviously, it's not working. What am I doing wrong?

:-)

 

 

Georgi Krustev
Telerik team
 answered on 11 May 2009
5 answers
542 views
Hi,

I would like to specify the CssClass of the body tag, which is in the Designer's iframe. I'm using the editor in my CMS's Back-Office, outside of the website. Some of my customers have specified a CssClass on the body tag, and to reproduce the same behavior in the Back-Office, I need to customize the designer's iframe.

I saw that : http://www.telerik.com/help/aspnet-ajax/editor-setting-content-area-defaults.html, but I don't think It matches my needs.

Thanks in advance for reply,
Laurent
Rumen
Telerik team
 answered on 11 May 2009
1 answer
121 views
i have a splitter pane with a vertical splitter bar, i want the left splitter pane to contain a panelbar with the panel bar (set to fullyexpanditem) 

how do i get the panel to be 100% height of the splitterpane, if i set height to 100% it fills more than the size of the explorer window, the splitterpane seems to extend beyond the bottom of the browser window.


thanks
kevin
kmv
Top achievements
Rank 1
 answered on 11 May 2009
3 answers
78 views
Hi,

   In the following example CSS class "bigModule" has been used. http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/editmodes/defaultcs.aspx. Can any tell where this class is located.


Thanks,
Josh.
Dimo
Telerik team
 answered on 11 May 2009
1 answer
119 views
I have successfully saved the dock state into a database, howver this occurs without any user interaction, so the dock state constantly saves even if the user doesn't want to save the state. I have looked through the Examples on the site, however I see nothing about saving the state with a Button Click. For example:

DockName: MyCoolDockLayout
Button: Save 

Database Table: Userid,DockName,DockLayout

I have been trying to Raise the  Telerik.Web.UI.DockLayoutEventArgs with a button click but I get Event Argument Errors. How can I get the DockLayoutEventArgs to pass through a Button Click Event, to then Trigger the RadDockLayout_SaveDockLayout Sub?

Thanks...
Obi-Wan Kenobi
Top achievements
Rank 1
 answered on 11 May 2009
1 answer
76 views
Dear sirs

var BodyObj = document.getElementsByTagName("body")[0];  
 
var CloseButtonElement = document.createElement("input");  
CloseButtonElement.setAttribute("type""button");  
CloseButtonElement.value = "Ok" 
CloseButtonElement.onclick = function() { alert("blabla") };  
 
BodyObj.insertBefore(CloseButtonElement, BodyObj.firstChild); 

I have the following scenario:
After the page got loaded RadFormDecorator is automatically decorating all buttons checkboxes e.t.c

When I add new Buttons with ClientSide JavaScript I need them formatted with the RadFormDecorator as well.

How can I format that newly created button?

I need to Decorate it on the Client Side

Thanks for your help

Chris
Georgi Tunev
Telerik team
 answered on 11 May 2009
1 answer
79 views

function

 

ShowWindow(role){

 

 

var win = window.radopen("~\Help.aspx?role=" + role, "HelpWindow");

 

 

return false;

 

}

"~" not redirecting to the base directory. 
My Help.aspx file is on base directory.How do I browse this page from other directories.

thanks!

Georgi Tunev
Telerik team
 answered on 11 May 2009
1 answer
227 views
Hi,

I have a RadGrid that I bind client-side using data from a call to a WCF web service. The call is done via jQuery. Populating the grid with data works ok. However, I want a server-side SelectedIndexChanged event. I do receive the event, but I get an empty SelectedValue property.

The grid is configured as follows:

<telerik:RadGrid ID="gridEmployees" runat="server" GridLines="None" AutoGenerateColumns="False" 
    AllowMultiRowSelection="False" OnSelectedIndexChanged="gridEmployees_SelectedIndexChanged" 
    ShowHeader="False" AllowPaging="true" PageSize="20"
    <MasterTableView DataKeyNames="EmployeeId"
        <Columns> 
            <telerik:GridNumericColumn DataField="EmployeeId" UniqueName="EmployeeId" Visible="false" /> 
            <telerik:GridBoundColumn DataField="FullName" UniqueName="FullName" /> 
        </Columns> 
    </MasterTableView> 
    <ClientSettings EnablePostBackOnRowClick="true"
        <ClientEvents OnCommand="gridEmployees_Command" OnMasterTableViewCreated="gridEmployees_MasterTableViewCreated" /> 
        <Selecting AllowRowSelect="true" /> 
    </ClientSettings> 
    <PagerStyle Mode="NumericPages" /> 
</telerik:RadGrid> 

I use the following AJAX call via jQuery:

$.ajax({ 
    cache: false
    contentType: "application/x-www-form-urlencoded"
    data: searchData, 
    dataType: "json"
    type: "GET"
    url: "/Services/EmployeeService.svc/FindEmployees"
    success: function(data, textStatus) { 
        var gridEmployees = $find("<%= gridEmployees.ClientID %>"); 
        var employeesTable = gridEmployees.get_masterTableView(); 
        employeesTable.set_dataSource(data.Employees); 
        employeesTable.dataBind(); 
        employeesTable.set_virtualItemCount(data.VirtualItemCount); 
    }, 
}); 

And finally my service. I have left out the FindEmployeesResult class, but it's a simple POCO with the correct DataContract and DataMember attributes.

[ServiceContract(Name="EmployeeService", Namespace="Provisior.Services")] 
[AspNetCompatibilityRequirements( 
    RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)] 
public class EmployeeService 
    [OperationContract] 
    [WebGet(ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Bare)] 
    public FindEmployeesResult FindEmployees(string searchTerm, int startIndex, int maximumRows) 
    { 
        var employees = new List<EmployeeInfo>(); 
        for (int i = 1; i <= 20; i++) 
        { 
            employees.Add(new EmployeeInfo 
                          { 
                              EmployeeId = i, 
                              FullName = "Employee " + i 
                          }); 
        } 
        return new FindEmployeesResult { Employees = employees, VirtualItemCount = 500 }; 
    } 
 

Since the grid has a MasterTableView with DataKeyNames="EmployeeId" and I provide a data source with this property, I would expect the value of EmployeeId to be the SelectedValue of the RadGrid in the gridEmployees_SelectedIndexChanged method. However, it is always empty (to be more precise, it is an instance of System.Object).

How do I make this work as it should?

Kind regards,
Ronald Wildenberg
Georgi Krustev
Telerik team
 answered on 11 May 2009
1 answer
49 views
I built a new dev machine and copied all my projects over to it.  Then I reinstalled Telerik with the newest Q1 2009 release ( I was one version behind ).  I immediately noticed some of my skins weren't working and tried re-adding the Telerik.Web.UI reference thinking that would help but it didn't.  I tried both dll's in the bin and bin35 folder.  Then I found the information about the skinning changes. 

My question is which reference should I be using: the one in the bin folder or the one in bin35?  90% of all my projects are on .net 3.5 but I want to make sure.

Thanks!
Sebastian
Telerik team
 answered on 11 May 2009
3 answers
166 views
Hi,

I need to upgrade the RadControls to Q1 2009 version. Our company's website is DNN based.
Right now we have a DNN module that uses RadScheduler which references an older version of the RadControl dlls.
I have been reading on how to upgrade to Q1 2009. I plan on doing the following. Correct me if I'm wrong.

(Backup everything first)
1. Replace the old dlls with new ones in the bin folder.
2. Copy Telerik.Web.Design.dll into the GAC of our web server manually using GacUtil, and remove the old one if it's there.

That's it, right. Appreciate your help.

Han
Peter
Telerik team
 answered on 11 May 2009
Narrow your results
Selected tags
Tags
+? more
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?