System and method for generating a parameterized query

• US 20050171934A1
• Filed: 01/30/2004
• Published: 08/04/2005
• Est. Priority Date: 01/30/2004
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Cote, Antoine, Yuknewicz, Paul
• Application Number:
  US10/768,525
• Publication Number:
  US 20050171934A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence

Abstract

A user may select a dataset and choose whether to select an existing parameterized query or to define a new parameterized query to execute upon the selected dataset. If the user chooses to select an existing parameterized query, then a set of existing parameterized queries corresponding to the dataset may be identified and displayed to the user. If the user chooses to define a new parameterized query, then the new parameterized query may easily be merged into the set of existing parameterized queries corresponding to the dataset. In response to the generation of a parameterized query, input fields may be readily provided that enable the user to set the value of query parameters. Thus, the user may easily and efficiently add searching and filtering capabilities in connection with an application.

Claims

1. A method for generating a parameterized query that includes a query parameter that is set by a user to retrieve selected data from a dataset, the method comprising:

providing an interface that enables the user to select the parameterized query from a set of available parameterized queries associated with the dataset; and

providing an input field that enables the user to set the query parameter.

2. The method of claim 1, further comprising providing an interface that enables the user to select the dataset.

3. The method of claim 1, further comprising identifying the set of available parameterized queries.

4. The method of claim 3, wherein identifying the set of available parameterized queries comprises identifying a default parameterized query associated with the dataset.

5. The method of claim 3, wherein identifying the set of available parameterized queries comprises identifying stored procedures associated with the dataset.

6. The method of claim 1, comprising providing an input field that enables the user to set the query parameter to a constant value.

7. The method of claim 1, further comprising validating that the query parameter is a valid parameter type.

8. The method of claim 1, further comprising generating code for calling the parameterized query including the set query parameter.

9. The method of claim 8, further comprising executing the parameterized query including the set query parameter.

10. The method of claim 1, further comprising generating a data component for executing the parameterized query at a corresponding data source.

11. The method of claim 10, further comprising populating a display object with the results of the executed parameterized query.

12. The method of claim 10, further comprising populating one of a grid control view and a details view with the results of the executed parameterized query.

13. The method of claim 1, further comprising generating a data component for executing the parameterized query against a corresponding data source.

14. A computer readable medium having computer-executable instructions for performing the steps recited in claim 1.

15. A method for generating a parameterized query that includes a query parameter that is set by a user to retrieve selected data from a dataset, the method comprising:

providing an interface that enables a user to define the parameterized query; and

providing an input field that enables the user to set the query parameter.

16. The method of claim 15, further comprising providing an interface that enables the user to select the dataset.

17. The method of claim 15, further comprising generating a sample parameterized query structure including an exemplary query parameter corresponding to a portion of the dataset.

18. The method of claim 15, further comprising validating the parameterized query by determining that the query parameter corresponds to an existing portion of the dataset.

19. The method of claim 15, further comprising storing the parameterized query in a set of parameterized queries associated with the dataset.

20. The method of claim 15, comprising providing an input field that enables the user to set the query parameter to a constant value.

21. The method of claim 15, further comprising validating that the query parameter is a valid parameter type.

22. The method of claim 15, further comprising generating code for calling the parameterized query including the set query parameter.

23. The method of claim 15, further comprising executing the parameterized query including the set query parameter.

24. The method of claim 23, further comprising populating a display object with the results of the executed parameterized query.

25. The method of claim 23, further comprising populating one of a grid control view and a details view with the results of the executed parameterized query.

26. The method of claim 15, further comprising generating a data component for executing the parameterized query against a corresponding data source.

27. A computer readable medium having computer-executable instructions for performing the steps recited in claim 15.

28. A method for generating a parameterized query that includes a query parameter that is set by a user to retrieve selected data from a dataset, the method comprising:

providing an interface that enables the user to choose one of defining a new parameterized query and selecting an existing parameterized query;

if the user chooses to define a new parameterized query, then providing a user interface that enables a user to define the parameterized query;

if the user chooses to select an existing parameterized query, then;

identifying a set of available parameterized queries associated with the dataset; and

providing a user interface that enables the user to select the parameterized query from the set of available parameterized queries; and

providing an input field that enables the user to set the query parameter.

29. The method of claim 28, further comprising providing an interface that enables the user to select the dataset.

30. The method of claim 28, further comprising further comprising generating a sample parameterized query structure including an exemplary query parameter corresponding to a portion of the dataset.

31. The method of claim 28, further comprising validating the parameterized query by determining that the query parameter corresponds to an existing portion of the dataset.

32. The method of claim 28, further comprising storing the new parameterized query in a set of parameterized queries associated with the dataset.

33. The method of claim 28, comprising providing an input field that enables the user to set the query parameter to a constant value.

34. The method of claim 28, further comprising validating that the query parameter is a valid parameter type.

35. The method of claim 28, further comprising generating code for calling the parameterized query including the set query parameter.

36. The method of claim 28, further comprising executing the parameterized query including the set query parameter.

37. The method of claim 36, further comprising populating a display object with the results of the executed parameterized query.

38. The method of claim 28, wherein identifying the set of available parameterized queries comprises identifying a default parameterized query associated with the dataset.

39. The method of claim 28, wherein identifying the set of available parameterized queries comprises identifying stored procedures associated with the dataset.

40. The method of claim 28, further comprising generating a data component for executing the parameterized query against a corresponding data source.