ASPX:
<telerik:RadChart ID="chrtSiteCompleted" runat="server" Width="400px" Height="400px" Skin="LightBlue" AutoLayout="true" SeriesOrientation="Vertical"> <ChartTitle> <TextBlock Visible="false"></TextBlock> </ChartTitle> <Legend Visible="false"></Legend> <Appearance Corners="Round,Round,Round,Round,7"></Appearance> <PlotArea> <Appearance Corners="Round,Round,Round,Round,7"></Appearance> </PlotArea> <Series> <telerik:ChartSeries Name="Complete Sites per Day" Type="Line"> <Appearance></Appearance> <Items> </Items> </telerik:ChartSeries> </Series> <ClientSettings EnableZoom="false" ScrollMode="XOnly" XScale="2" /> </telerik:RadChart>
Code Behind:
//Get Sites Completed per day DataSet dsCompleteSites = Customer.GetCompleteSitesDay(); chrtSiteCompleted.DataSource = dsCompleteSites; chrtSiteCompleted.Series[0].DataYColumn = "CntPerday"; chrtSiteCompleted.PlotArea.XAxis.DataLabelsColumn = "DateCompleted"; chrtSiteCompleted.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = -45; chrtSiteCompleted.PlotArea.XAxis.Appearance.LabelAppearance.Position.AlignedPosition = AlignedPositions.Left; chrtSiteCompleted.DataBind();
I have a 2 list boxes on a page the master list box is loaded from code behind. I have a second list box on the page which I want populated dynamically. I have a sqldatasource which calls an parameterized sql strored procedure to load the data. The control parameter is tied to a text box on the page. Each time a item or series of items are selected from my first radio list, it populates the textbox with the item values and that in turn should call the sproc with the values as a parameter to load into the second list box. It works in theory J, but I’m having a problem loading my second list box. I really don’t want to have the form post back, because it’s not very optimized even with the ajax controls that can give the same effect as it not posting back. Any help would be greatly appreciated.
Below is an example of the scenario that I have.
<telerik:RadTextBox ID="txtMerch" runat="server" Visible="true"> </telerik:RadTextBox>
<telerik:RadListBox ID="RadListBox1" runat="server" Height="200px" Skin="Forest" CheckBoxes="true" Width="200px" AutoPostBack="false" OnClientItemChecked="onItemChecked" OnClientItemChecking="onItemChecking" >
</telerik:RadListBox>
<telerik:RadListBox ID="RadListBox2" runat="server" DataSourceID="SqlDataSource2"
DataKeyField="mykey" DataTextField="Locations" Height="200px" Skin="Forest" AllowAutomaticUpdates="true" AutoPostBack="false"
CheckBoxes="true" Width="200px">
</telerik:RadListBox>
<asp:SqlDataSource ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:MyConnectstring %>"
runat="server"
SelectCommand= "[dbo].[RptMgr_GetLocations]"
ProviderName="<%$ ConnectionStrings:MyConnectstring.ProviderName %>"
SelectCommandType="StoredProcedure" DataSourceMode="DataReader">
<SelectParameters>
<asp:ControlParameter ControlID="txtMerch" Name="merch"
PropertyName="Text" Type="String" />
<asp:Parameter Direction="ReturnValue" Name="RETURN_VALUE" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>

<telerik:RadGrid ID="rdgrdChargeType" runat="server" AutoGenerateColumns="false" OnPreRender="rdgrdChargeType_PreRender" OnDetailTableDataBind="rdgrdChargeType_DetailTableDataBind" Width="999px" AllowSorting="True" Skin="Office2007" OnItemDataBound="rdgrdChargeType_ItemDataBound" OnNeedDataSource="rdgrdChargeType_NeedDataSource"> <MasterTableView DataKeyNames="ID" Width="100%" EditMode="InPlace" HierarchyLoadMode="Client" HierarchyDefaultExpanded="false" Name="Master"> <DetailTables> <telerik:GridTableView AutoGenerateColumns="false" Width="100%" Name="Detail"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="ID" MasterKeyField="ID" /> </ParentTableRelation> <Columns> <telerik:GridTemplateColumn UniqueName="Auxillarymeterdatatype" HeaderText="Auxilliary Meter Data Name" HeaderStyle-Width="50px"> <ItemTemplate> <telerik:RadComboBox ID="rdCmbBxAuxillarymeterdatatype" runat="server"> </telerik:RadComboBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="Values" HeaderText="Values" HeaderStyle-Width="50px"> <ItemTemplate> <asp:TextBox ID="txtValue" runat="server" /> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="Units" HeaderText="Units" HeaderStyle-Width="50px"> <ItemTemplate> <telerik:RadComboBox ID="rdCmbBxUnits" runat="server"> </telerik:RadComboBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="Comments" HeaderText="Comments" HeaderStyle-Width="50px"> <ItemTemplate> <asp:TextBox ID="txtComments" runat="server" /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> <NoRecordsTemplate> <div style="text-align: center"> No records to display. </div> </NoRecordsTemplate> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridTemplateColumn UniqueName="ChargeType" HeaderText="Meter Data Type" HeaderStyle-Width="100px"> <ItemTemplate> <telerik:RadComboBox ID="rdCmbBxChargeType" AutoPostBack="true" runat="server" Width="100px" OnSelectedIndexChanged="rdCmbBxChargeType_SelectedIndexChanged"> </telerik:RadComboBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="Startdate" HeaderText="Start Date" HeaderStyle-Width="100px"> <ItemTemplate> <telerik:RadDatePicker ID="radFromDate" runat="server" Skin="Office2007" SelectedDate='<%# Eval("StartDate") %>' SharedCalendarID="sharedCalendar" Width="100px" DateInput-DateFormat="MMM dd,yyyy" /> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="Enddate" HeaderText="End Date" HeaderStyle-Width="100px"> <ItemTemplate> <telerik:RadDatePicker ID="radToDate" runat="server" Skin="Office2007" SelectedDate='<%# Eval("EndDate") %>' SharedCalendarID="sharedCalendar" Width="100px" DateInput-DateFormat="MMM dd,yyyy" /> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="Days" HeaderText="Days" HeaderStyle-Width="40px"> <ItemTemplate> <asp:TextBox ID="txtDays" runat="server" Text='<%# Eval("Days") %>' Width="40px"></asp:TextBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="Value" HeaderText="Value" HeaderStyle-Width="40px"> <ItemTemplate> <asp:TextBox ID="txtValue" runat="server" Text='<%# Eval("Value") %>' Width="40px"></asp:TextBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="Units" HeaderText="Units" HeaderStyle-Width="100px"> <ItemTemplate> <telerik:RadComboBox ID="rdMeterDataUnits" runat="server" Width="100px"> </telerik:RadComboBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="Estimated" HeaderText="Estimated(Read)" HeaderStyle-Width="70px"> <ItemTemplate> <asp:CheckBox ID="chkEstimated" runat="server" Checked='<%# Eval("Estimated") == null ? false : Eval("Estimated") %>' Width="30px" /> </ItemTemplate> <ItemStyle HorizontalAlign="Center" /> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="Comments" HeaderText="Comments"> <ItemTemplate> <asp:TextBox ID="txtComments" runat="server" Width="100%" Text='<%# Eval("Comments") %>' /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> <ClientSettings EnableRowHoverStyle="true"> <ClientEvents /> </ClientSettings> <HeaderStyle HorizontalAlign="Center" /> </telerik:RadGrid>
this code is working fine for master table view databound.
i have one event for binding detail table in that i added individual data source for each row detail table bound
here i have a problem in detail table i have radcombobox in item template it need to bind aftercalling need
data source in detail table. i written code in itemdatabound event for mastertable view as follows
if ((e.Item is GridDataItem) && (e.Item.OwnerTableView.Name == "Detail"))
{
GridDataItem item = (GridDataItem)e.Item;
item.findcontrol("<control id of any detail table example radcombox id in detail table>")//returns null
}
but this code wont work for me. i am not able to find control over there.
can any one suggest code for me to identify detail table controls in detail table item databound event.