or
<radScheduler defaultAppointmentProvider="Integrated">
<appointmentProviders>
<add name="ReadOnlySchedulerData" type="Telerik.Web.Examples.Scheduler.MyDbSchedulerProvider"
connectionStringName="TelerikConnectionString"
persistChanges="true" />
</appointmentProviders>
</radScheduler>
</telerik.web.ui>
Please give a sample for how to get data from database and display using radshedular. Please give me full sample code and how to display.
Thanks,
Dhamu.
<telerik:RadGrid ID="grdWebForm" CssClass="infoDisplayGrid" runat="server" Skin="Office2007" AllowPaging="true" OnPageIndexChanged="grdWebForm_PageIndexChanged" OnPageSizeChanged="grdWebForm_OnPageSizeChanged" PageSize="25" AllowSorting="true" OnSortCommand="grdWebForm_SortCommand" OnNeedDataSource="grdWebForm_NeedDataSource" OnItemDataBound="grdWebForm_ItemDataBound" AutoGenerateColumns="false" OnUpdateCommand="grdWebForm_UpdateCommand" OnDeleteCommand="grdWebForm_DeleteCommand" OnInsertCommand="grdWeForm_InsertCommand" OnPreRender="grdWebForm_PreRender"> <PagerStyle AlwaysVisible="true" /> <MasterTableView DataKeyNames="RTFieldQCId" EditMode="InPlace" CommandItemDisplay="Top"> <Columns> <telerik:GridDropDownColumn UniqueName="FullName" HeaderText="Tech Name" DataField="TechId" ListValueField="TechId" ListTextField="FullName" DropDownControlType="DropDownList"></telerik:GridDropDownColumn> <telerik:GridBoundColumn UniqueName="LegacyMeterSerial" SortExpression="LegacyMeterSerial" HeaderText="Legacy Meter #" DataField="LegacyMeterSerial"></telerik:GridBoundColumn> <telerik:GridDateTimeColumn UniqueName="QCDate" PickerType="DatePicker" HeaderText="Date" DataField="QCDate" DataFormatString="{0:MM/dd/yyyy}" EditDataFormatString="MMMM dd"> <ItemStyle Width="120px" /> </telerik:GridDateTimeColumn> <telerik:GridNumericColumn UniqueName="Score" SortExpression="Score" HeaderText="Score" DataField="Score" ColumnEditorID="GridNumericColumnEditor1"></telerik:GridNumericColumn> <telerik:GridNumericColumn UniqueName="MaxScore" SortExpression="MaxScore" HeaderText="Max Score" DataField="MaxScore" ColumnEditorID="GridNumericColumnEditor1"></telerik:GridNumericColumn> <telerik:GridBoundColumn UniqueName="Action" SortExpression="Action" HeaderText="Action" DataField="Action"> </telerik:GridBoundColumn> <telerik:GridEditCommandColumn UpdateText="Update" UniqueName="EditCommandColumn" CancelText="Cancel" EditText="Edit"> <HeaderStyle Width="85px"></HeaderStyle> </telerik:GridEditCommandColumn> <telerik:GridButtonColumn UniqueName="DeleteColumn" Text="Delete" CommandName="Delete" /> </Columns> </MasterTableView> </telerik:RadGrid> <telerik:GridNumericColumnEditor ID="GridNumericColumnEditor1" runat="server"> <NumericTextBox MaxLength="4" EmptyMessage="Ext." runat="server"> <NumberFormat GroupSeparator="," /> </NumericTextBox> </telerik:GridNumericColumnEditor>protected void grdWebForm_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { //if (rt_table != string.Empty) //{ grdWebForm.DataSource = GetWebFormData(); //} } protected void grdWebForm_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridEditableItem && e.Item.IsInEditMode) { GridEditableItem editedItem = e.Item as GridEditableItem; GridEditManager editMan = editedItem.EditManager; GridDropDownColumnEditor editor = editMan.GetColumnEditor("FullName") as GridDropDownColumnEditor; List<TechInfo> techList = BuildTechSelectLists(false); editor.DataSource = techList; // BuildTechSelectLists(false); editor.DataTextField = "FullName"; editor.DataValueField = "UserId"; editor.DataBind(); } if (e.Item is GridDataItem) { GridDataItem item = (GridDataItem)e.Item; DataRowView row = (DataRowView)e.Item.DataItem; item["FullName"].Text = row["FullName"].ToString(); } } public DataTable GetWebFormData() { SqlConnection connection = new SqlConnection( ConfigurationManager.ConnectionStrings["ProFieldMeter"].ConnectionString); DataTable dt = new DataTable(); string strquery = "Select qc.RTFieldQCID,qc.TechId,qc.LegacyMeterSerial,qc.QCDate,qc.Score,qc.MaxScore,qc.Attachment,qc.Action, u.Lastname + ', ' + u.FirstName as FullName FROM RTFieldQC qc left join ProFieldCore.dbo.ProfieldUser u on qc.TechId = u.UserId"; SqlDataAdapter adapter = new SqlDataAdapter(strquery, connection); adapter.Fill(dt); return dt; }<EditFormSettings ColumnNumber="2" CaptionDataField="Plaintiffs" CaptionFormatString="Edit Single Record {0}" InsertCaption="New Product"> <FormTableItemStyle Wrap="False"></FormTableItemStyle> <FormCaptionStyle CssClass="EditFormHeader"></FormCaptionStyle> <FormMainTableStyle GridLines="None" CellSpacing="0" CellPadding="3" BackColor="White" Width="100%" /> <FormTableStyle CellSpacing="0" CellPadding="2" Height="110px" BackColor="White" /> <FormTableAlternatingItemStyle Wrap="False"></FormTableAlternatingItemStyle> <EditColumn ButtonType="PushButton" UpdateText="Update record" UniqueName="EditCommandColumn1" CancelText="Cancel edit"> </EditColumn> <FormTableButtonRowStyle HorizontalAlign="Right" CssClass="EditFormButtonRow"></FormTableButtonRowStyle> </EditFormSettings> 
<telerik:RadChart ID="RadChart3" runat="server" DefaultType="StackedBar100" SeriesOrientation="Horizontal" ChartImageFormat="Jpeg" DataSourceID="AccessDataSource4" Skin="BabyBlue" Width="500px"> <Appearance> <FillStyle MainColor="239, 255, 254"> </FillStyle> <Border Color="188, 229, 231" Width="8" /> </Appearance> <Series><telerik:ChartSeries Name="" Type="StackedBar100" DataLabelsColumn="contactdate By Month" DataYColumn="Expr1" DataYColumn2="Sum Of contactdates_custno" DataYColumn3="CountOfcustsales"> <Appearance> <FillStyle FillType="Solid" MainColor="194, 230, 252"> </FillStyle> <TextAppearance TextProperties-Color="78, 168, 188"> </TextAppearance> <Border Color="177, 215, 250" /> </Appearance> </telerik:ChartSeries></Series> <Legend> <Appearance Corners="Round, Round, Round, Round, 6" Dimensions-Margins="20%, 3%, 1px, 1px"> <ItemTextAppearance TextProperties-Color="120, 162, 19"> </ItemTextAppearance> <Border Color="194, 212, 109" /> </Appearance> </Legend> <PlotArea> <XAxis> <Appearance Color="226, 218, 202" MajorTick-Color="216, 184, 86" ValueFormat="Percent"> <MajorGridLines Color="244, 227, 195" Width="0" /> <TextAppearance TextProperties-Color="78, 168, 188"> </TextAppearance> </Appearance> <AxisLabel> <Appearance RotationAngle="270"> </Appearance> <TextBlock> <Appearance TextProperties-Color="78, 168, 188"> </Appearance> </TextBlock> </AxisLabel> </XAxis> <YAxis> <Appearance Color="226, 218, 202" MajorTick-Color="216, 184, 86" MinorTick-Color="216, 184, 86"> <MajorGridLines Color="244, 227, 195" /> <MinorGridLines Color="244, 227, 195" /> <TextAppearance TextProperties-Color="78, 168, 188"> </TextAppearance> </Appearance> <AxisLabel> <Appearance RotationAngle="0"> </Appearance> <TextBlock> <Appearance TextProperties-Color="78, 168, 188"> </Appearance> </TextBlock> </AxisLabel> </YAxis> <YAxis2> <AxisLabel> <Appearance RotationAngle="0"> </Appearance> </AxisLabel> </YAxis2> <Appearance Dimensions-Margins="20%, 24%, 12%, 10%"> <FillStyle MainColor="255, 249, 239" SecondColor="Transparent"> </FillStyle> <Border Color="226, 201, 156" /> </Appearance> </PlotArea> <ChartTitle> <Appearance Dimensions-Margins="4%, 10px, 10px, 7%"> <FillStyle MainColor=""> </FillStyle> </Appearance> <TextBlock Text="Customers Interested"> <Appearance TextProperties-Color="232, 140, 0" TextProperties-Font="Verdana, 20pt, style=Bold"> </Appearance> </TextBlock> </ChartTitle> </telerik:RadChart><telerik:GridCheckBoxColumn DataField="Requirement_Received" DataType="System.Boolean" HeaderText="Requirement Received?" SortExpression="Requirement_Received" UniqueName="Requirement_Received"> <HeaderStyle Width="125px" /> </telerik:GridCheckBoxColumn>