</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">FlexPivot for WinForms</div> <div id="PageTitle"><div id="PageTitleText">query(String,Object) Method</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span><!-- Spacing --> <span id="LanguageFilterPopupLink" class="PopupLink" data-popupcontentsource="#LanguageCheckboxes" data-popuptitle='Language Filter'> <label id="ShowAllLabel" for="LanguageFilterPopupLink"> Language Filter: All </label> <label id="MultipleLabel" for="LanguageFilterPopupLink" style="display: none;"> Language Filter: Multiple </label> <label id="VBAllLabel" for="LanguageFilterPopupLink" style="display: none;"> Language Filter: Visual Basic </label> <label id="VBLabel" for="LanguageFilterPopupLink" style="display: none;">Language Filter: Visual Basic (Declaration)</label> <label id="CSLabel" for="LanguageFilterPopupLink" style="display: none;">Language Filter: C#</label> </span> <div class="PopupContent" id="LanguageCheckboxes"> <input data-languagename="VB" id="VBLanguageCheckbox" type="checkbox" class="ToggleLanguageCheckbox" checked="true" data-toggleclass="FilteredContentVB"> <label class="LanguageFilter" for="VBCheckbox"> Visual Basic (Declaration) </label> <br><input data-languagename="CS" id="CSLanguageCheckbox" type="checkbox" class="ToggleLanguageCheckbox" checked="true" data-toggleclass="FilteredContentCS"> <label class="LanguageFilter" for="CSCheckbox"> C# </label> </div> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="C1.DataEngine.4.html">C1.DataEngine.4 Assembly</a> > <a href="C1.DataEngine.4~C1.DataEngine_namespace.html">C1.DataEngine Namespace</a> > <a href="C1.DataEngine.4~C1.DataEngine.Workspace.html">Workspace Class</a> > <a href="C1.DataEngine.4~C1.DataEngine.Workspace~query.html">query Method</a> : query(String,Object) Method</td></tr></table></div> <div id="namePopupContent" class="PopupContent"> Name of the query. If the name is specified, query result is stored on disk. </div> <div id="settingsPopupContent" class="PopupContent"> Columns of the resut, and other settings of the query. </div> <div id="BodyContent"> <div class="DescriptionContent">Creates a query based on a single table or query (not a join).</div> <div class="SectionHeading" id="syntaxSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Syntax</span></div><div id="syntaxSectionContent" class="SectionContent"> <div class="TabContainer" id="TabContainer"> <ul> <li class="FilteredContentVBAll"><a href="#Syntax-VBAll">Visual Basic</a></li> <li class="FilteredContentCS"><a href="#Syntax-CS">C#</a></li> </ul> <div id="Syntax-VB" class="FilteredContentVB"> <pre>'Declaration Public Overloads Function query( _ ByVal <i><a class="PopupLink" id="namePopupLink" data-popupcontentsource="#namePopupContent" data-popupshowevent="click mouseenter">name</a></i> As System.String, _ ByVal <i><a class="PopupLink" id="settingsPopupLink" data-popupcontentsource="#settingsPopupContent" data-popupshowevent="click mouseenter">settings</a></i> As System.Object _ ) As System.Dynamic.ExpandoObject</pre> </div> <div id="Syntax-CS" class="FilteredContentCS"> <pre>public System.Dynamic.ExpandoObject query( System.string <i><a class="PopupLink" id="namePopupLink" data-popupcontentsource="#namePopupContent" data-popupshowevent="click mouseenter">name</a></i>, System.object <i><a class="PopupLink" id="settingsPopupLink" data-popupcontentsource="#settingsPopupContent" data-popupshowevent="click mouseenter">settings</a></i> )</pre> </div> </div> <h4 class="dxh4">Parameters</h4><dl><dt><i>name</i></dt> <dd>Name of the query. If the name is specified, query result is stored on disk.</dd><dt><i>settings</i></dt> <dd>Columns of the resut, and other settings of the query.</dd></dl> <h4 class="dxh4">Return Value</h4><div class="ReturnsContent">Dynamic object representing the query.</div></div> <div class="SectionHeading" id="remarksSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Remarks</span></div><div id="remarksSectionContent" class="SectionContent">The dynamic object can be used in queries over the result of this query if such are needed, same way as in <a href="C1.DataEngine.4~C1.DataEngine.Workspace~table.html">table</a> Also, it has a Query property that returns the <a href="C1.DataEngine.4~C1.DataEngine.Query.html">Query</a> object representing this query. It is used for executing the query: <code originaltag="code">dynamic query1 = workspace.query(...); query1.Query.Execute();</code></div> <a name="exampleBookmark"></a> <a name="seealsobookmark"></a> <div class="SectionHeading" id="seealsoSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">See Also</span></div><div id="seealsoSectionContent" class="SectionContent"><h4 class="subHeading">Reference</h4><p><a href="C1.DataEngine.4~C1.DataEngine.Workspace.html">Workspace Class</a> <br><a href="C1.DataEngine.4~C1.DataEngine.Workspace_members.html">Workspace Members</a> <br><a href="C1.DataEngine.4~C1.DataEngine.Workspace~query.html">Overload List</a> </p> </div> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved.</p> </div> </body> </html>