ExecuteQuery

Description

Execute a query in the database and get the result back as dataset

Signature
DataSet ExecuteQuery(string key, SurveyQuery query)

Parameters

Name Data Type Description

key

string required

The authentication key

query

SurveyQuery required

The query.

Response

Data Type Description

DataSet

The result from the query.

Example

//***************************************************
//
// ExecuteQuery
//
//***************************************************

// Initiate webservice
SurveyDataSoapClient sd = new SurveyDataSoapClient();

// Initiate a new query
SurveyQuery query = SurveyDataUtil.NewSurveyQuery(
    "mysurveyquery",
    SurveyDataUtil.NewQueryProject(projectID,
    DatabaseType.Production));

// Add select statement
SelectStatement select = SurveyDataUtil.NewSelectStatement();
query.SelectStatements =
    (SelectStatement[])SurveyDataUtil.Add(query.SelectStatements,select,typeof(SelectStatement));

// Add select-clauses
select.SelectClause = new SelectClause();
select.SelectClause.SelectItems =
    (object[])SurveyDataUtil.Add(select.SelectClause.SelectItems,
    SurveyDataUtil.NewQueryForm("s1"),
    typeof(object));
select.SelectClause.SelectItems =
    (object[])SurveyDataUtil.Add(select.SelectClause.SelectItems,
    SurveyDataUtil.NewQueryField("m2_1"),
    typeof(object));

// Add where-clause (s1 = '2')
select.WhereClause = new WhereClause();
select.WhereClause.Item =
    SurveyDataUtil.NewBinaryComparison(
    ComparisonType.Equal,
    SurveyDataUtil.NewQueryForm("s1"),
    SurveyDataUtil.NewQueryConstant(
    ConfirmitDbType.VarChar,"2"));

// Delete all respondents
DataSet ds = sd.ExecuteQuery(key,query);