Dear Support Team

Hello To All

I how Question regarding special characters like ( Û ,  ê  ,...)   when the chart element contain these characters the chart show something like the attachment  1

i include two snapshot one with these characters (1.png)  and one without (2.png) , i can solve my problem by remove any characters like these before creating

chart (it will recrudesce speed and performance) also iam not happay with outputs , so anysugesstion...

 

Hi,
i want to apply client side filtering in rad grid . i am following the below link to achive it.

http://demos.telerik.com/aspnet-ajax/grid/examples/data-binding/client-side/programmatic/defaultcs.aspx

till now what i have done 
 i have written the java script  through webmethod iam calling the servr event

   var pageSize; var sortExpressions; var filterExpressions;var currentPageIndex;
            function RadGrid3_OnCommand(sender, args)
             {
              
                args.set_cancel(true);
               pageSize = sender.get_masterTableView().get_pageSize();

                sortExpressions = sender.get_masterTableView().get_sortExpressions();
                 filterExpressions = sender.get_masterTableView().get_filterExpressions();

                 currentPageIndex = sender.get_masterTableView().get_currentPageIndex();
                 if (args.get_commandName() === "Filter") {
                     currentPageIndex = 0;
                      var sortExpressionsAsSQL = sortExpressions.toString();
                  }

                  var tableView = $find("<%= RadGrid3.ClientID %>").get_masterTableView();
                  pageSize = tableView.get_pageSize();

                  sortExpressions = tableView.get_sortExpressions();
                  filterExpressions = tableView.get_filterExpressions();

                  currentPageIndex = tableView.get_currentPageIndex();
                  var startIndex = pageSize * currentPageIndex;
                  PageMethods.GetData(startIndex, pageSize, ahi_event, ahi_state, ahi_userid,filterExpressions.toList(), updateGrid);
}

my c# code is
  [WebMethod]
        public static List<sku_list> GetData(int startIndex, int pageSize, string ahi_event, string ahi_state, string ahi_userid, List<GridFilterExpression> filterExpressions)
        {
            List<sku_list> list = new List<sku_list>();
            StringBuilder sqlBuilder = new StringBuilder();
            sqlBuilder.AppendLine("DECLARE @startRow int     ");
            sqlBuilder.AppendLine("SET ROWCOUNT @maximumRows");

            sqlBuilder.AppendLine("WITH OrderedEmployees As");
            sqlBuilder.AppendLine("(");
        
            string sortExpressions = "";
            
           
            //List<DbParameter> parameters = new List<DbParameter>();
            var conString = System.Configuration.ConfigurationManager.ConnectionStrings["Amscan-ProdConnectionString"];

            // string commandString = "SELECT * FROM Artwork_sku where ahi_event_name='" + startIndex + "' and state='" + maximumRows + "'";
            using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Amscan-ProdConnectionString"].ConnectionString))
            {
                SqlCommand command = new SqlCommand("SP_AHI_SKULIST", connection);
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.Add("@USERID", SqlDbType.VarChar).Value = ahi_userid;
                command.Parameters.Add("@EVENAME", SqlDbType.VarChar).Value = ahi_event;
                command.Parameters.Add("@STATE", SqlDbType.VarChar).Value = ahi_state;
             
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                try
                {
                    while (reader.Read())
                    {
                        sku_list newObject = new sku_list();
                
                            newObject.userid = reader[0].ToString();
                            newObject.Item = reader[1].ToString();
                            Topvalue = newObject.Item;
                            newObject.event_name = reader[2].ToString();
                            newObject.Description = reader[3].ToString();
                            newObject.Is_New = reader[4].ToString();
                            newObject.State = reader[5].ToString();
                   
                        list.Add(newObject);
                    }
                    int counter = 0;
                    List<DbParameter> parameters = new List<DbParameter>();
                   
                    if (filterExpressions.Count > 0)
                        sqlBuilder.Append(" WHERE ");
                    foreach (GridFilterExpression expression in filterExpressions)
                    {
                        counter++;
                        Pair parameter = BuildParameter(expression);
                        parameters.Add((DbParameter)parameter.Second);

                        sqlBuilder.AppendFormat((string)parameter.First);
                        if (counter < filterExpressions.Count)
                        {
                            sqlBuilder.AppendFormat(" And ");
                        }
                    }
                    parameters.ForEach(

                   delegate(DbParameter parameter)
                   {
                       if (parameter != null)
                           command.Parameters.Add(parameter);
                   }
               );
                }
                finally
                {
                    reader.Close();
                }
            }
            return list;
        }

the method for filttering  in c#

 #region filter
        private static Pair BuildParameter(GridFilterExpression expression)
        {
            string fieldName = expression.FieldName.Trim().Split(' ')[0];
            GridKnownFunction filterFunction =
                (GridKnownFunction)Enum.Parse(typeof(GridKnownFunction), expression.FilterFunction);

            SqlParameter sqlParameter = null;

            string filterExpression = string.Empty;
            switch (filterFunction)
            {
                case GridKnownFunction.NoFilter:
                    filterExpression = "1 = 1";
                    break;
                case GridKnownFunction.Contains:
                    filterExpression = string.Format("[{0}] LIKE @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                         string.Format("%{0}%", Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName))));
                    break;
                case GridKnownFunction.DoesNotContain:
                    filterExpression = string.Format("[{0}] NOT LIKE @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                         string.Format("%{0}%", Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName))));
                    break;
                case GridKnownFunction.StartsWith:
                    filterExpression = string.Format("[{0}] LIKE @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                         string.Format("{0}%", Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName))));
                    break;
                case GridKnownFunction.EndsWith:
                    filterExpression = string.Format("[{0}] LIKE @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                         string.Format("%{0}", Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName))));
                    break;
                case GridKnownFunction.EqualTo:
                    filterExpression = string.Format("[{0}] = @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                         Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
                    break;
                case GridKnownFunction.NotEqualTo:
                    filterExpression = string.Format("[{0}] <> @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                         Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
                    break;
                case GridKnownFunction.GreaterThan:
                    filterExpression = string.Format("[{0}] > @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                        Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
                    break;
                case GridKnownFunction.LessThan:
                    filterExpression = string.Format("[{0}] < @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                         Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
                    break;
                case GridKnownFunction.GreaterThanOrEqualTo:
                    filterExpression = string.Format("[{0}] >= @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                        Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
                    break;
                case GridKnownFunction.LessThanOrEqualTo:
                    filterExpression = string.Format("[{0}] <= @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                         Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
                    break;
                case GridKnownFunction.Between:
                    filterExpression = string.Format(" ([{0}] >= @{0}) AND ([{0}] <= @{0})", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                        Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
                    break;
                case GridKnownFunction.NotBetween:
                    filterExpression = string.Format(" ([{0}] < @{0}) OR ([{0}] > @{0})", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                        Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
                    break;
                case GridKnownFunction.IsEmpty:
                    filterExpression = string.Format(" [{0}] = @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                         string.Empty);
                    break;
                case GridKnownFunction.NotIsEmpty:
                    filterExpression = string.Format(" [{0}] <> @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                          string.Empty);
                    break;
                case GridKnownFunction.IsNull:
                    filterExpression = string.Format(" [{0}] = @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                         DBNull.Value);
                    break;
                case GridKnownFunction.NotIsNull:
                    filterExpression = string.Format(" [{0}] <> @{0}", fieldName);
                    sqlParameter =
                        new SqlParameter(string.Format("@{0}", fieldName),
                                         DBNull.Value);
                    break;
            }

            return new Pair(filterExpression,
                            sqlParameter);
        }
        #endregion


now i dont know what to do to make filter working , the example link which i am following is doing lot of thing i am using a view in my sql command so iam confused also .

if any simple client side filtering example is there then plz let me know

I'm able to create a menu that stretches 100% width, but the RadMenuItems are left aligned.  I want the buttons to be center aligned (already figured out how to center align the text).

  <telerik:RadMenu ID="RadMenu1" runat="server" ResolvedRenderMode="Classic" 
        EnableEmbeddedSkins="False" Skin="Green" width="100%" >
      <Items>
          <telerik:RadMenuItem runat="server" Text="Home">
          </telerik:RadMenuItem>
          <telerik:RadMenuItem runat="server" Text="Button1">
          </telerik:RadMenuItem>
          <telerik:RadMenuItem runat="server" Text="Button2">
          </telerik:RadMenuItem>
          <telerik:RadMenuItem runat="server" Text="Button3">
              <Items>
                  <telerik:RadMenuItem runat="server" Text="Profile">
                  </telerik:RadMenuItem>
                  <telerik:RadMenuItem runat="server" Text="Password">
                  </telerik:RadMenuItem>
              </Items>
          </telerik:RadMenuItem>
          <telerik:RadMenuItem runat="server" Text="Logout">
          </telerik:RadMenuItem>
      </Items>
</telerik:RadMenu>

Thanks!

I am using RadEditor on a aspx page. All it's dialogs (hyperlink manager, image manager etc.,) were working fine. Now I have introduced Routing to my application, and all dialogs have stopped working. I thought that, this is because of Telerik DialogHandlers. So I have stopped routing for below page types. 

        routes.Add(New Route("{resource}.aspx/{*pathInfo}", New StopRoutingHandler()))
        routes.Add(New Route("{resource}.ajascx/{*pathInfo}", New StopRoutingHandler()))
        routes.Add(New Route("{resource}.axd/{*pathInfo}", New StopRoutingHandler()))

Since Telerik is using DialogHandler.aspx as Dialog handler, I was hoping this will resolve my issue. But it didnot.

Please help me on this


Web.config entries

<httpHandlers>
           <add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" validate="false"/>
           <add path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" validate="false"/>
           <add path="Telerik.Web.UI.DialogHandler.aspx" type="CustomHandler.SessionStateDialogHandler, App_Code" verb="*" validate="false"/>
           <add path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" validate="false"/>
</httpHandlers>

<handlers>
          <add name="Telerik_Web_UI_SpellCheckHandler_axd" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*"                            preCondition="integratedMode,runtimeVersionv2.0"/>
          <add name="Telerik_Web_UI_DialogHandler_aspx_*" path="Telerik.Web.UI.DialogHandler.aspx" type="CustomHandler.SessionStateDialogHandler,                                    App_Code" verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>
          <add name="Telerik_RadUploadProgressHandler_ashx" path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler"                      verb="*" preCondition="integratedMode,runtimeVersionv2.0"/>
         <add name="Telerik_Web_UI_WebResource_axd" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*"                                                      preCondition="integratedMode,runtimeVersionv2.0"/>
</handlers>

Hello, I am having a troublesome issue with the RadGrid in the PopUp Edit mode.  I have a RadGrid that allows users to enter data into the grid via the modal popup edit style form.  I'm having two issues on insert or edit (deletes work fine):

1. The modal pop-up does not close/go away after the user inserts a record or updates it if all the fields are not filled out.  If the user populates a value for all of the fields when they insert, then the modal closes itself (the desired behavior)
2. On updates/edits if the user changes the value in a field from having a value to not having a value (e.g. deletes out the value for the example field "Middle Name") then attempts to save that back, the modal both does not close and the update does not occur.  If the user populates a value for each field then the update occurs and the modal popup is closed on submit/save.

I have tried trapping any errors on the data grid insert, update, or delete and no errors are being caught there, so I am not sure what the issue is and am seeking help with this.  I would like the updates that change values to empty to be valid and for the modal to close itself on insert or update even if the user has not filled out values for each field.

Hello,

I'm working on a project that has a UserControl which contains a RadGrid.
I need to create a new UserControl for a certain action performed by the user.
This must be done in runtime.

I can't create the UserControl in the Page_Load() or Page_Init() functions.

How can I create a new UserControl dynamically during runtime, without the UserControl's and the RadGrid's functionality being compromised ?


Thanks, Daniel.

Hi,

I need a grid without paging (all rows are shown) but with the number of rows displayed (like it is displayed in pager). Is it possible ? Is there a PagerStyle who display only the number of rows ?


Thank you !

Hi,
I just upgrade from 2013.2.611.35 to 2014.1.403.35. And now the callback stopped working on the Toolbar. 

<telerik:RadToolBar ID="toolBar" runat="server" BackColor="White" Width="850px" AutoPostBack="True"
        OnButtonClick="toolBar_ButtonClick">
        <Items>
...
The event "OnButtonClick" is not fired.
Have you any idea about this issue ?
Regards
Bernard

Hi, I have a RADTabStrip defined in my page.
On clicking one of the tabs i load a user control.
Now in the user control, i have a button and a click handler for the same.
In the button click handler (client side function), i would like to change the text of the tab.
I saw examples which use something like $find("<%= RadTabStrip1.ClientID %>")
But I am not sure how to use this when the RadTabStrip is defined in the parent page.
Please provide clues / suggestions on how to get this done.

Thanks
Suchitra

Hi,

My appologies if this is a very basic question.

Please see the attached image. When we drag a row there is some white area above the row. Where are the styles defined for the row being dragged?  All I see in the css file for Drag/Drop is GridItemDropIndicator_blah.

Any pointers would be appreciated.

Thanks!
Rich