Telerik Forums
UI for ASP.NET AJAX Forum
or
Ask question
All Questions
Unanswered
Answered
110,792 questions
2 answers
147 views
Grid : ComboBox MultiColumn : Client Side Validation : How to Access Controls

Hi
I have a Grid, Add/Editing of record is done using EditMode="PopUp"  
Inside a FormTemplate  I have a MultiColumn ComboBox and a TextBox to enter landline no.
I have ASP.NET customValidator besides Textbox and want to perform client side validation. ( Using JQuery ? )
It should check that First two characters entered in landlineno Textbox matches with CityCode Column used in ComboBox Template.


 <telerik:RadGrid ID="RadGrid1" >
  ....
<MasterTableView EditMode="PopUp"  >
....
<EditFormSettings PopUpSettings-Modal="true" >
....
<FormTemplate >
......
.....
  <telerik:RadComboBox ID="RadComboBox2" Runat="server" TabIndex="3"
                      DropDownWidth="320px"
                      HighlightTemplatedItems="true"
                        DataSourceID="EDSStateList" DataTextField="StateName"
                        DataValueField="StateCode" SelectedValue='<%# Bind("FK_StateCode") %>'>
                        <HeaderTemplate>
                         <ul>
                            <li class="col1">StateName</li>
                            <li class="col2">CityName</li>
                            <li class="col3">CityCode</li>
                        </ul>
                        </HeaderTemplate>

                         <ItemTemplate>
                            <ul>
                                <li class="col1">
                                    <%# DataBinder.Eval(Container.DataItem, "StateName")%></li>
                                <li class="col2">
                                    <%# DataBinder.Eval(Container.DataItem, "CityName")%></li>
                                <li class="col3">
                                    <%# DataBinder.Eval(Container.DataItem, "CityCode") %></li>
                            </ul>
                        </ItemTemplate>

                         <FooterTemplate>
          
                        </FooterTemplate>

                    </telerik:RadComboBox>
.....
....
....
<FormTemplate >

-JD

 

Grid
JD.
Top achievements
Rank 1
 answered on 28 Sep 2011
3 answers
253 views
Pass the datakey of selected row to navigationUrl of radwindow
Hi all :)

I have a grid which contains general information, and I want to open a new radwindow with more details about selected row when I press on linkbutton

here is my grid:

<asp:LinkButton runat="server" ID="Label2" Text='<%# Eval("News_Title")%>' Font-Bold="true"
                                Font-Names="Tahoma" Font-Size="Small" OnClientClick="javascript:RowDblClick();">
                                </asp:LinkButton>


and here is my window:

<telerik:RadWindowManager ID="RadWindowManager2" runat="server" Skin="Black">
    <Windows>
        <telerik:RadWindow ID="GetContactUsWindow" runat="server" Title="تعليقات" Modal="true"
             ReloadOnShow="true" Width="750px" Height="750px"
            Animation="Fade" AutoSize="true" >
        </telerik:RadWindow>
        </Windows>
        </telerik:RadWindowManager>


and JavaScript function:

function RowDblClick(sender, eventArgs) {
 
            $find('<%= GetContactUsWindow.ClientID%>').show(); return
            false;
             
            
        }


I tried many ways posted here, but no one solve my problem

any help please!
Grid
Princy
Top achievements
Rank 2
 answered on 28 Sep 2011
3 answers
175 views
[Solved] Radgrid DefaultInsertValue
I am using the inline, Edit/Update/Delete
Is it possible to insert a variable using the DefaultInsertValue.

For E.g I have a hidden Field which I am storing an ID in and on an Insert I which to use the value from the hidden field as the defaultinsertvalue. Is this possible?

Perhaps I am going about it the wrong way.
Any assistance would be appreciated.
Thanks.
Grid
Jayesh Goyani
Top achievements
Rank 2
 answered on 28 Sep 2011
1 answer
87 views
Problem with Hierarchy grid expanding
hi all :)

i have a problem with hierarchy grid expanding

I bound the master and detailed tables, but when I run my page, I can see only the master table, with expanding arrow, but no expanding happened

can you help me please, with this code ?

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<style type="text/css">
    .style1
    {
        width: 100%;
    }
    .style2
    {
        direction: rtl;
    }
</style>
<telerik:RadScriptManager ID="RadScriptManager1" runat="server">
</telerik:RadScriptManager>
<telerik:RadAjaxManager runat="server" ID="RadAjaxManager1" DefaultLoadingPanelID="RadAjaxLoadingPanel1">
    <AjaxSettings>
        <telerik:AjaxSetting AjaxControlID="RadGrid1">
            <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                <telerik:AjaxUpdatedControl ControlID="RadWindowManager1" />
            </UpdatedControls>
        </telerik:AjaxSetting>
    </AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Default">
</telerik:RadAjaxLoadingPanel>
<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" HorizontalAlign="NotSet"
    LoadingPanelID="RadAjaxLoadingPanel1">
    <telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource1" runat="server" GridLines="None"
        CellSpacing="0" AutoGenerateColumns="False" Style="direction: rtl" OnPreRender="RadGrid1_PreRender">
        <MasterTableView TableLayout="Fixed" DataKeyNames="News_ID" DataSourceID="SqlDataSource1"
            Width="1000px">
            <ItemTemplate>
                <table class="style1">
                    <tr>
                        <td class="style2">
                            <asp:Image ID="Image1" runat="server" ImageUrl='<%# Eval("NewsCategory_AvatarPath")%>'
                                Width="30%" Height="30%" />
                        </td>
                    </tr>
                    <tr>
                        <td class="style2">
                            <asp:Label runat="server" ID="lblNewsTitle" Text='<%# Eval("News_Title")%>' Font-Bold="true"
                                Font-Names="Tahoma" Font-Size="Small"></asp:Label>
                        </td>
                    </tr>
                    <tr>
                        <td class="style2">
                            <asp:Label runat="server" ID="lblNewsText" Text='<%# Eval("News_Text")%>' Font-Bold="false"
                                Font-Names="Tahoma" Font-Size="Small"></asp:Label>
                        </td>
                    </tr>
                    <tr>
                        <td class="style2">
                            <asp:Label runat="server" ID="lblNewsDate" Text='<%# Eval("News_Date")%>' Font-Bold="false"
                                Font-Names="Tahoma" Font-Size="X-Small"></asp:Label>   
                            <asp:Label runat="server" ID="lblNewsTime" Text='<%# Eval("News_Time")%>' Font-Bold="false"
                                Font-Names="Tahoma" Font-Size="X-Small"></asp:Label>
                        </td>
                    </tr>
                </table>
            </ItemTemplate>
            <CommandItemSettings ExportToPdfText="Export to PDF" />
            <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
            </RowIndicatorColumn>
            <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
            </ExpandCollapseColumn>
            <Columns>
                <telerik:GridBoundColumn DataField="News_Title" FilterControlAltText="Filter News_Title column"
                    HeaderText="أخبار شبكة شام" HeaderStyle-Font-Bold="false" HeaderStyle-Font-Names="Tahoma"
                    HeaderStyle-Font-Size="Small" SortExpression="News_Title" UniqueName="News_Title">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="News_Text" FilterControlAltText="Filter News_Text column"
                    SortExpression="News_Text" UniqueName="News_Text">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="News_Date" FilterControlAltText="Filter News_Date column"
                    SortExpression="News_Date" UniqueName="News_Date">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="News_Time" FilterControlAltText="Filter News_Time column"
                    SortExpression="News_Time" UniqueName="News_Time">
                </telerik:GridBoundColumn>
            </Columns>
  <DetailTables>
                <telerik:GridTableView CommandItemDisplay="Bottom" DataKeyNames="News_Notes.Note_ID, News_Notes.News_ID"
                    Width="100%"
                    DataSourceID="SqlDataSource2" AllowAutomaticInserts="true" >
                    <ParentTableRelation>
                        <telerik:GridRelationFields DetailKeyField="News_Notes.News_ID" MasterKeyField="News.News_ID" />
                    </ParentTableRelation>
                  <ItemTemplate>
                        <table class="style1">
                            <tr>
                                <td class="style2">
                                    <asp:Label runat="server" ID="lblNewsTitle" Text='<%# Eval("User_Name")%>'
                                        Font-Bold="false" Font-Names="Tahoma" Font-Size="Small"></asp:Label>
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    <asp:Label runat="server" ID="lblNewsText" Text='<%# Eval("Note_Text")%>'
                                        Font-Bold="false" Font-Names="Tahoma" Font-Size="Small"></asp:Label>
                                </td>
                            </tr>
                            <tr>
                                <td class="style2">
                                    <asp:Label runat="server" ID="lblNewsDate" Text='<%# Eval("Note_Date")%>'
                                        Font-Bold="false" Font-Names="Tahoma" Font-Size="Small"></asp:Label>
                                </td>
                            </tr>
                        </table>
                    </ItemTemplate>
                    <Columns>
                        <telerik:GridBoundColumn DataField="Note_ID" DataType="System.Int32" FilterControlAltText="Filter Note_ID column"
                            HeaderText="التعليقات" ReadOnly="True" SortExpression="Note_ID" UniqueName="Note_ID"
                            HeaderStyle-Font-Bold="false" HeaderStyle-Font-Names="Tahoma" HeaderStyle-Font-Size="Small">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Note_Text" FilterControlAltText="Filter Note_Text column"
                            SortExpression="Note_Text" UniqueName="Note_Text">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Note_Date" DataType="System.DateTime" FilterControlAltText="Filter Note_Date column"
                            SortExpression="Note_Date" UniqueName="Note_Date">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="User_Name" FilterControlAltText="Filter User_Name column"
                            SortExpression="User_Name" UniqueName="User_Name">
                        </telerik:GridBoundColumn>
                    </Columns>
                </telerik:GridTableView>
            </DetailTables>
            </NestedViewTemplate>
            <EditFormSettings>
                <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                </EditColumn>
            </EditFormSettings>
        </MasterTableView>
        <FilterMenu EnableImageSprites="False">
        </FilterMenu>
        <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default">
        </HeaderContextMenu>
    </telerik:RadGrid>
</telerik:RadAjaxPanel>
<telerik:RadWindowManager ID="RadWindowManager1" runat="server" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" SelectCommand="SELECT News.News_ID, News.News_CategoryID, News.News_AdminID,
News.News_Title, News.News_Text, News.News_Date, News.News_Time,
News.News_FlagIsActive, NewsCategories.NewsCategory_ID, NewsCategories.NewsCategory_AvatarPath
FROM News INNER JOIN NewsCategories ON News.News_CategoryID = NewsCategories.NewsCategory_ID
WHERE News.News_FlagIsActive='True'
Order BY News.News_ID DESC"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" SelectCommand="SELECT News_Notes.Note_ID, News_Notes.News_ID, News_Notes.User_ID,
    News_Notes.Note_Text, News_Notes.Note_Date, News_Notes.Note_Flag,
    UsersTable.User_ID AS Expr1, UsersTable.User_Name
    FROM News_Notes INNER JOIN UsersTable ON News_Notes.User_ID = UsersTable.User_ID
WHERE  News_Notes.Note_Flag = 'True'
Order BY News_Notes.Note_Date "></asp:SqlDataSource>


any one can help me please!

Grid
Iana Tsolova
Telerik team
 answered on 28 Sep 2011
1 answer
200 views
Grid column custom filtering dynamic
I am having problems when adding two columns to a grid which rely on filtering though a combobox. The majority of the examples and support for custom filtering on a RadGrid is through the markup (.aspx). This does not apply for me because I am generating the RadGrid completely dynamically in the code-behind.

I have successfully created a custom filtering on a column. Please find below the snippet which loads the AssignedTo column. The AssignedTo column has a combobox filter implemented through AssignedToCustomBoundFilteringColumn.

var assignedToCol = new AssignedToCustomBoundFilteringColumn();
assignedToCol.DataField = "AssessmentManagerUser.FullName";
assignedToCol.HeaderText = "Assigned To";               
assignedToCol.UniqueName = "AssignedTo";
assignedToCol.SortExpression = "AssessmentManagerUser.FullName";
 
PlaApplicationsGrid.MasterTableView.Columns.Add(assignedToCol);

See below for the implementation of the AssignedToCustomBoundFilteringColumn
private class AssignedToCustomBoundFilteringColumn : GridBoundColumn
{
    protected override void SetupFilterControls(TableCell cell)
    {
        RadComboBox rcBox = new RadComboBox();
        rcBox.ID = "AssignedToFilterDropDownList";
        rcBox.AutoPostBack = true;
        rcBox.DataTextField = "FullName";
        rcBox.DataValueField = "FullName";
        rcBox.SelectedIndexChanged += rcBox_SelectedIndexChanged;
        rcBox.ItemDataBound += new RadComboBoxItemEventHandler(rcBox_ItemDataBound);
 
        var plaOfficers = ApplicationUserManager.Instance.GetBySecurityRoles(new string[] { KnownRoleNames.PLAOfficer }) as List<ApplicationUser>;
 
        var unassignedUser = ApplicationUserManager.Instance.GetUnassigned();
 
        ApplicationUser tempEmptyUser = new ApplicationUser();
        tempEmptyUser.Person = new Person();
        tempEmptyUser.Person.FirstName = "empty";
        tempEmptyUser.Person.Surname = "";
 
        plaOfficers.Insert(0, unassignedUser);
        plaOfficers.Insert(0, tempEmptyUser);
 
        rcBox.DataSource = plaOfficers;
        rcBox.DataBind();
 
        //rcBox.Items[0].Text = "Unassigned";
 
        cell.Controls.Add(rcBox);
    }           
 
    private void rcBox_ItemDataBound(object sender, RadComboBoxItemEventArgs e)
    {
        // Need this unless you want the item text to say "Unassignred Unassigned"
        if (e.Item.Text == ApplicationUserManager.Instance.GetUnassigned().FullName)
        {
            e.Item.Text = ApplicationUserManager.Instance.GetUnassigned().Username;
        }
        else if (e.Item.Text == "empty ")
        {
            e.Item.Text = " ";
        }
    }
 
    protected override void SetCurrentFilterValueToControl(TableCell cell)
    {
        if (!(this.CurrentFilterValue == ""))
        {
            ((RadComboBox)cell.Controls[0]).Items.FindItemByValue(this.CurrentFilterValue).Selected = true;
        }
    }
 
    protected override string GetCurrentFilterValueFromControl(TableCell cell)
    {
        string currentValue = ((RadComboBox)cell.Controls[0]).SelectedItem.Value;
        this.CurrentFilterFunction = (currentValue != "" && currentValue != "empty ") ? GridKnownFunction.EqualTo : GridKnownFunction.NoFilter;
        return currentValue;
    }
 
    private void rcBox_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
    {
        ((GridFilteringItem)(((RadComboBox)sender).Parent.Parent)).FireCommandEvent("Filter", new Pair());
    }
}

This is working fine. But I have since created a new column, which is basically an identical implementation
var stateCol = new StateCustomBoundFilteringColumn(); // AssignedTo column filtering breaks when this column is introduced
//var stateCol = new GridBoundColumn();
stateCol.DataField = "State.Description";
stateCol.HeaderText = "State";
stateCol.UniqueName = "State";
stateCol.SortExpression = "State.Description";
PlaApplicationsGrid.MasterTableView.Columns.Add(stateCol);

private class StateCustomBoundFilteringColumn : GridBoundColumn
{
    protected override void SetupFilterControls(TableCell cell)
    {
        RadComboBox rcBox = new RadComboBox();
        rcBox.ID = "StateFilterDropDownList";
        rcBox.AutoPostBack = true;
        rcBox.DataTextField = "Description";
        rcBox.DataValueField = "Name";
        rcBox.SelectedIndexChanged += rcBox_SelectedIndexChanged;
 
        var validStates = ApplicationStateManager.Instance.GetAllMasterBuildStates();
 
        ApplicationState tempEmptyState = new ApplicationState();
        tempEmptyState.Name = "empty";
        tempEmptyState.Description = "";
 
        validStates.Insert(0, tempEmptyState);
 
        rcBox.DataSource = validStates;
        rcBox.DataBind();
 
        //rcBox.Items[0].Text = "Unassigned";
 
        cell.Controls.Add(rcBox);
    }
  
    protected override void SetCurrentFilterValueToControl(TableCell cell)
    {
        if (!(this.CurrentFilterValue == ""))
        {
            ((RadComboBox)cell.Controls[0]).Items.FindItemByValue(this.CurrentFilterValue).Selected = true;
        }
    }
 
    protected override string GetCurrentFilterValueFromControl(TableCell cell)
    {
        string currentValue = ((RadComboBox)cell.Controls[0]).SelectedItem.Value;
        this.CurrentFilterFunction = (currentValue != "" && currentValue != "empty ") ? GridKnownFunction.EqualTo : GridKnownFunction.NoFilter;
        return currentValue;
    }
 
    private void rcBox_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
    {
        ((GridFilteringItem)(((RadComboBox)sender).Parent.Parent)).FireCommandEvent("Filter", new Pair());
    }
}

N.B. I have implemented the ColumnCreating event handler

I am at a loss why introducing the State filtering stuffs up the AssignedTo filtering.
Grid
Iana Tsolova
Telerik team
 answered on 28 Sep 2011
3 answers
73 views
Reason CaseSensitive in GroupingSettings
Hello,

Does anyone know the logic behind why CaseSensitive is in the GroupingSetting instead of the FilterMenu property group? Not the most important question in the world, but I think I am not understanding something?

Thanks,
John
Grid
Iana Tsolova
Telerik team
 answered on 28 Sep 2011
1 answer
188 views
Async file upload problem


Error: uncaught exception: Error while uploading, [HttpWebRequest_WebException_RemoteServer]
Arguments: NotFound
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=4.0.60531.0&File=System.Windows.dll&Key=HttpWebRequest_WebException_RemoteServer




Error: Unhandled Error in Silverlight Application [HttpWebRequest_WebException_RemoteServer]
Arguments: NotFound
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=4.0.60531.0&File=System.Windows.dll&Key=HttpWebRequest_WebException_RemoteServer   at System.Net.Browser.AsyncHelper.BeginOnUI(SendOrPostCallback beginMethod, Object state)
   at System.Net.Browser.BrowserHttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at UploadPrototype.MainPage.ProcessResponse(IAsyncResult asyncResult)
   at System.Net.Browser.BrowserHttpWebRequest.<>c__DisplayClassd.<InvokeGetResponseCallback>b__b(Object state2)
   at System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()
   at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()
Source File: http://192.168.1.4/Triage/Profiles/Personnel/Members/personnel.aspx
Line: 0

Error: Unhandled Error in Silverlight Application [ScriptObject_InvokeFailed]
Arguments:
Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=8.0.60531.0&File=System.Windows.Browser.dll&Key=ScriptObject_InvokeFailed   at System.Windows.Browser.ScriptObject.Invoke(String name, Object[] args)
   at UploadPrototype.EventManager.SilverlightError(String message, Int32 index)
   at UploadPrototype.MainPage.<>c__DisplayClass1f.<ProcessResponse>b__18()
Source File: http://192.168.1.4/Triage/Profiles/Personnel/Members/personnel.aspx
Line: 0
General Discussions
Princy
Top achievements
Rank 2
 answered on 28 Sep 2011
2 answers
107 views
Getting a column value without using UniqueName
I have an array of several rows and columns bound to a radGrid but I am only displaying a few of the columns which is working fine so far.

For each row, I am displaying a button where I will append it with a querystring of some values.

Unfortunately, some of the values which I intend to include in the querystring are not among the display columns, eg: columnG

I tried declaring a new column in the aspx file with UnqueName ColumnG but it does not seem to be working.

Question is , how do I get this column value in itemDataBound without using UniqueName ?

Thanks



Grid
vincent
Top achievements
Rank 1
 answered on 28 Sep 2011
1 answer
112 views
[Solved] How to pass parameter to webservice when using Load on demand
I followed the example in live demo and found that the signature of the webservice method must be

public RadRotatorItemData[] GetRotatorData(int itemIndex)

Does that mean there is no way to pass any custom parameter to the webservice method?

Regards
Edwin

Rotator
Slav
Telerik team
 answered on 28 Sep 2011
5 answers
167 views
Adding fields to Rad Filter
Hi friends,
I have been trying to place some extra  fields like field1, field2 along with the Rad grid columns into rad filter. When i am trying below code i am not able to see my added fields 'field1, field2" in rad filter.  any suggestions..? i DONT WANT TO USE DATASOURCE ID..
<body>
    <form id="form1" runat="server">
    <div>
     
        <telerik:RadScriptManager ID="RadScriptManager1" Runat="server">
        </telerik:RadScriptManager>
        <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
        <br />
        <telerik:RadFilter ID="RadFilter1" runat="server" FilterContainerID="RadGrid1"
            onapplyexpressions="RadFilter1_ApplyExpressions">
            <FieldEditors>
            <telerik:RadFilterTextFieldEditor FieldName="field1"  DataType="System.String" />
              <telerik:RadFilterTextFieldEditor FieldName="field2"  DataType="System.String" />
            </FieldEditors>
        </telerik:RadFilter>
        <br />
        <br />
     
    </div>
    <telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0" GridLines="None"
        AllowAutomaticInserts="True"
        DataSourceID="SqlDataSource1" 
        ShowGroupPanel="True">
<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>
 
<MasterTableView AutoGenerateColumns="False" DataSourceID="SqlDataSource1" >
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
 
<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
</RowIndicatorColumn>
 
<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
</ExpandCollapseColumn>
 
    <Columns>
        <telerik:GridBoundColumn DataField="MachineName"
            FilterControlAltText="Filter MachineName column" HeaderText="MachineName"
            SortExpression="MachineName" UniqueName="MachineName">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="OperatingSystem"
            FilterControlAltText="Filter OperatingSystem column"
            HeaderText="OperatingSystem" SortExpression="OperatingSystem"
            UniqueName="OperatingSystem">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Location"
            FilterControlAltText="Filter Location column" HeaderText="Location"
            SortExpression="Location" UniqueName="Location">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="IPAddress"
            FilterControlAltText="Filter IPAddress column" HeaderText="IPAddress"
            SortExpression="IPAddress" UniqueName="IPAddress" Visible=false>
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Site_Name"
            FilterControlAltText="Filter Site_Name column" HeaderText="Site_Name"
            SortExpression="Site_Name" UniqueName="Site_Name" >
        </telerik:GridBoundColumn>
      
         <telerik:GridBoundColumn DataField="Status_ID"
            FilterControlAltText="Filter Status_ID column" HeaderText="Status_ID"
            SortExpression="Status_ID" UniqueName="Status_ID" Visible=false >
        </telerik:GridBoundColumn>
    </Columns>
 
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
</MasterTableView>
 
        <ClientSettings AllowDragToGroup="True">
            <Scrolling AllowScroll="True" UseStaticHeaders="True" />
        </ClientSettings>
 
<FilterMenu EnableImageSprites="False" DataValueField="Location"></FilterMenu>
    </telerik:RadGrid>
    <telerik:RadAjaxManager runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadGrid1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:sitemgrConnectionString %>"
        SelectCommand="TELRIK" SelectCommandType="StoredProcedure">
    </asp:SqlDataSource>
    </form>
</body>
</html>
The code i am using to create dataset..
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Telerik.Web.UI;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class _Default : System.Web.UI.Page
{
    string conStr = ConfigurationManager.ConnectionStrings["conn44"].ConnectionString;
 
    
    
    protected void Page_Load(object sender, EventArgs e)
    {
 
         
            RadGrid1.GroupingSettings.CaseSensitive = false;
            RadGrid1.ShowGroupPanel = true;
            RadGrid1.ClientSettings.AllowDragToGroup = true;
 
            RadFilterTextFieldEditor editor1 = new RadFilterTextFieldEditor();
            RadFilter1.FieldEditors.Add(editor1);
            editor1.FieldName = "field1";
            editor1.DataType = typeof(string);
            editor1.DisplayName = "field1";
 
           RadFilterTextFieldEditor editor2 = new RadFilterTextFieldEditor();
            RadFilter1.FieldEditors.Add(editor2);
            editor2.FieldName = "field2";
            editor2.DataType = typeof(string);
            editor2.DisplayName = "field2";
         
  
    }
 
    protected void RadFilter1_ApplyExpressions(object sender, RadFilterApplyExpressionsEventArgs e)
    {
        RadFilterSqlQueryProvider provider = new RadFilterSqlQueryProvider();
        provider.ProcessGroup(e.ExpressionRoot);
        Label1.Text = provider.Result;
    }
}
Ajax
Mira
Telerik team
 answered on 28 Sep 2011
Narrow your results
Done
Selected tags
Tags
Grid
General Discussions
Editor
Scheduler
ComboBox
Ajax
Window
TreeView
Menu
Calendar
Chart (Obsolete)
TabStrip
Input
Dock
ToolTip
Upload (Obsolete)
AsyncUpload
WebParts for SharePoint
PanelBar
FileExplorer
Splitter
ListBox
Chart (HTML5)
Rotator
ListView
Button
ToolBar
TreeList
Sharepoint Integration
FormDecorator
Filter
Slider
ScriptManager and StyleSheetManager
UI for ASP.NET AJAX in ASP.NET MVC
AutoCompleteBox
PivotGrid
Installer and VS Extensions
Spell
Documentation and Tutorials
ImageEditor
Captcha
RibbonBar
DropDownList
OrgChart
Visual Style Builder
DropDownTree
Gantt
ColorPicker
Notification
BinaryImage
SkinManager
TileList
Wizard
SearchBox
Spreadsheet
Map
ImageGallery
Rating
DatePicker
MediaPlayer
XmlHttpPanel
Diagram
Compression
DataPager
SiteMap
CloudUpload
LightBox
Gauge
PageLayout
AjaxLoadingPanel
Navigation
SocialShare
DataForm
Persistence Framework
ClientExportManager
ProgressArea
CheckBox
TagCloud
AjaxPanel
Barcode
NumericTextBox
ClientDataSource
PdfViewer
DateTimePicker
MultiColumnComboBox
MultiSelect
RadioButtonList
MaskedTextBox
Theme Builder
Styling
ProgressBar
DateInput
Chat
Licensing
ODataDataSource
MonthYearPicker
TimePicker
Accessibility
LinkButton
ToggleButton
Label
Localization
Security
DateRangePicker
TreeMap
ImageButton
InputManager
Timeline
Card
Drawer
PushButton
Ticker
Signature
Avatar
Switch
OTPInput
Breadcrumb
SplitButton
DragDropManager
Stepper
FloatingActionButton
Chip
ChipList
AIPrompt
Badge
SpeechToText
SmartPasteButton
+? more
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Learn how
4928 4929
4930
4931 4932
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Learn how
Want to show your ninja superpower to fellow developers?
Learn how