Telerik Forums
UI for ASP.NET AJAX Forum
9 answers
316 views
Hello,

In the autocompletBox , we search in the "DataTextField" which represent the column,

is it possible to take the query and modify this, to search on the other column ?


I want to search in City table, i must to search Zip code or City Name in the same AutocompleteBox.

Please
Have you a solution ?

thanks
Olivier,


Olivier
Top achievements
Rank 2
 answered on 15 Nov 2012
1 answer
78 views
Hi,

I am trying to bind a dropdownlist in the itemdataBound event, but when I enter edit mode I am getting the error:
"Specified argument was out of the range of valid values. Parameter name: index"
for the line:
"Dim editor As GridDropDownListColumnEditor = CType(editMan.GetColumnEditor("Band"), GridDropDownListColumnEditor)"

I was referring to this to bind the dropdown: http://www.telerik.com/help/aspnet-ajax/grid-customize-configure-griddropdowncolumn.html

Any ideas why I am getting this error?

My code is below:

RadGrid1_ItemDataBound
Private Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound
        If TypeOf e.Item Is GridDataItem Then
            Dim item As GridDataItem = DirectCast(e.Item, GridDataItem)
            Dim row As DataRowView = DirectCast(e.Item.DataItem, DataRowView)
 
            item("Band").Text = row("Band").ToString()
            item("capoptioname").Text = row("capoptioname").ToString()
        End If
 
           If (TypeOf e.Item Is GridEditableItem AndAlso CType(e.Item, GridEditableItem).IsInEditMode) Then
            Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem)
            Dim editMan As GridEditManager = editedItem.EditManager
            Dim editor As GridDropDownListColumnEditor = CType(editMan.GetColumnEditor("Band"), GridDropDownListColumnEditor)
            Dim ddlBand As DropDownList = editor.DropDownListControl
 
            Dim ProductBus As New Product
            Dim bands As Entities.Product.callbandsDataTable
            bands = ProductBus.GetCallBandsList
            ddlBand.DataSource = bands
            ddlBand.DataTextField = "description"
            ddlBand.DataValueField = "value"
            ddlBand.DataBind()
        End If
End Sub

aspx
<telerik:RadGrid ID="RadGrid1" runat="server" PagerStyle-AlwaysVisible="true" AllowPaging="True" AllowSorting="True" pagesize="25" pagerposition="bottom" GridLines="None"
         Width="99.9%" EnableEmbeddedSkins="False" AllowMultiRowEdit="True" OnSortCommand="RadGrid1_SortCommand" ShowStatusBar="True" Skin="p3"
         OnNeedDataSource="RadGrid1_NeedDataSource" AllowFilteringByColumn="True" AutoGenerateColumns="False" CellSpacing="0" Culture="en-GB"  >
 
<MasterTableView EditMode="inplace" AllowMultiColumnSorting="true" DataKeyNames="id" GridLines="Both" CommandItemDisplay="Top" >
             
<CommandItemSettings ExportToPdfText="Export to PDF" />
        <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column" Visible="True"> </RowIndicatorColumn>
        <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column" Visible="True"> </ExpandCollapseColumn>
         <CommandItemTemplate>
             
        </CommandItemTemplate>
 
        <Columns>
                <telerik:GridEditCommandColumn HeaderStyle-Width="4%" ButtonType="ImageButton" EditImageUrl="/images/edit.png" />
                <telerik:GridBoundColumn UniqueName="id" DataField="id" HeaderText="id" ReadOnly="True" HeaderStyle-Width="1%" Display="False"> </telerik:GridBoundColumn>
                <telerik:GridDropDownColumn DataField="Band" HeaderText="Band"  UniqueName="Band" ColumnEditorID="GridDropDownListColumnEditor1" HeaderStyle-Width="10%"  ListTextField="description" ListValueField="value" EnableEmptyListItem="true" EmptyListItemValue="0" EmptyListItemText="please select"  FilterControlAltText="Filter callband column" DropDownControlType="RadComboBox" > </telerik:GridDropDownColumn>
        </Columns>
         
        <PagerStyle AlwaysVisible="True" />
        </MasterTableView>
        <ClientSettings>
            <Scrolling AllowScroll="True" ScrollHeight="" SaveScrollPosition="True"></Scrolling>           
        </ClientSettings>
        
        <SortingSettings  EnableSkinSortStyles="false"></SortingSettings>
         
    <PagerStyle Mode="NumericPages" />
</telerik:RadGrid>
<telerik:GridDropDownListColumnEditor ID="GridDropDownListColumnEditor1" runat="server" DropDownStyle-Width="200px" > </telerik:GridDropDownListColumnEditor>
Shinu
Top achievements
Rank 2
 answered on 15 Nov 2012
16 answers
547 views
Hi,

We are currently having performance problem on the TabStrip when the AutoPostBack property is set to "True" even there is no server side event attached. It takes about 3 seconds to show the newly selected tab. There is no problem if AutoPostBack property is set to "False".

Is there any workaround ?

Regards,

Semih
Nencho
Telerik team
 answered on 15 Nov 2012
1 answer
77 views
I have a client side function that fires when the "OnGridCreated" event is triggered.  The code in there used to work fine, then we got an update, now we discover get_masterTableView() is returning null in some cases were it used to be ok.  Any idea?


function onGridCreated(sender, eventArgs) {
        if (rowIsSelected()) {
        .....
 
function rowIsSelected()    {
        var getSeletecteRow=getSelectedRow();
        ......
 
function getSelectedRow()    {
        var employeeSummaryGrid = $find('<%=EmployeeSummaryGrid.ClientID%>');
        if (employeeSummaryGrid != null)
        {
            var MasterTable = employeeSummaryGrid.get_masterTableView();   //this is returning null in some cases
            return MasterTable.get_selectedItems()[0];
        }
 
        return null;
    }

Eyup
Telerik team
 answered on 15 Nov 2012
2 answers
212 views
Hello Telerik team,

I have Delete logic on server side & want to use radconfirm. Prompt me how I can turn from java script method RadListBox1Deleted!

function RadListBox1Deleting(sender, arg) {
             var callBackFunction = Function.createDelegate(sender, function (shouldSubmit) {
                 if (shouldSubmit) {
                     // call server side RadListBox1Deleted
                 }
             });
             var text = "Are you sure you want to delete?";
             radconfirm(text, callBackFunction, 300, 100, null, "Deleting");
             arg.set_cancel(true);
         }

Anatoliy
Top achievements
Rank 2
 answered on 15 Nov 2012
5 answers
139 views
Hi.

I would like to display values of a HashTable inside a ClientBinding, is this possible?

If not i would like to recommend it.
It should be possible to declare a container for the hashtable, and inside fields that can display the key and value of the hashtable, for all entries inside the hashtable the key/value pair will get duplicated and filled with there corresposing values till the end is reached.
How can i achieve this functionality when its not already possible?
Radoslav
Telerik team
 answered on 15 Nov 2012
1 answer
92 views
heeey guys 


I have a question, I have  here a data time field that is saved in the db as date time and it need to be a date time , and I want to load this Field in a drop down but not the hole value just the year 

}
     protected void LoadYear()
     {
         SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["HolidayTrackerConnectionString"].ConnectionString);
 
         SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM HtVacationDay", connection);
         DataTable dt = new DataTable();
 
         adapter.Fill(dt);
 
         rcbYear.DataTextField = "FromDate";
         rcbYear.DataValueField = "VacationDayId";
 
         rcbYear.DataSource = dt;
         rcbYear.DataBind();
 
         rcbYear.Items.Insert(0, new RadComboBoxItem("-Select a Year-"));
     }
thanks for help and fast answer ! 
Shinu
Top achievements
Rank 2
 answered on 15 Nov 2012
2 answers
434 views
Hi all member
I have a grid in asp and add
GridColumnGroup and column in code behind.
i add in page load event before i set value for colums but when page post back to server raise error
Invalid column name:
this my code

plase help to me
thanks

protected void Page_Load(object sender, EventArgs e)
       {
           if (Page.IsPostBack == false)
           {
               txtDate.Text = clsMain.GetPersianDate();
                
               CreateStructureTable();
               fillZoneData();
               fillAreaData();
               fillPlacetype();
               if (objZone.dtblZone.Rows.Count == 0 || objArea.dtblZone.Rows.Count==0)
               {
                   string script = "Error('شما به منطقه ای مشخص دسترسی ندارید')";
                  // ScriptManager.RegisterStartupScript(this, GetType(), "MyKey", script, true);
               }
               else
               {
                   FillPlaceInTable();
                   FillDataInTable();
                     
               }
           }
       }
private void CreateStructureTable()
       {
           int i = 0;
           string s = "";
           #region "GridClear"
           dgdZone.MasterTableView.Columns.Clear();
          // dgdZone0.MasterTableView.Columns.Clear();
           dgdZone.MasterTableView.ColumnGroups.Clear();
           #endregion
           
           #region "GridColumnGroup"
           objContractItem.dtblContractItem = clsMain.SelectByCondition("Select * from vContractItem where iNumber In(Select iParentNumber from vContractItem) Order by ContractItemLevel asc");
           for (i = 0; i <= objContractItem.dtblContractItem.Rows.Count - 1; i++)
           {
               if (!dgdZone.MasterTableView.ColumnGroups.Contains(objContractItem.dtblContractItem.Rows[i]["iNumber"]))
               {
                   GridColumnGroup grp = new GridColumnGroup();
                   grp.HeaderText = objContractItem.dtblContractItem.Rows[i]["strName"].ToStr().Replace(" ", "").Replace(":", "");
                   grp.Name = "grp" + objContractItem.dtblContractItem.Rows[i]["iNumber"].ToStr().Replace(" ", "").Replace(":", "");
                   grp.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
                   grp.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
                   if (objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToInt() != 0)
                   {
                       grp.ParentGroupName = "grp" + objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToStr().Replace(" ", "").Replace(":", "");
                   }
                   dgdZone.MasterTableView.ColumnGroups.Add(grp);
               }
           }
           #endregion
           //------------------------------ردیف
           Telerik.Web.UI.GridBoundColumn iRowNumber = new Telerik.Web.UI.GridBoundColumn();
           dgdZone.MasterTableView.Columns.Add(iRowNumber);
           //dgdZone0.MasterTableView.Columns.Add(iRowNumber);
           iRowNumber.HeaderText = "ردیف";
           iRowNumber.UniqueName = "iRowNumber";
           iRowNumber.DataField = "iRowNumber";
           iRowNumber.Visible = true;
           iRowNumber.HeaderStyle.Width = Unit.Pixel(40);
           iRowNumber.ItemStyle.Width = Unit.Pixel(20);
           iRowNumber.ForceExtractValue = GridForceExtractValues.Always;
           iRowNumber.AllowFiltering = false;
           iRowNumber.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
           iRowNumber.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
           iRowNumber.ItemStyle.VerticalAlign = VerticalAlign.Middle;
           iRowNumber.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
           dt.Columns.Add("iRowNumber", i.GetType());
           dt2.Columns.Add("iRowNumber", s.GetType());
           //------------------------------------------
           //------------------------شناسه محل
           Telerik.Web.UI.GridBoundColumn iZonePlaceNumberCol = new Telerik.Web.UI.GridBoundColumn();
           dgdZone.MasterTableView.Columns.Add(iZonePlaceNumberCol);
         //  dgdZone0.MasterTableView.Columns.Add(iZonePlaceNumberCol);
           iZonePlaceNumberCol.HeaderText = "iZonePlaceNumber";
           iZonePlaceNumberCol.UniqueName = "iZonePlaceNumber";
           iZonePlaceNumberCol.DataField = "iZonePlaceNumber";
           iZonePlaceNumberCol.Visible = false;
           iZonePlaceNumberCol.ForceExtractValue = GridForceExtractValues.Always;
           dt.Columns.Add("iZonePlaceNumber", i.GetType());
           dt.Columns.Add("strPlaceName", s.GetType());
           //------------------------------
           //--------------------------------نام محل
          
           Telerik.Web.UI.GridBoundColumn strPlaceNameCol = new Telerik.Web.UI.GridBoundColumn();
           dgdZone.MasterTableView.Columns.Add(strPlaceNameCol);
         //  dgdZone0.MasterTableView.Columns.Add(strPlaceNameCol);
           strPlaceNameCol.HeaderText = "نام محل";
           strPlaceNameCol.UniqueName = "strPlaceName";
           strPlaceNameCol.DataField = "strPlaceName";
           strPlaceNameCol.Visible = true;
           strPlaceNameCol.HeaderStyle.Width = Unit.Pixel(180);
           strPlaceNameCol.ItemStyle.Width = Unit.Pixel(180);
           strPlaceNameCol.ForceExtractValue = GridForceExtractValues.Always;
           strPlaceNameCol.AllowFiltering = false;
           strPlaceNameCol.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
           strPlaceNameCol.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
           strPlaceNameCol.ItemStyle.VerticalAlign = VerticalAlign.Middle;
           strPlaceNameCol.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
           strPlaceNameCol.AllowSorting = false;
           strPlaceNameCol.AllowFiltering = false;
           dt2.Columns.Add("iZonePlaceNumber", i.GetType());
           dt2.Columns.Add("strPlaceName", s.GetType());
           //------------------------------
            
            
           objContractItem.dtblContractItem = clsMain.SelectByCondition("Select * from vContractItem where bShowDailyReport=1" + " Order by iParentNumber asc");
           for (i = 0; i <= objContractItem.dtblContractItem.Rows.Count - 1; i++)
           {
               Telerik.Web.UI.GridBoundColumn col = new Telerik.Web.UI.GridBoundColumn();
               if (objContractItem.dtblContractItem.Rows[i]["bIncomplete"].ToBool() == true)
               {
                 //  dgdZone0.MasterTableView.Columns.Add(col);
                   dt2.Columns.Add(objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString(), i.GetType());
               }
               else
               {
                   dgdZone.MasterTableView.Columns.Add(col);
                   dt.Columns.Add(objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString(), i.GetType());
               }
               if (objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToStr().Length > 0)
               {
                   //col.ColumnGroupName = "grp" + objContractItem.dtblContractItem.Rows[i]["iParentNumber"].ToStr();
               }
               col.UniqueName =objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString();
               col.DataField = objContractItem.dtblContractItem.Rows[i]["iNumber"].ToString();
               col.ForceExtractValue = GridForceExtractValues.Always;
               col.HeaderText = objContractItem.dtblContractItem.Rows[i]["strName"].ToString();
               col.HeaderStyle.VerticalAlign = VerticalAlign.Middle;
               col.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
               col.ItemStyle.VerticalAlign = VerticalAlign.Middle;
               col.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
               col.HeaderStyle.Width = Unit.Pixel(100);
               col.AllowSorting = false;
               col.AllowFiltering = false;
               col.Groupable = false;
           }
           // }
           GlobalMActivity.dt = dt;
           GlobalMActivity.dt2 = dt2;
           dgdZone.DataSource = dt;
           //dgdZone0.DataSource = dt2;
           dgdZone.DataBind();
        //   dgdZone0.DataBind();
       }
Eyup
Telerik team
 answered on 15 Nov 2012
1 answer
336 views
I have the following example code in content page:


...
<script>
 function pbBtn1() {
         __doPostBack("button1", "")
     }
      
    </script>
</asp:Content>
 
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server" >
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
     <AjaxSettings>
 
 
        <telerik:AjaxSetting AjaxControlID="button1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="rts"
                        LoadingPanelID="RadAjaxLoadingPanel3" />
                    <telerik:AjaxUpdatedControl ControlID="rmp" LoadingPanelID="RadAjaxLoadingPanel3" />
                </UpdatedControls>
        </telerik:AjaxSetting>
 
 
               </AjaxSettings>
</telerik:RadAjaxManager>
    
    
   <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel3" runat="server" />
    
        <div class="mainContent_bg" >
            
            <div class="mainContentContainerContent">
                
               <div class="spessore10"></div>              
                    <br />
                     <br />
                  <div id="xls">
                            <telerik:RadTabStrip ID="rts" runat="server" MultiPageID="rmp" OnClientTabSelected="pbBtn1">
                            <Tabs>
                            <telerik:RadTab Text="page1" selected="true" PageViewID="page1"></telerik:RadTab>
                            <telerik:RadTab Text="page2" selected="false" PageViewID="page2"></telerik:RadTab>
                            </Tabs>
                            </telerik:RadTabStrip>
                            <telerik:RadMultiPage ID="rmp" runat="server">
                                <telerik:RadPageView runat=server ID="page1" Selected=true BorderColor="Black" Height=500 BackColor="Gray">
                                 <asp:Label ID=lb1 runat=server  Text="Label1 base"></asp:Label>
                                 <br />
                                  
                                </telerik:RadPageView>
                                <telerik:RadPageView runat=server ID="page2" BorderColor="Black" Height=500 BackColor="Gray">
                                    <asp:Label ID=lb2 runat=server  Text="Label2 base"></asp:Label>
                                   <br />
                                    <br />
                                     
                                </telerik:RadPageView>
                            </telerik:RadMultiPage>
                  </div>            
  
                  <telerik:radButton ID="button1" runat="server"  Text=button1 />
                  <asp:Button ID="button2" runat="server"  OnClientClick="pbBtn1()" Text=button2  />
 
For my project I need to refresh only radTabStrip e radmultipge when I do button1 postback ... if I write this code in aspx page without masterpage it works. m
I also try to write radscriptManager on masterpage and to use radAjaxManagerProxy in content page but it does not work.
What  I do wrong? 

Thanks,

Davide

Eyup
Telerik team
 answered on 15 Nov 2012
8 answers
639 views
Hi,
I have one rad combo box , text box and a submit button at my rad window popup. At the time close popup at 'OnClientClose' i have cleared the rad combo box selection at client side as per below snippet,
 var comboDeactivateReasonTruck = $find("<%= cboDeactivateReasonTruck.ClientID %>");            
                comboDeactivateReasonTruck.clearSelection();             
                comboDeactivateReasonTruck.commitChanges();

  but internally the event for that respective combobox is not cleared. So when i trying to click on submit now at that first time if we have any validation message then its working fine ,now we are close that window popup and reopen and click again on submit instead of that submit event combobox event has been fired and nothing is happened. Is there any solution for that..?

Thanks in Advance...

Regards,
Subbu
Vipin
Top achievements
Rank 1
 answered on 15 Nov 2012
Narrow your results
Selected tags
Tags
+? more
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?