Retrieve value on server side with Custom Object, ISDataSource and AllowAutoQueryHandler=false

pchanez — Fri, 06 Nov 2009 08:42:05 GMT

My custom objects are datacontract retrieve through WCF ... but you could simulate this with any custom object.

Ok ... Setting the DataSourceId in the InitializeDataSource solves the issue

Retrieve value on server side with Custom Object, ISDataSource and AllowAutoQueryHandler=false

handy@intersoftpt.com — Fri, 06 Nov 2009 05:27:37 GMT

Hi,

AllowAutoQueryHandler=false only works for some condition.

First, for binding OnIntializeDataSource.

Second, only can work on ISDataSource control or ObjectDatasource control because oly those controls who support Paging.

It seems you are missing some method which need to be run when using ISDataSource.

Could you please let me know more detail about your Custom Object?

Regards,
Handy

Retrieve value on server side with Custom Object, ISDataSource and AllowAutoQueryHandler=false

pchanez — Thu, 05 Nov 2009 11:36:32 GMT

I have a webcombo linked to an ISDatasource retrieving data from custom object. When I'm using AllowAutoQueryHandler = true, everything is working fine, but if I set this property to false, the value of the combo and the text is empty ... (everything else ie data retrieval, ... is working fine ... juste the value is not populated during the post)

Do you have an idea ? I'm using the latest version of both components

Here's some extract from the code

<ISDataSource:ISDataSource ID="idsStockOwner" runat="server"
SchemaType="CustomObject">
<Tables>
<ISDataSource:ISDataSourceTable
SelectMethod="SelectWithPaging"
SelectCountMethod="SelectCount"
EnablePaging="True"
TableName="StockOwners"
TypeName="Pmi.ITrack.Web.StockOwnerComboProvider"
>
<SelectParameters>
<asp:ControlParameter Name="additionalSearchFields" ControlID="wcStockOwners" PropertyName="AdditionalSearchFields" ></asp:ControlParameter>
<asp:ControlParameter Name="textField" ControlID="wcStockOwners" PropertyName="DataTextField" ></asp:ControlParameter>
</SelectParameters>
</ISDataSource:ISDataSourceTable>
</Tables>
</ISDataSource:ISDataSource>

<ISWebCombo:WebCombo ID="wcStockOwners" runat="server"
DataMember="StockOwners" DataSourceID="idsStockOwner" Height="20px"
UseDefaultStyle="True" Width="200px" DataTextField="Name"
DataValueField="BusinessEntityId"
AllowAutoQueryHandler="false"
>
</ISWebCombo:WebCombo>

C# part :

[System.ComponentModel.DataObject()]
public class StockOwnerComboProvider : ILoadOnDemandDropDownDataSource<StockOwner>
{
#region ILoadOnDemandDropDownDataSource<StockOwner> Members

public int SelectCount(string queryText, string textField, string additionalSearchFields)
{
return StockOwner.CountStockOwners
(
LogicalOperator.Or,
Pmi.ITrack.Web.ServerControls.DropDownList.DropDownList.BuildSearchCriteriaList(textField, additionalSearchFields, queryText),
false
);
}

[System.ComponentModel.DataObjectMethod(System.ComponentModel.DataObjectMethodType.Select)]
public List<StockOwner> SelectWithPaging(int maximumRows, int startRowIndex, string queryText, string textField, string additionalSearchFields)
{
if (maximumRows > 0)
{
var ordering = new List<OrderingCriteria>()
{
new OrderingCriteria("Code", OrderingDirection.Ascending),
new OrderingCriteria("Name", OrderingDirection.Ascending)
};

return StockOwner.SearchStockOwners
(
LogicalOperator.Or,
Pmi.ITrack.Web.ServerControls.DropDownList.DropDownList.BuildSearchCriteriaList(textField, additionalSearchFields, queryText),
false,
ordering,
maximumRows,
startRowIndex
).ToList();
}
else
{
return new List<StockOwner>();
}
}

#endregion
}

Intersoft Community - WebCombo - Retrieve value on server side with Custom Object, ISDataSource and AllowAutoQueryHandler=false

Retrieve value on server side with Custom Object, ISDataSource and AllowAutoQueryHandler=false

Retrieve value on server side with Custom Object, ISDataSource and AllowAutoQueryHandler=false

Retrieve value on server side with Custom Object, ISDataSource and AllowAutoQueryHandler=false