or
Hello,
I’m trying to DataBind a RadPanelBar but with no success.
protected void RadTreeView1_ContextMenuItemClick(object sender, RadTreeViewContextMenuEventArgs e){ RadTreeNode clickedNode = e.Node; switch (e.MenuItem.Value) { case "Copy": RadTreeNode clonedNode = clickedNode.Clone(); clonedNode.Text = string.Format("Copy of {0}", clickedNode.Text); clickedNode.InsertAfter(clonedNode); //set node's value so we can find it in startNodeInEditMode clonedNode.Value = clonedNode.GetFullPath("/"); clonedNode.Selected = true; startNodeInEditMode(clonedNode.Text); break; }}private void startNodeInEditMode(string nodeValue) { //find the node by its Value and edit it when page loads string js = "Sys.Application.add_load(editNode); function editNode(){ "; js += "var tree = $find(\"" + RadTreeView1.ClientID + "\"); "; js += "var node = tree.findNodeByValue('" + nodeValue + "');"; js += "if (node) node.startEdit();"; js += "Sys.Application.remove_load(editNode);};"; RadScriptManager.RegisterClientScriptBlock(this, this.GetType(), "nodeEdit", js, true); }</EditFormSettings>
I hit the edit button and it displays like it should but I can't get to the data when I hit update. below are the ascx and ascx.cs files and the update function
protected void RadGridCabFolders_UpdateCommand(object source, GridCommandEventArgs e){ //GridEditManager editMan = (e.Item as GridEditableItem).EditManager; GridEditableItem editedItem = e.Item as GridEditableItem; UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); string commandText = "UPDATE " + Page_Cab.CabRealName + " SET "; List<SqlParameter> paras = new List<SqlParameter>(); int doc_id = (int)((GridEditableItem)e.Item).GetDataKeyValue(DOC_ID); varRadGridCabFoldersIndex = Convert.ToInt16(doc_id); foreach (GridColumn column in e.Item.OwnerTableView.RenderColumns) { if (column is IGridEditableColumn && column.UniqueName != LOC && column.UniqueName != DELETED) { IGridEditableColumn editableCol = (column as IGridEditableColumn); if (editableCol.IsEditable) { //IGridColumnEditor editor = editMan.GetColumnEditor(editableCol); if (column.UniqueName != DOC_ID && column.UniqueName.ToLower() != TIME_STAMP) { commandText += " " + column.UniqueName + "=@" + column.UniqueName + ","; Control editFormControl = ((userControl)).FindControl(column.UniqueName); Type editformType = editFormControl.GetType(); object editorValue = (editformType.Name == "TextBox") ? ((TextBox)editFormControl).Text : (editformType.Name == "DropDownList") ? ((DropDownList)editFormControl).Text : (editformType.Name == "RadMaskedTextBox") ? ((RadMaskedTextBox)editFormControl).Text : (editformType.Name == "RadDatePicker") ? ((RadDatePicker)editFormControl).ToString() : (object)null; paras.Add(new SqlParameter(column.UniqueName, editorValue)); } } } } commandText = commandText.Substring(0, commandText.Length - 1) + " where doc_id=" + doc_id; DbHelper.ExecuteDbNonQuery(Page_Dept.DeptRealName, commandText, paras.ToArrayNullIsEmpty()); setDT(); ViewState["GridData"] = folder_dt; if (ViewState["GridData"] != null) { RadGridCabFolders.DataSource = ViewState["GridData"]; }}
using System;using System.Data;using System.Collections;using System.Web.UI;using Telerik.Web.UI;using System.Data;using System.Web.UI.WebControls;using System.Data.SqlClient;using System.Configuration;using System.Text.RegularExpressions;using TreenoCsLib; public partial class editform : System.Web.UI.UserControl { private object _dataItem = null; public CabItem Page_Cab { get { return (CabItem)Session[SessionKeys.SelCab]; } set { Session[TreenoCsLib.SessionKeys.SelCab] = value; } } public DeptItem Page_Dept { get { return (DeptItem)Session[SessionKeys.SelDept]; } set { Session[SessionKeys.SelDept] = value; } } protected void Page_Load(object sender, System.EventArgs e) { if (DataItem != null) { string ConnString = (string)Session[TreenoCsLib.SessionKeys.SelDeptDbConnString]; SqlConnection conn = new SqlConnection(ConnString); SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = new SqlCommand("select departmentid from departments where real_name='" + Page_Cab.CabRealName + "'", conn); conn.Open(); SqlDataReader myReader = null; myReader = adapter.SelectCommand.ExecuteReader(); myReader.Read(); string departmentid = myReader["departmentid"].ToString(); conn.Close(); Control EditTable = FindControl("Table4"); object[] editFormVals = ((System.Data.DataRowView)(DataItem)).Row.ItemArray; int i = 0; foreach (DataColumn colObj in ((DataRowView)(DataItem)).Row.Table.Columns) { TableRow r = new TableRow(); string colName = colObj.ColumnName; if (colName == "file_id" || colName == "document_id" || colName == "cabinet_id" || colName == "doc_id" || colName == "location" || colName == "deleted" || colName == "timestamp" || colName == "TimeStamp" || colName == "fsearch_id") { } else { //need to look up required and regex string ConnStringDoc = ConfigurationManager.ConnectionStrings["docutron"].ConnectionString; SqlConnection connDoc = new SqlConnection(ConnStringDoc); SqlDataAdapter adapterDoc = new SqlDataAdapter(); SqlDataReader myReaderDoc = null; adapter.SelectCommand = new SqlCommand("SELECT required,regex FROM field_format where cabinet_id=" + departmentid + " and field_name='" + colName + "'", conn); conn.Open(); myReader = adapter.SelectCommand.ExecuteReader(); string requiredField = "0"; string regExField = ""; if (myReader.HasRows) { myReader.Read(); requiredField = myReader["required"].ToString(); regExField = myReader["regex"].ToString(); } conn.Close(); //need to look up dropdown list ( adapterDoc.SelectCommand = new SqlCommand("SELECT value FROM settings where k='dt," + Page_Dept.DeptRealName + "," + departmentid + "," + colName + "'", connDoc); connDoc.Open(); myReaderDoc = adapterDoc.SelectCommand.ExecuteReader(); if (myReaderDoc.HasRows) //need dropdown { myReaderDoc.Read(); string pattern = ",,,(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))"; Regex rg = new Regex(pattern); string[] dropdownlistArr = rg.Split(myReaderDoc["value"].ToString()); TableCell c = new TableCell(); DropDownList tb = new DropDownList(); ArrayList tocs = new ArrayList(dropdownlistArr); tb.DataSource = tocs; tb.DataBind(); if (editFormVals[i].ToString() == null) { tb.SelectedIndex = 0; } else { tb.SelectedIndex = tocs.IndexOf(editFormVals[i].ToString()); } tb.DataSource = null; tb.ID = colName; //tb.Text = editFormVals[i].ToString(); c.Controls.Add(new LiteralControl(colName + ": ")); c.Controls.Add(tb); r.Cells.Add(c); ((Table)EditTable).Rows.Add(r); } else if (colName.Contains("date")) { TableCell c = new TableCell(); RadDatePicker tb = new RadDatePicker(); tb.ID = colName; tb.DbSelectedDate = editFormVals[i].ToString(); c.Controls.Add(new LiteralControl(colName + ": ")); c.Controls.Add(tb); r.Cells.Add(c); ((Table)EditTable).Rows.Add(r); } else { TableCell c = new TableCell(); TextBox tb = new TextBox(); tb.ID = colName; tb.Text = editFormVals[i].ToString(); c.Controls.Add(new LiteralControl(colName + ": ")); c.Controls.Add(tb); r.Cells.Add(c); ((Table)EditTable).Rows.Add(r); } } ++i; } } //((System.Data.DataRowView)(DataItem)).Row.ItemArray //((System.Data.DataColumn)((new System.Collections.ArrayList.ArrayListDebugView(((System.Data.InternalDataCollectionBase)(((System.Data.DataRowView)(DataItem)).Row.Table.Columns)).List)).Items[0])).ColumnName // Put user code to initialize the page here } #region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: This call is required by the ASP.NET Web Form Designer. // InitializeComponent(); base.OnInit(e); } /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.DataBinding += new System.EventHandler(this.EmployeeDetails_DataBinding); } #endregion public object DataItem { get { return this._dataItem; } set { this._dataItem = value; } } protected void EmployeeDetails_DataBinding(object sender, System.EventArgs e) { //ArrayList tocs = new ArrayList(new string[] { "Dr.", "Mr.", "Mrs.", "Ms." }); //Control temp = FindControl("vendor"); //((DropDownList)temp).DataSource = tocs; //((DropDownList)temp).DataBind(); //object tocValue = DataBinder.Eval(DataItem, "vendor"); //if (tocValue == DBNull.Value) //{ // tocValue = "Mrs."; //} //((DropDownList)temp).SelectedIndex = tocs.IndexOf((string)tocValue); //((DropDownList)temp).DataSource = null; } }
<%@ Control Language="c#" Inherits="editform" CodeFile="editform.ascx.cs" %><%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %><asp:table id="Table2" cellspacing="2" cellpadding="1" width="100%" style="border-collapse: collapse" runat="server"> <asp:TableRow CssClass="EditFormHeader"> <asp:TableCell ColumnSpan="2"> <b>Edit Form</b> </asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell ColumnSpan="2"> <b>Test:</b> </asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell> <asp:Table id="Table4" runat="server"> </asp:Table> </asp:TableCell> </asp:TableRow> <asp:TableRow> <asp:TableCell HorizontalAlign="Right" ColumnSpan="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> <asp:Button ID="btnCancel" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel"> </asp:Button> </asp:TableCell> </asp:TableRow></asp:table>Hi there,
In my radchart, for y axis I set autoScale=False and added few items with different values. But the values are getting overlapped in the y -axis while doing this. Is there any way to over come this issue ?
I am attaching the desgin code and screen of the chart below for your reference
<telerik:RadChart ID="RadChart2" Height="400px" SkinsOverrideStyles="true" runat="server" AutoLayout="false"> <ClientSettings /> <PlotArea > <XAxis> </XAxis> <YAxis AutoScale="false" > <Items> <telerik:ChartAxisItem Value="1"> </telerik:ChartAxisItem> <telerik:ChartAxisItem Value="3"> </telerik:ChartAxisItem> <telerik:ChartAxisItem Value="200"> </telerik:ChartAxisItem> </Items> </YAxis> </PlotArea> <Series> <telerik:ChartSeries Name="Series 1" Type="Line"> <Appearance> <LineSeriesAppearance Width="3" /> <PointMark Visible="True" Border-Width="10" Border-Visible="true" FillStyle-FillType="Solid" Dimensions-AutoSize="true" Dimensions-Height="10px" Dimensions-Width="10px"> </PointMark> </Appearance> <Items> <telerik:ChartSeriesItem XValue="1" YValue="1" Name="Item 20"> </telerik:ChartSeriesItem> <telerik:ChartSeriesItem XValue="3" YValue="2" Name="Item 100"> </telerik:ChartSeriesItem> <telerik:ChartSeriesItem XValue="4" YValue="70" Name="Item 100"> </telerik:ChartSeriesItem> <telerik:ChartSeriesItem XValue="5" YValue="71" Name="Item 20"> </telerik:ChartSeriesItem> <telerik:ChartSeriesItem XValue="6" YValue="73" Name="Item 20"> </telerik:ChartSeriesItem> </Items> </telerik:ChartSeries> </Series> </telerik:RadChart>