Query Database

Description

Queries the database with any valid sql query and returns the dataset as a string in XML format.

Syntax

public virtual string QueryDatabase(string sql)

Parameters

Name	Type	Description
sql	string	A string that contains the where clause of the SQL statement you want to query.

Output

An XML string that contains the dataset with the results of the database query.

Example

IWFWorkflowService svc = GetWorkflowService();
string sql = "SELECT * FROM WF_AUDIT_TRAILS where CATEGORY = 0 AND
PURPOSE='Check-in process definition'";

try
	{
    // calling the QueryDatabase webmethod and passing the sql query as the argument.
    string xml = svc.QueryDatabase(sql);
    Console.WriteLine("{0}", xml);// Displaying the XML string on console.
    System.IO.stringReader sr = new System.IO.stringBuilder(xml);
    System.Data.DataSet ds = new System.Data.DataSet();
    ds.LoadXml(sr);
	}

catch (Exception ex)
	{
    Console.WriteLine("Failed! " + ShUtil.GetSoapMessage(ex));
	}

Supported Versions

3.2.0.4 and higher

Parent topic: Other Web Services