open access data source where clause

[bharat veer]

i have open access data source control on my page.
with the help of this control i am binding drop down list.
oadsUnit is the object of open access data source.
rcbUnit   is the object of dropdownlist.
                oadsUnit.ObjectContextProvider = "project.Data.Orm.ProjectModel, project.Data.Orm";
                oadsUnit.TypeName = "project.Data.Orm.SystemList";
                oadsUnit.Where = "ListType = \"uofm\" ";
                oadsUnit.EnableDelete = false;
                oadsUnit.EnableInsert = false;
                oadsUnit.EnableUpdate = false;
                oadsUnit.StoreOriginalValuesInViewState = false;
                rcbUnit.DataSourceID = "oadsUnit";
                rcbUnit.DataValueField = "SystemListID";
                rcbUnit.DataTextField = "ListName";
                rcbUnit.DataBind();
                rcbUnit.Items.Insert(0, new RadComboBoxItem("Select Unit...", "0"));

i have a query in my sqlserver like this

select  *  from systemlist
where listtype='uofm' and systemlistid not in
(select unitlistid from itemunit where itemid=2014)

  oadsUnit.Where = "ListType = \"uofm\" ";
   in this where property how can above mentioned sql query can be given as a string.


             

[Damyan Bogoev]

Hello bharat veer,

You could find the following articles useful:
-    The IN Extent Clause;
-    The EXISTS Keyword;
They demonstrate how to use the EXISTS and IN clauses in OQL queries.
Hope that helps.

Regards,
Damyan Bogoev
the Telerik team