Methods / Other Web Services |
Queries the database with any valid SQL query and returns an array of 2 elements in XML string format.
Name | Type | Description |
---|---|---|
sql | string | A string that contains the where clause of the SQL statement you want to query. |
2 elements in a string array, where string[0] is an XML string with the dataset of the query results and string[1] is an XML string with the schema.
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[] xmls = svc.QueryDatabase(sql); Console.WriteLine("{0}", xmls[0]);// Displaying the XML string on console. Console.WriteLine("{0}", xmls[1]);// Displaying the schema on console. } catch (Exception ex) { Console.WriteLine("Failed! " + ShUtil.GetSoapMessage(ex)); }