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.
html, body, form
{
height
:
100%
;
margin
:
0px
;
padding
:
0px
;
overflow
:
hidden
;
}
<
script
type
=
"text/javascript"
src
=
"http://code.jquery.com/jquery-latest.js"
/>