Re: Searching within a Data Connection

Clay Fox — Sat, 12 Apr 2008 14:06:54 GMT

I believe you can use a static query with SharePoint but often a dynamic query is what you are looking for.

I use web services on SQL to be able to dynamicly query anything I want and sort without needing code. I do not think there is a way to really have dynamic queries with SharePoint, that is one of the limitations, besides no relational data capability and performance issues for scalability.

There may be some code for this out there somewhere, I know you can load all of the data in and then transfer it into a node in your main schema and sort and filter it there to prep it for your dropdown but that is a pan but one option.

Searching within a Data Connection

Cutejon — Sat, 12 Apr 2008 12:09:31 GMT

Hi everyone,

my scenario is this :

1. data connection connects to a sharepoint list / document library.

2. The results returned by the data connection must further be examined so that a subset of data will only be taken, which is based on conditions/parameters set by user.

3. Code done in VBscript.

is it possible to query the mentioned data connection?

As I have seen in some posts, this can be done via ADOQueryConnection, which is only applicable to data connections using SQL database. Just plug in the SQL statement then viola, results are returned. (as stated in this help file: ms-help://MS.VSTACC.v80/MS.IPVSTA12.12.1033/IPVSTA12/html/4b06c377-52fc-ffeb-7b15-d5fb0e286da5.htm)

'----------------------------Code in help file ----------------------------------------------------

   ' Get the Employees connection from the
   ' DataConnections collection.
   Dim myAdoQueryConnection As AdoQueryConnection = DirectCast(Me.DataConnections("Employees"), AdoQueryConnection)

   ' Get the employee's ID from the EmpID field in
   ' the main data source.
   Dim myNav As XPathNavigator = CreateNavigator().SelectSingleNode("/my:myFields/my:EmpID", NamespaceManager)
   Dim employeeID As String = myNav.InnerXml

   ' Change the SQL command for Employees connection to retrieve
   ' the record of the Employee's ID entered by the user.
   myAdoQueryConnection.Command = "select * from [Employees] where [EmployeeID] = " + employeeID

   ' Execute the updated command against the data connection to
   ' refresh the data.
    myAdoQueryConnection.Execute()
'----------------------------End of Code-------------------------------------------------------------------

But my backend data store is sharepoint. What code / class do i need to use to do this?

If yes, can you also have these results sorted the way you wanted? (coz this will speed up my data manipulation)

If you have/can share these codes its much appreciated!

Jon

Data Connections

Re: Searching within a Data Connection

Searching within a Data Connection