HomeActive Query BuilderRead/Write Data in Criteria Grid programmatically

Read/Write Data in Criteria Grid programmatically


I use the Free Version of Active Query Builder for .NET C# and want to know if it is possible to read or write Data in the Criteria Grid programatically or to set parameters for the filter like it is in the Visual Studio Query Designer ("@filter", ":filter"...).

I only found how to change Options in the QueryBuilder.CriteriaListOption.
Praktikant
May 10 2011, 09:48 AM
ok i found it :)

UnionSubQuery.BeginUpdate();
queryBuilder1.Query.FirstSelect().CriteriaList[0].ConditionStrings[0]=" = criteria"
unionSubQuery.EndUpdate();
Praktikant
22 hours, 30 mins since original post
That's right. And you may use parameters here: "= :param". The @param notation is supported by MS SQL Server syntax only.

You may explore the QueryBuilder.Parameters collection before the query execution to check if the query has params and prompt the end-user for their values.
Sergey Smagin | email
1 day, 17 hours since original post
This topic is closed