Hi John,
Thanks for the update.
Query: “Is there any documentation that you can provide us on how to control paging, sorting and searching against the Data Manager outside of a Data Grid? ”
Refer our UG documentation and online demo using the Data manager with custom binding. Refer the below links for your reference
Please get back to us if you have further queries.
Query: “Do all controls such as ListView, TreeGrid, TreeView, Schedule, Charts, Pivot table, DropDownList, ComboBox, AutoComplete , MultiSelect support the Query property like DataGrid? && Is that I we should roll our own pager?”
Yes. All the databinding controls will have Query properties based on which the datasource can be handled for Paging, Filtering, Sorting etc. We will implement a standalone Pager component in any of our upcoming releases. Once it is rolled out you can integrate with other components to perform data operations and display pager in specific controls.
Query: “Are there any examples that you can share that show working with DataManagerRequest and the DataManager Execute function ?”
As per your request we have prepared a sample using DataManagerRequest (i.e.) CustomAdaptor with Execute method. Refer the below code example.
|
<SfGrid TValue="Order" AllowSorting="true" AllowFiltering="true" AllowPaging="true">
<SfDataManager @ref="DataManagerRef" AdaptorInstance="@typeof(CustomAdaptor)" Adaptor="Adaptors.CustomAdaptor"></SfDataManager>
. . . . . . .
</SfGrid>
@code{
public static List<Order> Orders { get; set; }
SfDataManager DataManagerRef { get; set; }
. . . .
public async Task Data()
{
//generate our own query and return data.
object t = await DataManagerRef.ExecuteQuery<Order>(new Query().Skip(5).Take(4));
//deserialize the object to List of Objects.
var data = JsonConvert.DeserializeObject<List<Order>>(JsonConvert.SerializeObject(t));
//to fetch the data externally like stand alone datamanager component
}
// Implementing custom adaptor by extending the DataAdaptor class
public class CustomAdaptor : DataAdaptor
{
// Performs data Read operation
public override object Read(DataManagerRequest dm, string key = null)
{
IEnumerable<Order> DataSource = Orders;
int count = DataSource.Cast<Order>().Count();
DataSource = DataOperations.Execute<Order>(DataSource, dm);
return dm.RequiresCounts ? new DataResult() { Result = DataSource, Count = count } : (object)DataSource;
}
}
|
Kindly download the sample from below
Please get back to us if you have further queries.
Regards,
Vignesh Natarajan
