or
Spell Check Handler Server Error:500<html> <head> <title>No dictionary loaded. Set the DictionaryPath property from the spell checker settings or copy the dictionaries to ~/App_Data/RadSpell/</title> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } </style> </head> <body bgcolor="white"> <span><H1>Server Error in '/cpe' Application.<hr width=100% size=1 color=silver></H1> <h2> <i>No dictionary loaded. Set the DictionaryPath property from the spell checker settings or copy the dictionaries to ~/App_Data/RadSpell/</i> </h2></span> <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "> <b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. <br><br> <b> Exception Details: </b>System.ArgumentException: No dictionary loaded. Set the DictionaryPath property from the spell checker settings or copy the dictionaries to ~/App_Data/RadSpell/<br><br> <b>Source Error:</b> <br><br> <table width=100% bgcolor="#ffffcc"> <tr> <td> <code> An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code> </td> </tr> </table> <br> <b>Stack Trace:</b> <br><br> <table width=100% bgcolor="#ffffcc"> <tr> <td> <code><pre> [ArgumentException: No dictionary loaded. Set the DictionaryPath property from the spell checker settings or copy the dictionaries to ~/App_Data/RadSpell/] Telerik.Web.UI.Dictionaries.EditDistanceDictionary.Load(TextReader baseDictionaryReader, ICustomDictionarySource customSource, String cacheKey) +154 Telerik.Web.UI.SpellChecker.LoadDictionary() +290 Telerik.Web.UI.SpellChecker.get_dictionary() +18 Telerik.Web.UI.SpellChecker.CheckWord(String word, String sLastWord) +162 Telerik.Web.UI.TelerikSpellCheckProvider.CheckWord(ITextWord current, ITextWord previous) +64 Telerik.Web.UI.SpellChecker.CheckText() +171 Telerik.Web.UI.SpellChecker.BadWordsJScript() +13 Telerik.Web.UI.SpellCheckHandler.ProcessSpellCheckRequest(HttpResponse response, SpellChecker checker, String text) +74 Telerik.Web.UI.SpellCheckHandler.ProcessRequest(HttpContext context) +487 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75 </pre></code> </td> </tr> </table> <br> <hr width=100% size=1 color=silver> <b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053 </font> </body> </html> <!-- [ArgumentException]: No dictionary loaded. Set the DictionaryPath property from the spell checker settings or copy the dictionaries to ~/App_Data/RadSpell/ at Telerik.Web.UI.Dictionaries.EditDistanceDictionary.Load(TextReader baseDictionaryReader, ICustomDictionarySource customSource, String cacheKey) at Telerik.Web.UI.SpellChecker.LoadDictionary() at Telerik.Web.UI.SpellChecker.get_dictionary() at Telerik.Web.UI.SpellChecker.CheckWord(String word, String sLastWord) at Telerik.Web.UI.TelerikSpellCheckProvider.CheckWord(ITextWord current, ITextWord previous) at Telerik.Web.UI.SpellChecker.CheckText() at Telerik.Web.UI.SpellChecker.BadWordsJScript() at Telerik.Web.UI.SpellCheckHandler.ProcessSpellCheckRequest(HttpResponse response, SpellChecker checker, String text) at Telerik.Web.UI.SpellCheckHandler.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="grd_DrugItems"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="grd_DrugItems" LoadingPanelID="MasterAjaxLoadingPanel" /> <telerik:AjaxUpdatedControl ControlID="grd_DrugGroup" LoadingPanelID="MasterAjaxLoadingPanel" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="btn_NewGroup"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="grd_DrugItems" LoadingPanelID="MasterAjaxLoadingPanel" /> <telerik:AjaxUpdatedControl ControlID="grd_DrugGroup" LoadingPanelID="MasterAjaxLoadingPanel" /> <telerik:AjaxUpdatedControl ControlID="txt_GroupName" /> <telerik:AjaxUpdatedControl ControlID="grd_DrugGroupMaster" LoadingPanelID="MasterAjaxLoadingPanel" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="grd_DrugGroupMaster"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="grd_DrugGroupMaster" LoadingPanelID="MasterAjaxLoadingPanel" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="RadButton1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="grd_DrugItems" LoadingPanelID="MasterAjaxLoadingPanel" /> <telerik:AjaxUpdatedControl ControlID="grd_DrugGroup" LoadingPanelID="MasterAjaxLoadingPanel" /> <telerik:AjaxUpdatedControl ControlID="grd_DrugGroupMaster" LoadingPanelID="MasterAjaxLoadingPanel" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <div style="direction:ltr; width:770px; height:340px; margin:auto; margin-top:5px; background-image:url('Images/GroupBackground.png'); background-repeat:repeat-x; border-style:solid; border-width:1px; border-color:RGB(7,45,75);"> <div id="HeaderSeprator" style="direction:rtl;background-image:url('Images/bg_foot_forms.gif'); background-position:bottom; width:95%; height:23px; margin:auto; background-repeat:no-repeat;"> <p style="direction:rtl; margin:auto; width:-moz-max-content; margin-top:5px; font-family:Tahoma; font-size:12px; color:White;"> Please drag and drop </p> </div> <div id="ContainsGridDrugList" style="float:left; padding-left:10px; padding-right:1px; width:370px;height:270px; direction:ltr;"> <p class="HeaderTextDrugList"> drugs in pharmacy </p> <telerik:RadGrid ID="grd_DrugItems" runat="server" GridLines="None" Width="365px" onneeddatasource="grd_DrugItems_NeedDataSource" AutoGenerateColumns="False" onrowdrop="grd_DrugItems_RowDrop" AllowMultiRowSelection="True"> <ClientSettings AllowRowsDragDrop="True"> <Selecting AllowRowSelect="True" EnableDragToSelectRows="False" /> <ClientEvents OnMasterTableViewCreated="MasterTableViewGrids_Created" OnRowDropping="onRowDropping" /> <Scrolling AllowScroll="True" UseStaticHeaders="True" ScrollHeight="200px" /> </ClientSettings> <MasterTableView DataKeyNames="DrugId" TableLayout="Fixed" Width="100%" ><CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings><RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn><ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn Display="False" FilterControlAltText="Filter col_DrugId column" UniqueName="col_DrugId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DrugForm" HeaderText="Form" UniqueName="col_DrugForm"> <HeaderStyle Width="70px" HorizontalAlign="Left"/> <ItemStyle HorizontalAlign="Left" Wrap="False" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DrugName" HeaderText="Name" UniqueName="col_DrugName"> <HeaderStyle Width="205px" HorizontalAlign="Left" /> <ItemStyle HorizontalAlign="Left" Wrap="False" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DrugDose" HeaderText="Dose" UniqueName="col_DrugDose"> <HeaderStyle Width="70px" HorizontalAlign="Left" /> <ItemStyle HorizontalAlign="Left" Wrap="False" /> </telerik:GridBoundColumn> </Columns> <EditFormSettings> <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn> </EditFormSettings> </MasterTableView> <FilterMenu EnableImageSprites="False"></FilterMenu> <HeaderStyle HorizontalAlign="Left"/> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu> </telerik:RadGrid> </div> <div id="ContainsGridGroupDrug" style=" float:right; padding-left:1px; padding-right:10px; width:370px; height:270px; direction:ltr"> <p class="HeaderTextDrugList"> drugs in group </p> <telerik:RadGrid ID="grd_DrugGroup" runat="server" AutoGenerateColumns="False" CellSpacing="0" GridLines="None" onneeddatasource="grd_DrugGroup_NeedDataSource" onrowdrop="grd_DrugGroup_RowDrop" Width="365px" AllowMultiRowSelection="True"> <PagerStyle Mode="NumericPages" /> <ClientSettings AllowRowsDragDrop="True"> <Selecting AllowRowSelect="True" /> <ClientEvents OnMasterTableViewCreated="MasterTableViewGrids_Created" /> <Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="True" ScrollHeight="200px" /> </ClientSettings> <MasterTableView DataKeyNames="DrugId" TableLayout="Fixed" Width="100%"> <Columns> <telerik:GridBoundColumn Display="False" FilterControlAltText="Filter col_DrugId column" UniqueName="col_DrugId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DrugForm" HeaderText="Form" UniqueName="col_DrugForm"> <HeaderStyle Width="70px" HorizontalAlign="Left" /> <ItemStyle HorizontalAlign="Left" Wrap="False" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DrugName" HeaderText="Name" UniqueName="col_DrugName"> <HeaderStyle Width="205px" HorizontalAlign="Left" /> <ItemStyle HorizontalAlign="Left" Wrap="False" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DrugDose" HeaderText="Dose" UniqueName="col_DrugDose"> <HeaderStyle Width="70px" HorizontalAlign="Left" /> <ItemStyle HorizontalAlign="Left" Wrap="False" /> </telerik:GridBoundColumn> </Columns> <EditFormSettings> <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn> </EditFormSettings> </MasterTableView> <HeaderStyle HorizontalAlign="Left"/> <FilterMenu EnableImageSprites="False"></FilterMenu> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu> </telerik:RadGrid> </div> <div id="GroupCommands" style="float:left;margin-top:1px; margin-bottom:0px; bottom:0px; position:relative; width:100%; height:40px; border-top-style:solid; border-top-width:1px; border-top-color:RGB(7,45,75); background-color:White;"> <div id="DivGroupNameTextBox" style="float:right; direction:rtl; width:400px; padding-top:10px; padding-right:10px;"> <telerik:RadTextBox ID="txt_GroupName" runat="server" Width="300px" Label="نام گروه:" > </telerik:RadTextBox> </div> <div style="height:39px; float:right; width:200px;"> <telerik:RadButton ID="btn_NewGroup" runat="server" Text="RadButton" Width="32px" Height="32px" CssClass="CommandImageButton" onclick="btn_NewGroup_Click"> <Image ImageUrl="Images/Icons/PublicCommand/Save32.png" /> </telerik:RadButton> <telerik:RadButton ID="Btn_RecycleBin" runat="server" Text="RadButton" Width="32px" Height="32px" CssClass="CommandImageButton"> <Image ImageUrl="Images/Icons/PublicCommand/RecycleBin32.png" /> </telerik:RadButton> </div> <asp:Button ID="Button1" runat="server" Text="Button" /> <telerik:RadButton ID="RadButton1" runat="server" Text="RadButton" Width="32px" Height="32px" > <Image ImageUrl="Images/Icons/PublicCommand/Save32.png" IsBackgroundImage="true"/> </telerik:RadButton> </div> </div> <br /> <div style="direction:ltr"> <telerik:RadGrid ID="grd_DrugGroupMaster" runat="server" CellSpacing="0" GridLines="None" onneeddatasource="grd_DrugGroupMaster_NeedDataSource" AutoGenerateColumns="False" SkinID="LTRSkin" ondetailtabledatabind="grd_DrugGroupMaster_DetailTableDataBind"> <ClientSettings> <ClientEvents OnMasterTableViewCreated="MasterTableViewGrids_Created" /> </ClientSettings> <MasterTableView DataKeyNames="GroupId" ClientDataKeyNames="GroupId"> <DetailTables> <telerik:GridTableView runat="server" ClientDataKeyNames="DrugGroupMasterID,DrugGroupDetailID" DataKeyNames="DrugGroupMasterID,DrugGroupDetailID" AllowPaging="True" NoDetailRecordsText="دارویی در این گروه قرار داده نشده است"><CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings><RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn><ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="DrugForm" FilterControlAltText="Filter col_DrugForm column" HeaderText="Form" UniqueName="col_DrugForm"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DrugName" FilterControlAltText="Filter col_DrugName column" HeaderText="Name" UniqueName="col_DrugName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DrugDose" FilterControlAltText="Filter col_DrugDose column" HeaderText="Dose" UniqueName="col_DrugDose"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DrugGroupMasterID" Display="False" FilterControlAltText="Filter col_DrugGroupMasterID column" HeaderText="DrugGroupMasterID" UniqueName="col_DrugGroupMasterID"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DrugGroupDetailID" Display="False" FilterControlAltText="Filter col_DrugGroupDetailID column" HeaderText="DrugGroupDetailID" UniqueName="col_DrugGroupDetailID"> </telerik:GridBoundColumn> </Columns><EditFormSettings><EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn></EditFormSettings> </telerik:GridTableView> </DetailTables> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="DrugGroupMasterID" MasterKeyField="GroupId" /> </ParentTableRelation> <Columns> <telerik:GridBoundColumn DataField="GroupId" FilterControlAltText="Filter col_GroupId column" HeaderText="Group Id" UniqueName="col_GroupId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="GroupName" FilterControlAltText="Filter col_GroupName column" HeaderText="Group Name" UniqueName="col_GroupName"> </telerik:GridBoundColumn> </Columns> </MasterTableView> <FilterMenu EnableImageSprites="False"></FilterMenu> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu> </telerik:RadGrid> </div> <br /></asp:Content>private DrugInteractionEntities Context; protected void Page_Load(object sender, EventArgs e) { if (Context == null) Context = new DrugInteractionEntities(); grd_DrugItems.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.None; grd_DrugItems.MasterTableView.AllowPaging = false; grd_DrugItems.MasterTableView.ShowFooter = false; grd_DrugItems.MasterTableView.AutoGenerateColumns = false; grd_DrugItems.MasterTableView.Dir = GridTableTextDirection.LTR; grd_DrugItems.Skin = "Default"; grd_DrugItems.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; grd_DrugGroup.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.None; grd_DrugGroup.MasterTableView.AllowPaging = false; grd_DrugGroup.MasterTableView.ShowFooter = false; grd_DrugGroup.MasterTableView.AutoGenerateColumns = false; grd_DrugGroup.MasterTableView.Dir = GridTableTextDirection.LTR; grd_DrugGroup.Skin = "Default"; grd_DrugGroup.HeaderStyle.HorizontalAlign = HorizontalAlign.Left; if (this.IsPostBack == false) { grd_DrugGroupMaster.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.None; grd_DrugGroupMaster.MasterTableView.AllowPaging = false; grd_DrugGroupMaster.DataSource = Context.DrugGroupMasters; grd_DrugGroupMaster.MasterTableView.Dir = GridTableTextDirection.LTR; grd_DrugGroupMaster.MasterTableView.Attributes.Add("class", "RadGrid RadGrid_Web20"); grd_DrugGroupMaster.MasterTableView.DetailTables[0].DataSource = Context.DrugGroupDetails; grd_DrugGroupMaster.MasterTableView.DetailTables[0].Dir = GridTableTextDirection.LTR; } } protected void grd_DrugItems_RowDrop(object sender, GridDragDropEventArgs e) { IList<DrugList> _groupingDrugList = GroupingDrugList; if (string.IsNullOrEmpty(e.HtmlElement)) { if (e.DraggedItems[0].OwnerGridID == grd_DrugItems.ClientID) { // Drugs drag from drugitemGrid to GroupGrid int destinationIndex = -1; foreach (GridDataItem draggedItem in e.DraggedItems) { int dragDrugId = Convert.ToInt32(draggedItem.GetDataKeyValue("DrugId")); if (GroupingDrugListContains(_groupingDrugList, dragDrugId)) continue; DrugList dl = Context.DrugLists.Where(d => d.DrugId == dragDrugId).First(); int ItemIndex = (e.DestDataItem == null ? 0 : e.DestDataItem.ItemIndex); _groupingDrugList.Insert(ItemIndex, dl); } GroupingDrugList = _groupingDrugList; grd_DrugGroup.Rebind(); } } } protected void grd_DrugGroup_RowDrop(object sender, GridDragDropEventArgs e) { if(String.IsNullOrEmpty(e.HtmlElement) && e.HtmlElement=="Btn_RecycleBin") { IList<DrugList> _groupingDrugList = GroupingDrugList; foreach (GridDataItem draggedItem in e.DraggedItems) { int dragDrugId = Convert.ToInt32(draggedItem.GetDataKeyValue("DrugId")); GroupingDrugListRemoveById(_groupingDrugList, dragDrugId); } this.GroupingDrugList = _groupingDrugList; this.grd_DrugGroup.Rebind(); } } protected void grd_DrugItems_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { grd_DrugItems.DataSource = Context.DrugLists; } protected void grd_DrugGroup_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { grd_DrugGroup.DataSource = GroupingDrugList; } protected IList<DrugList> GroupingDrugList { get { try { object obj = Session["GroupingDrugList"]; if(obj==null) { Session["GroupingDrugList"] = obj = new List<DrugList>(); } return (IList<DrugList>) obj; } catch { Session["GroupingDrugList"] = null; } return new List<DrugList>(); } set { Session["GroupingDrugList"] = value; } } protected void btn_NewGroup_Click(object sender, EventArgs e) { DrugGroupMaster DGM = new DrugGroupMaster() {GroupName = txt_GroupName.Text}; for (int i = 0; i < this.GroupingDrugList.Count; i++) { DrugGroupDetail DGD = new DrugGroupDetail(); DGD.DrugId = this.GroupingDrugList[i].DrugId; DGD.DrugGroupDetailID = i; DGM.DrugGroupDetails.Add(DGD); } Context.AddToDrugGroupMasters(DGM); Context.SaveChanges(); this.GroupingDrugList = null; } protected void grd_DrugGroupMaster_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { if (e.IsFromDetailTable == false) { grd_DrugGroupMaster.MasterTableView.DataSource = Context.DrugGroupMasters; } } protected void grd_DrugGroupMaster_DetailTableDataBind(object sender, GridDetailTableDataBindEventArgs e) { GridDataItem dataItem = (GridDataItem) e.DetailTableView.ParentItem; int groupMasterId = Convert.ToInt32(dataItem.GetDataKeyValue("GroupId")); grd_DrugGroupMaster.MasterTableView.DetailTables[0].DataSource = from drugDetail in Context.DrugGroupDetails where drugDetail.DrugGroupMasterID == groupMasterId select new { drugDetail.DrugGroupMasterID, drugDetail.DrugGroupDetailID, drugDetail.DrugId, drugDetail.DrugList.DrugForm, drugDetail.DrugList.DrugName, drugDetail.DrugList.DrugDose }; } }<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>