We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

QueryString With Int Column

Thread ID:





130754 May 31,2017 10:39 AM UTC Jun 2,2017 04:40 AM UTC ASP.NET MVC 3
Tags: Grid
osama gamal
Asked On May 31, 2017 10:39 AM UTC


     I need to make a child grid using  ODataV4Adaptor , but the problem is my relation field is int and the querystring property generates filter with tolower options

     which cannot work with the int 


Mani Sankar Durai [Syncfusion]
Replied On June 1, 2017 11:46 AM UTC

Hi osama, 

Thanks for contacting Syncfusion support. 

We have analyzed your query and we have prepared a sample based on your requirement that can be downloaded from the below link. 
In this sample we have make the child grid based on filtering the integer column from the parent grid. 
Refer the code example. 
                .Datasource(ds => { ds.URL("/odata/Employees").Adaptor(AdaptorType.ODataV4Adaptor); }) 
  .PageSettings(page => page.PageSize(4)) 
        .Columns(col => 
            col.Field("EmployeeID").HeaderText("Employee ID").Add();  //integer column 
            col.Field("TerritoryID").HeaderText("Territory ID").Add(); 
                    .ChildGrid(child => 
                        child.Datasource(da => da.URL("/odata/Orders").Adaptor(AdaptorType.ODataV4Adaptor)) 
                        .QueryString("EmployeeID")   //passing integer column in QueryString 
                        .Columns(col => 
NORTHWNDEntities db = new NORTHWNDEntities(); 
        public IQueryable<EmployeeTerritory> Get() 
            return db.EmployeeTerritories; 

Refer the screenshot below that it takes the correct int values to filter and bind the data for childgrid 

If you still face the issue please get back to us with the following details. 
1.       Share the screenshot/ video of the issue that you have faced. 
2.       You have mentioned that it passed as tolower option. Could you please send some more details regarding this with exact scenario? 
3.       Share the version details that you are using. 
4.       If possible please reproduce the issue in the above attached sample. 
The provided information will help us to analyze the issue and provide you the response as early as possible. 

Please let us know if you need further assistance. 

Manisankar Durai. 

osama gamal
Replied On June 1, 2017 01:46 PM UTC

Hello Mani

Sorry about that the error was mine 

Mani Sankar Durai [Syncfusion]
Replied On June 2, 2017 04:40 AM UTC

Hi Osama, 

Thanks for the update. 

Please let us know if you need further assistance. 

Manisankar Durai. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon