Hi Team,
               I'm using Rad Grid in my application. I need to show my grid as follows. 

Source Column	Lookup Column	Filter Condition	Action
This is Drop down (Dynamic values)	This is Dropdown  (Dynamic values)	This is (static values) Drop down	Edit
This is Dropdown (Dynamic values)	This is Dropdown  (Dynamic values)	This is (static values) Drop down	Edit
This is Drop down (Dynamic values)	This is Dropdown  (Dynamic values)	This is (static values) Drop down	Edit
This is Dropdown (Dynamic values)	This is Dropdown  (Dynamic values)	This is (static values) Drop down	Edit

Each Dynamic Dropdown has different set of values.
aspx coding:

<telerik:RadGrid runat="server" ID="GridRelateColumn" GridLines="None" Skin="Outlook" AllowPaging="true" PageSize="10" OnItemDataBound="GridRelateColumn_ItemDataBound" AutoGenerateColumns="False"> <mastertableview> <Columns>                                                                                                <telerik:GridTemplateColumn headertext="Source Columns" uniquename="SourceColumn">            <itemtemplate>                                                                                                  <asp:DropDownList ID="SourceDropDownList" runat="server” Width="160px"></asp:DropDownList> </itemtemplate>                                                                                         </telerik:GridTemplateColumn>                                                                                        <telerik:GridTemplateColumn headertext="LookUp Columns" uniquename="LookUpColumns"> <itemtemplate>                                                                                                          <asp:DropDownList ID="LookUpDropDownList" Width ="160px"  runat="server"></asp:DropDownList> </itemtemplate> </telerik:GridTemplateColumn>      <telerik:GridTemplateColumn UniqueName="FilterCondition" HeaderText="Filter Condition"> <itemtemplate>                                                                                                 <asp:DropDownList runat="server" Width ="160px" ID="ddlApplicationStatus"></asp:DropDownList> </itemtemplate>                                                                                        </telerik:GridTemplateColumn>                                                                                        <telerik:GridEditCommandColumn HeaderText="Action" UniqueName="EditCommandColumn" /> </Columns> </mastertableview> </telerik:RadGrid> Codebehind coding: protected void GridRelateColumn_ItemDataBound(object sender, GridItemEventArgs e)         {             if (e.Item is GridDataItem)             {                 DataTable dtDDList = new DataTable();                 DataTable dttest = new DataTable();                 string definitionID = string.Empty;                 GridDataItem item = (GridDataItem)e.Item;                 dttest = (DataTable)item.OwnerTableView.DataSource;                 for (int i = 0; i < dttest.Rows.Count; i++)                 {                     definitionID = dttest.Rows[i]["Source Column"].ToString();                     if (definitionID != "" && definitionID != "1")                     {                         DropDownList dDownList = (DropDownList)item.FindControl("SourceDropDownList");                         dtDDList = (DataTable)BLogic.BusinessComponents.RelateColumn.getAllColumnsByDefinitionID(new Guid(definitionID), new Guid(Session["ProjectID"].ToString()));                         dDownList.DataSource = dtDDList;                         dDownList.DataTextField = "ColumnName";                         dDownList.DataValueField = "Selected_Column_GUID";                         dDownList.DataBind();                     }                 }                 for (int j = 0; j < dttest.Rows.Count; j++)                 {                     definitionID = dttest.Rows[j]["Lookup Column"].ToString();                     if (definitionID != "" && definitionID != "1")                     {                         DropDownList dDownList = (DropDownList)item.FindControl("LookUpDropDownList");                         dtDDList = (DataTable)BLogic.BusinessComponents.RelateColumn.getAllColumnsByDefinitionID(new Guid(definitionID), new Guid(Session["ProjectID"].ToString()));                         dDownList.DataSource = dtDDList;                         dDownList.DataTextField = "ColumnName";                         dDownList.DataValueField = "Selected_Column_GUID";                         dDownList.DataBind();                     }                 }             }         }

For Example (please have a look at the below grid) Source Column Lookup Column Filter Condition Action This drop down will show states of US This drop down will show states of Europe This drop down will shows years.(static data) Edit This drop down will show states of Brazil This drop down will show states of India This drop down will shows years.(static data) Edit This drop down will show states of Canada This drop down will show states of Russia This drop down will shows years.(static data) Edit This drop down will show states of China This drop down will show states of Germany This drop down will shows years.(static data) Edit

Please help us as soon as possible. we need the solution or suggestion urgently. Thanks Alexis.

There is strange text, that appears under the content area, when using RadEditor in Firefox modal window (i.e. Window, opened as modal from another window).

The text is:

"RadEditor - please enable JavaScript to use the rich text editor"

Thanks.

Hi, 
By default the uploaded files and the remove option display at the top. I would like to display the uploaded files and the corresponding remove options below or on the right hand side of the Select button control.  How to achieve this?  Attached are the original and desired layout for your reference.

Thanks.

The Expand Icon doesn't change direction when R2L is applied, even though the icon is available in the Grid's sprite.gif.

Is this a confirmed bug? Is there a workaround?

Regards,
Andrew

Dear Telerik,

We have a RadTree that when you click any of its nodes, it opens a RadWindow containing a new dynamic page with a RadGrid, and RadToolbar. In the code behind, we're setting the:
 
radGrid.ClientSettings.ClientEvents.OnGridCreated = "GridCreated";

And in javascript we're setting focus to the grid:

function GridCreated(sender, args) {

     var currentGrid = $find(sender.ClientID);

      var row = currentGrid.get_masterTableView().get_selectedItems()[0];

 

 

      if (row)

 

            currentGrid.set_activeRow(row.get_element());

 

  currentGrid.Control.focus();

}

When you click any tree node, it hides any open window, then tries to locate the corresponding window to show:
1) If no window is found then it opens a new window populating it with a grid, and setting focus to the grid's first row correctly, and we can navigate using the keyboard.
2) If a window is found then it only shows that window, but the grid is losing focus, and we can't use keyboard navigation unless we click on the grid to activate it.

Is there any way to set focus to the grid in the second case above?

We tried to call the currentGrid.Control.focus(); but with no luck, we tried also

currentGrid.get_masterTableView().get_dataItems()[0].get_element().cells[0].focus();

and we could not make the grid to receive focus and we can't navigate using the keyboard.

Can you please help?

Salah A. Malaeb
TeknoBuild

Hi all,
         if i am using two radgrid in a page, when i select a row in 1st grid the corresponding row should get selected in the another 2nd grid. Any assistance would be appreciated.  Thanks.

Hi,

The problem that i am facing is, when i delete one row in grid, i need to do some checking then prompt it alert message in screen.
As i know, when we do deletion in grid, it only can call to code behind 

protected

void radImp_DeleteCommand(object source, Telerik.WebControls.GridCommandEventArgs e)

 

 

{

 

 

    string sOBFPkID = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString();

    Utility.

BaseDelete.DeleteApplFacCollatREImprovement(sOBFPkID);

 

 

 

}
before i delete that record i need to do some checking first,if that record fulfill to my checking then i need to prompt a alert msg in screen.
How can i make it??
Thanks

Hi there.
I have the following grid:

If I turn on the AllowFilteringByColumn property the following error occurs:
Multiple controls with the ID FilterTyexBox_Category found. FindControl requires that controls have unique IDs.

What did I miss?

Hello Admin,
I am a beginner in the web development and need to use telerik radscheduler in our website. I used the radscheduler with sqldatasource control. have been suggested not to use it. So, I want to use custom dataprovider but don't want to customize the advance form. Is it possible?  if yes then Could you please provide the demo project with only custom dataprovider  not the custom advance form? I have gone through some demos on custom dataprovider provided by you on some forums but all have customized advanceform. I also tried to use only custom dataprovider but failed. Also I need to add the Students And Lesson resources at runtime.
My Appointments table contains following fields:
AppointmentId
Subject
Start
[End]
LessonTypeId
InstructorId
CustomerId
RecurrenceRule
RecurenceParentId
Description
IsInactive
IsDelivered
IsEdited
IsDeleted
FlightHours
GroundHours
Comments
------------------------
LessonTypeId , InstructorId, CustomerId are the resources.

Help me.
Please reply as soon as possible.

Thanks in advance,
Roshani

i ran into the problem.
I have a radgrid. I  am using usercontrol to edit/insert new record. 
In usercontrol i have several dropdown, populated from DB.  I neeed to update dropdown list of weatherstation based on selected state. Well, not sure why, but event firing once i click cancel/insert button. I need it to be fired when i am still in the insert/edit mode. I s this possible?

<

 

 

cc1:TabPanel ID ="locationsTab" runat="server" HeaderText="Locations">

 

 

 

<HeaderTemplate>Locations</HeaderTemplate>

 

 

 

<ContentTemplate>

 

 

 

<asp:UpdatePanel id="updPnlLoc" runat="server">

 

 

 

<ContentTemplate>

 

 

 

<asp:SqlDataSource SelectCommand="SELECT locations.id, locations.name, locations.weather_station_id, projects.project_code, locations.project_id, CAST(locations.project_id AS varchar(5)) + ':' + projects.name AS project_ids, projects.description, weather_station.station_name FROM projects INNER JOIN locations ON projects.id = locations.project_id left outer JOIN weather_station ON locations.weather_Station_id= weather_station.id"

 

 

 

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

 

 

 

ID="LocationSource" runat="server" DeleteCommand="usp_crud_locations"

 

 

 

 

UpdateCommand="usp_crud_locations" EnableViewState="False"

 

 

 

 

DeleteCommandType="StoredProcedure" InsertCommand="usp_crud_locations"

 

 

 

 

InsertCommandType="StoredProcedure" UpdateCommandType="StoredProcedure">

 

 

 

<DeleteParameters>

 

 

 

<asp:ControlParameter ControlID="RadGrid1" Name="id"

 

 

 

 

PropertyName="SelectedValue" />

 

 

 

<asp:Parameter DefaultValue="3" Name="op" Type="Int32" />

 

 

 

</DeleteParameters>

 

 

 

<UpdateParameters>

 

 

 

<asp:Parameter Name="op" DefaultValue="2" Type="Int32" />

 

 

 

<asp:Parameter DefaultValue="" Name="name" />

 

 

 

<asp:Parameter Name="weather_stat" />

 

 

 

<asp:Parameter Name="id" />

 

 

 

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

 

 

 

</UpdateParameters>

 

 

 

<InsertParameters>

 

 

 

<asp:Parameter DefaultValue="1" Name="op" Type="Int32" />

 

 

 

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

 

 

 

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

 

 

 

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

 

 

 

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

 

 

 

</InsertParameters>

 

 

 

</asp:SqlDataSource>

 

 

 

 

<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="LocationSource"

 

 

 

 

GridLines="None" ShowGroupPanel="false" Skin="Outlook" ShowStatusBar="True"

 

 

 

 

onitemcommand="RadGrid1_ItemCommand"

 

 

 

 

onupdatecommand="RadGrid1_UpdateCommand" AllowAutomaticDeletes="True"

 

 

 

 

AllowAutomaticInserts="True" AllowAutomaticUpdates="True"

 

 

 

 

onitemupdated="RadGrid1_ItemUpdated" ShowFooter="true"

 

 

 

 

oninsertcommand="RadGrid1_InsertCommand"

 

 

 

 

onitemdeleted="RadGrid1_ItemDeleted"

 

 

 

 

oniteminserted="RadGrid1_ItemInserted"

 

 

 

 

onitemcreated="RadGrid1_ItemCreated" onitemdatabound="RadGrid1_ItemDataBound" >

 

 

 

 

<MasterTableView AutoGenerateColumns="False" DataKeyNames="id" CommandItemDisplay="Top"

 

 

 

DataSourceID="LocationSource" GroupLoadMode="server" InsertItemDisplay="Top" AllowAutomaticInserts="true">

 

 

 

 

<CommandItemSettings ShowRefreshButton="false" ShowAddNewRecordButton="true" AddNewRecordImageUrl="img/buttons/add.png" AddNewRecordText="Add new location" />

 

 

 

 

 

 

<GroupByExpressions>

 

 

 

<telerik:GridGroupByExpression>

 

 

 

<SelectFields>

 

 

 

<telerik:GridGroupByField FieldAlias="ProjectIDs" FieldName="project_ids"

 

 

 

 

HeaderValueSeparator=" " />

 

 

 

</SelectFields>

 

 

 

<GroupByFields>

 

 

 

<telerik:GridGroupByField FieldAlias="project_ids" FieldName="project_ids"

 

 

 

 

SortOrder="Ascending" />

 

 

 

</GroupByFields>

 

 

 

</telerik:GridGroupByExpression>

 

 

 

</GroupByExpressions>

 

 

 

 

 

 

<RowIndicatorColumn>

 

 

 

<HeaderStyle Width="20px" />

 

 

 

</RowIndicatorColumn>

 

 

 

 

 

 

 

<Columns>

 

 

 

<telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn">

 

 

 

 

</telerik:GridEditCommandColumn>

 

 

 

<telerik:GridBoundColumn DataField="id" DataType="System.Int32" HeaderText="id"

 

 

 

 

ReadOnly="True" SortExpression="id" UniqueName="id">

 

 

 

</telerik:GridBoundColumn>

 

 

 

<telerik:GridTemplateColumn HeaderText=project_id EditFormColumnIndex=0 UniqueName="project_id" Visible="false" >

 

 

 

<ItemTemplate >

 

 

 

<asp:Label runat="server" ID="project_idL" Text='<%# Eval("project_id") %>'

 

 

 

 

Visible="False"/>

 

 

 

</ItemTemplate>

 

 

 

 

</telerik:GridTemplateColumn>

 

 

 

<telerik:GridBoundColumn DataField="project_id" DataType="System.Int32"

 

 

 

 

HeaderText="project_id" SortExpression="project_id" UniqueName="project_id" ReadOnly="True"

 

 

 

Visible="false">

 

 

 

</telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn DataField="project_ids" DataType="System.Int32"

 

 

 

 

HeaderText="project_ids" SortExpression="project_ids" UniqueName="project_ids" ReadOnly="True"

 

 

 

Visible="false">

 

 

 

</telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn EditFormColumnIndex="0" DataField="name" HeaderText="name"

 

 

 

 

SortExpression="name" UniqueName="name" ColumnEditorID="GridTextBoxColumnEditor1">

 

 

 

<ItemStyle Width="200px" />

 

 

 

 

<HeaderStyle Width="200px" />

 

 

 

</telerik:GridBoundColumn>

 

 

 

 

<telerik:GridTemplateColumn HeaderText="Weather Station" EditFormColumnIndex ="0" UniqueName="weather_stat" ColumnEditorID="GridDropDownColumnEditor1" >

 

 

 

 

<ItemTemplate>

 

 

 

<asp:Label ID="Label6" runat="server" Text='<%# Eval("station_name") %>'></asp:Label>

 

 

 

</ItemTemplate>

 

 

 

</telerik:GridTemplateColumn>

 

 

 

<telerik:GridBoundColumn DataField="project_code" HeaderText="project_code"

 

 

 

 

SortExpression="project_code" UniqueName="project_code" ReadOnly="True">

 

 

 

</telerik:GridBoundColumn>

 

 

 

<telerik:GridBoundColumn DataField="description" HeaderText="description"

 

 

 

 

SortExpression="description" UniqueName="description" Visible="false" ReadOnly="True">

 

 

 

</telerik:GridBoundColumn>

 

 

 

<telerik:GridButtonColumn ConfirmText="Delete this location?" ConfirmDialogType="RadWindow"

 

 

 

ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete"

 

 

 

UniqueName="DeleteColumn">

 

 

 

<ItemStyle HorizontalAlign="Center" />

 

 

 

</telerik:GridButtonColumn>

 

 

 

</Columns>

 

 

 

 

<EditFormSettings UserControlName="ProjectEcms.ascx" EditFormType="WebUserControl" CaptionFormatString="Edit properties of Location {0}" >

 

 

 

<EditColumn UniqueName="EditCommandColumn1">

 

 

 

 

</EditColumn>

 

 

 

 

</EditFormSettings>

 

 

 

</MasterTableView>

 

 

 

<ClientSettings AllowDragToGroup="False">

 

 

 

</ClientSettings>

 

 

 

 

</telerik:RadGrid>

 

 

 

 

<telerik:GridTextBoxColumnEditor ID="GridTextBoxColumnEditor1" runat="server" TextBoxStyle-Width="200px" />

 

 

 

<telerik:GridTextBoxColumnEditor ID="GridDropDownColumnEditor1" runat="server" TextBoxStyle-Width="350px" />

 

 

 

</ContentTemplate>

 

 

 

</asp:UpdatePanel>

 

 

 

</ContentTemplate>

 

 

 

</cc1:TabPanel>

 

<%

 

@ Control Language="C#" AutoEventWireup="true" CodeFile="projectEcms.ascx.cs" Inherits="projectEcms" %>

 

 

<%

 

@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

 

<

 

 

style type="text/css">

 

 

 

.style1

 

{

 

 

font-weight: bold;

 

 

 

 

font-style: italic;

 

 

 

 

color: #000099;

 

 

}

 

 

 

.style2

 

{

 

 

height: 39px;

 

 

}

</

 

 

style>

 

 

 

 

 

<asp:SqlDataSource ID="LProjectsSource" runat="server"

 

 

 

 

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

 

 

 

 

 

 

SelectCommand="select id as project_id, isnull(project_code,'')+ '|'+ name as Name from dbo.projects

 

 

union all select null, null">

 

 

</asp:SqlDataSource>

 

 

 

<asp:SqlDataSource ID="WeatherStationSource" runat="server"

 

 

 

 

ConnectionString="<%$ ConnectionStrings:ECMApp3 %>" SelectCommand="select null id, null station_name

 

 

union

 

SELECT id, [station_name] FROM [weather_station] where state=@state">

 

<

 

 

SelectParameters>

 

 

<

 

 

asp:ControlParameter ControlID="StateDropDownList" Direction="Input" Name="state" Type="String" />

 

</

 

 

SelectParameters>

 

 

</

 

 

asp:SqlDataSource>

 

 

<

 

 

asp:SqlDataSource id="States" runat="server" ConnectionString="<%$ ConnectionStrings:ECMApp3 %>" SelectCommand="select distinct state from weather_Station order by state"

 

/>

 

 

<

 

 

table id="TableSensor" cellspacing="2" cellpadding="1" width="400px" border="1" rules="none"

 

 

 

style="BORDER-COLLAPSE: collapse">

 

 

 

<tr>

 

 

 

<td> <asp:Label Text="Project_id :" runat="server" ID="Label1" CssClass="style1" />

 

 

 

</td>

 

 

 

<td>

 

 

 

 

<asp:DropDownList ID="DropDownListprojects" runat="server"

 

 

 

 

DataSourceID="LProjectsSource" DataTextField="Name"

 

 

 

 

DataValueField="project_id" Width="250px" >

 

 

 

</asp:DropDownList>

 

 

 

 

</td>

 

 

 

<td>&nbsp;</td>

 

 

 

<td>

 

 

 

&nbsp;</td>

 

 

 

</tr>

 

 

 

<tr>

 

 

 

<td> <asp:Label Text="Name :" runat="server" ID="Label3" CssClass="style1" />

 

 

 

</td>

 

 

 

<td>

 

 

 

 

<asp:TextBox ID="Name" runat="server"

 

 

 

 

Text='<%# DataBinder.Eval( Container, "DataItem.name" ) %>'></asp:TextBox>

 

 

 

 

</td>

 

 

 

<td>&nbsp;</td>

 

 

 

<td>

 

 

 

&nbsp;</td>

 

 

 

</tr>

 

 

 

<tr>

 

 

 

<td> <asp:Label Text="State:" runat="server" ID="Label5" CssClass="style1" />

 

 

 

</td>

 

 

 

<td>

 

 

 

 

<asp:DropDownList ID="StateDropDownList" runat="server"

 

 

 

 

DataSourceID="States" DataTextField="state" DataValueField="state"

 

 

 

 

Width="150px" onselectedindexchanged="StateDropDown_SelectedIndexChanged" >

 

 

 

</asp:DropDownList>

 

 

 

 

</td>

 

 

 

<td>&nbsp;</td>

 

 

 

<td>

 

 

 

&nbsp;</td>

 

 

 

</tr>

 

 

 

<tr>

 

 

 

<td class="style2"> <asp:Label Text="WeatherStation:" runat="server" ID="Label7"

 

 

 

 

CssClass="style1" />

 

 

 

</td>

 

 

 

<td class="style2">

 

 

 

 

<asp:DropDownList ID="DropDownListweatherStations" runat="server"

 

 

 

 

DataSourceID="WeatherStationSource" DataTextField="station_name"

 

 

 

 

DataValueField="id" Width="250px" >

 

 

 

</asp:DropDownList>

 

 

 

 

</td>

 

 

 

<td class="style2">&nbsp;</td>

 

 

 

<td class="style2">

 

 

 

&nbsp;</td>

 

 

 

</tr>

 

 

 

 

<tr>

 

 

 

<td align="right" colspan="2">

 

 

 

<asp:button id="btnUpdate" text="Update" runat="server" CommandName="Update" Visible='<%# !(DataItem is Telerik.Web.UI.GridInsertionObject) %>'></asp:button>

 

 

 

<asp:button id="btnInsert" text="Insert" runat="server" CommandName="PerformInsert" Visible='<%# DataItem is Telerik.Web.UI.GridInsertionObject %>'></asp:button>

 

 

 

&nbsp;

 

 

 

<asp:button id="btnCancel" text="Cancel" runat="server" causesvalidation="False" commandname="Cancel"></asp:button></td>

 

 

 

</tr>

 

 

 

<tr>

 

 

 

<td align="right" colspan="2">

 

 

 

&nbsp;</td>

 

 

 

</tr>

 

</

 

 

table>