Hi,

I am displaying/inserting/deleting/updating on a RadGrid. Two of the columns are from the two different tables. I am displaying these two columns in Griddropdowncolumn when an insert/edit operations perform.

Table-1(Divisions) columns :   (PK)Division_ID, Division_Name
Table-2(Sections) Columns :   Section_ID, Section_Name, Division_ID(FK)


Table1(Divisions)              Table2(Sections)
----------------------              ----------------------
Mobile  ------------------------>Nokia
            ------------------------>Ericsson
            ------------------------>Samsug
            ------------------------>Motorola

Pens    ------------------------>rotomax
            ------------------------>calibur
            ------------------------>Halliburton

I am able to display all division in Griddropdownand all sections in another GridDropDown.  

What i need is when division mobile is selected, only  values from the mobile sections will have to display.

Please find the following code:
--------------------------------------------------------------------
<div style="text-align: center;">
        <span style="font-family: Arial; font-size: larger;">Resource Information<br />
            <br />
        </span>
        <telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True"
            AllowAutomaticUpdates="True" AllowFilteringByColumn="True" AllowPaging="True"
            AllowSorting="True" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True"
            DataSourceID="SqlDataSource1" GridLines="None" ShowGroupPanel="True" Skin="Vista">
            <MasterTableView AutoGenerateColumns="False" CellSpacing="-1" CommandItemDisplay="TopAndBottom"
                DataKeyNames="Resource_ID" DataSourceID="SqlDataSource1" EditMode="PopUp">
                <RowIndicatorColumn>
                    <HeaderStyle Width="20px" />
                </RowIndicatorColumn>
                <ExpandCollapseColumn>
                    <HeaderStyle Width="20px" />
                </ExpandCollapseColumn>
                <Columns>
                    <telerik:GridBoundColumn DataField="Resource_ID" DataType="System.Int32" HeaderText="Resource_ID"
                        ReadOnly="True" SortExpression="Resource_ID" UniqueName="Resource_ID">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="Resource_Name" HeaderText="Resource_Name" SortExpression="Resource_Name"
                        UniqueName="Resource_Name">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="Resource_Designation" HeaderText="Resource_Designation"
                        SortExpression="Resource_Designation" UniqueName="Resource_Designation">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="Resource_EMail" HeaderText="Resource_EMail" SortExpression="Resource_EMail"
                        UniqueName="Resource_EMail">
                    </telerik:GridBoundColumn>
                    <telerik:GridDropDownColumn DataField="Division_ID" DataSourceID="SqlDataSource2"
                        HeaderText="Division" ListTextField="Division_Name" ListValueField="Division_ID"
                        DataType="System.Int32" UniqueName="UniqueDivisionName">
                    </telerik:GridDropDownColumn>
                    <telerik:GridDropDownColumn DataField="Section_ID" DataSourceID="SqlDataSource3"
                        HeaderText="Section" ListTextField="Section_Name" ListValueField="Section_ID"
                        DataType="System.Int32" UniqueName="UniqueSectionName">
                    </telerik:GridDropDownColumn>
                </Columns>
            </MasterTableView>
            <ClientSettings AllowDragToGroup="True">
            </ClientSettings>
        </telerik:RadGrid><br />
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ResourceUtilizationDBConnectionString %>"
            SelectCommand="SELECT * FROM [Resource_Information]" ConflictDetection="CompareAllValues"
            DeleteCommand="DELETE FROM [Resource_Information] WHERE [Resource_ID] = @original_Resource_ID AND (([Resource_Name] = @original_Resource_Name) OR ([Resource_Name] IS NULL AND @original_Resource_Name IS NULL)) AND (([Resource_Designation] = @original_Resource_Designation) OR ([Resource_Designation] IS NULL AND @original_Resource_Designation IS NULL)) AND (([Resource_EMail] = @original_Resource_EMail) OR ([Resource_EMail] IS NULL AND @original_Resource_EMail IS NULL)) AND (([Division_ID] = @original_Division_ID) OR ([Division_ID] IS NULL AND @original_Division_ID IS NULL)) AND (([Section_ID] = @original_Section_ID) OR ([Section_ID] IS NULL AND @original_Section_ID IS NULL))"
            InsertCommand="INSERT INTO [Resource_Information] ([Resource_Name], [Resource_Designation], [Resource_EMail], [Division_ID], [Section_ID]) VALUES (@Resource_Name, @Resource_Designation, @Resource_EMail, @Division_ID, @Section_ID)"
            OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE [Resource_Information] SET [Resource_Name] = @Resource_Name, [Resource_Designation] = @Resource_Designation, [Resource_EMail] = @Resource_EMail, [Division_ID] = @Division_ID, [Section_ID] = @Section_ID WHERE [Resource_ID] = @original_Resource_ID AND (([Resource_Name] = @original_Resource_Name) OR ([Resource_Name] IS NULL AND @original_Resource_Name IS NULL)) AND (([Resource_Designation] = @original_Resource_Designation) OR ([Resource_Designation] IS NULL AND @original_Resource_Designation IS NULL)) AND (([Resource_EMail] = @original_Resource_EMail) OR ([Resource_EMail] IS NULL AND @original_Resource_EMail IS NULL)) AND (([Division_ID] = @original_Division_ID) OR ([Division_ID] IS NULL AND @original_Division_ID IS NULL)) AND (([Section_ID] = @original_Section_ID) OR ([Section_ID] IS NULL AND @original_Section_ID IS NULL))">
            <DeleteParameters>
                <asp:Parameter Name="original_Resource_ID" Type="Int32" />
                <asp:Parameter Name="original_Resource_Name" Type="String" />
                <asp:Parameter Name="original_Resource_Designation" Type="String" />
                <asp:Parameter Name="original_Resource_EMail" Type="String" />
                <asp:Parameter Name="original_Division_ID" Type="Int32" />
                <asp:Parameter Name="original_Section_ID" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="Resource_Name" Type="String" />
                <asp:Parameter Name="Resource_Designation" Type="String" />
                <asp:Parameter Name="Resource_EMail" Type="String" />
                <asp:Parameter Name="Division_ID" Type="Int32" />
                <asp:Parameter Name="Section_ID" Type="Int32" />
                <asp:Parameter Name="original_Resource_ID" Type="Int32" />
                <asp:Parameter Name="original_Resource_Name" Type="String" />
                <asp:Parameter Name="original_Resource_Designation" Type="String" />
                <asp:Parameter Name="original_Resource_EMail" Type="String" />
                <asp:Parameter Name="original_Division_ID" Type="Int32" />
                <asp:Parameter Name="original_Section_ID" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="Resource_Name" Type="String" />
                <asp:Parameter Name="Resource_Designation" Type="String" />
                <asp:Parameter Name="Resource_EMail" Type="String" />
                <asp:Parameter Name="Division_ID" Type="Int32" />
                <asp:Parameter Name="Section_ID" Type="Int32" />
            </InsertParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ResourceUtilizationDBConnectionString %>"
            SelectCommand="SELECT [Division_ID], [Division_Name] FROM [NSS_Divisions]"></asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ResourceUtilizationDBConnectionString %>"
            SelectCommand="SELECT [Section_ID], [Section_Name] FROM [Division_Sections]"></asp:SqlDataSource>
    </div>
---------------------------------------------------------


Thanks.

Regards
Arshad





              

Hi

I have a question.
For example, my grid have 2 columns ID and Title and radgrid filtering enable. When page load I want filtering Title columns. 

radgrid1.columns..[index]...="My Title";

thank you


 

I have a page set up with a RadAjaxManager in which I have a javascript call that utilizes the ajaxRequest client-side method.  The operation works fine, but upon clicking the link that fires that javascript, the loading panel does not display.  Is the loading panel not supported for a client-side request?

Hello,

I have got a grid. To create its footer I use a PagerTemplate. This is the code of my grid:


I don´t know if you have noticed but pagertemplate is taken from your online demos jeje.

My problem is that tooltips are not shown.

do you know why?

thank you in advance.

HI,

i use the RadTreeView with Checkboxes.

My Problem is the function "treeView.CheckedNodes" because the Return - Object is a IList<RadTreeNode>.

Sample Code:

       

What i need is a RadTreeNodeCollection as result. Let me describe in more detail:
What's important for me is the structure of the TreeView object, but only the selected nodes.

How can I achieve this?

Hi, Iam having a scenario like this

on my webform I am having a combobox, a uploading file control,a Add button and a radGrid(it is having two columns combobox value column and fileNmae) .
In my combobox it is having some values (say A,B and C), I select a value from combobox and against that I browse for a file, after browsing a file when I click on Add button the combox value and the file path which is browsed should appear in radGrid.
How could I achieve this and one more thing one combobox selected value can have multiple files against them.

my source code is as follows :

<p><asp:Label ID="lblDocName" Text="Document Name" runat="server" /></p>
    <p><radG:RadComboBox ID="ddlDocName" runat="server" /></p>
    </div>
    <div>
    <p><asp:Label ID="lblAttachDoc" Text="Attach Document" runat="server" /></p>
    <p><asp:FileUpload ID="uplFileAttach" runat="server" Width="200px" /></p>
    </div>
    </div>
   
   
    <div >
    <asp:Button  ID="btnAdd" Text="Add" runat="server" />
    </div>
   
    
    <div>
    <radG:RadGrid ID="rgDocument" runat="server" Skin="Default" EnableEmbeddedSkins="False" Width="570px"  GridLines="None">
        <MasterTableView>
            <NoRecordsTemplate>
            </NoRecordsTemplate>
            <ExpandCollapseColumn>
                <HeaderStyle Width="20px" />
            </ExpandCollapseColumn>
            <RowIndicatorColumn>
                <HeaderStyle Width="20px" />
            </RowIndicatorColumn>
        </MasterTableView>
     </radG:RadGrid>
    </div>


thanks,

When I set a RadNumericTextbox to showSpinButtons = true, all of a sudden the whole control dissapears when I am in IE8 comatibility view! When select IE7, firefox or IE8 non compatibility view, it works just fine but just that one view!!

What do I need to do??? I am currently using Telerik.Web.UI version 2009.1.402.35. Is this a known issue? When will it be fixed?
Thanks

Hi
i want to bind a datasource to a Griddropdown column but when i bind it , but i face with some error like that reference to null object
here is my Aspx code: and here is my Cs code:
Do u know why?

New to Radgrid and we are doing an evaluation.  We have a table that is approximately 10,000 records, and each record has  approximately 30 fields.  This grid is read only and all of the columns are GridBoundColumns.  It takes approximately 30 secs for the grid to appear, and then it takes it an additional 2-3 secs to redraw.  We have watched the Telerik TV video re optimizing grid performance with only little noticeable increases in peformance.

How can we get the grid to come up faster.

Thanks in advance for a response.

John

Is the R1 version supported yet? I read somewhere that only ASP.NET MVC Beta 1 is supported.

regards
Mathias Fritsch