QueryResult.QueryResults Property
Retrieves an array of query results.
Namespace: Microsoft.Web.Management.DatabaseManager
Assembly: Microsoft.Web.Management.DatabaseManager (in Microsoft.Web.Management.DatabaseManager.dll)
Syntax
'Declaration
Public ReadOnly Property QueryResults As ArrayList
'Usage
Dim instance As QueryResult
Dim value As ArrayList
value = instance.QueryResults
public ArrayList QueryResults { get; }
public:
property ArrayList^ QueryResults {
ArrayList^ get ();
}
function get QueryResults () : ArrayList
Property Value
Type: System.Collections.ArrayList
The ArrayList of QueryResult objects.
Examples
The following code sample illustrates an example ExecuteQuery method that returns an array of query results from a database query.
Public Overrides Function ExecuteQuery( _
ByVal connectionString As String, _
ByVal query As Microsoft.Web.Management.DatabaseManager.Query) _
As Microsoft.Web.Management.DatabaseManager.QueryResult()
Dim results As List(Of QueryResult) = New List(Of QueryResult)
Dim result As QueryResult = New QueryResult
Try
' Create a new OLEDB connection using the connection string.
Dim connection As OleDbConnection = New OleDbConnection(connectionString)
Dim command As OleDbCommand = New OleDbCommand(query.Statement, connection)
' Open the database connection.
connection.Open()
' Execute the query and access the data.
Dim reader As OleDbDataReader = command.ExecuteReader
' Add the results to the query list.
results.Add(GetQueryResult(reader))
' Close the database connection.
reader.Close()
' Return the query results.
Return results.ToArray
Catch ex As Exception
Throw New ProviderException(ex.Message)
End Try
End Function
...
Private Function GetQueryResult(ByVal reader As OleDbDataReader) As QueryResult
Dim result As QueryResult = New QueryResult
Dim fieldCount As Integer = reader.FieldCount
Dim i As Integer = 0
Do While (i < fieldCount)
Dim metadata As QueryColumnMetadata = New QueryColumnMetadata
metadata.Name = reader.GetName(i)
result.ColumnMetadata.Add(metadata)
i = (i + 1)
Loop
While reader.Read
Dim itemData() As Object = New Object((fieldCount) - 1) {}
i = 0
Do While (i < fieldCount)
itemData(i) = ConvertToSerializable(reader(i))
i = (i + 1)
Loop
result.QueryResults.Add(itemData)
End While
Return result
End Function
public override QueryResult[] ExecuteQuery(
string connectionString,
Query query )
{
List<QueryResult> results = new List<QueryResult>();
QueryResult result = new QueryResult();
try
{
// Create a new OLEDB connection using the connection string.
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
OleDbCommand command = new OleDbCommand(query.Statement, connection);
// Open the database connection.
connection.Open();
// Execute the query and access the data.
OleDbDataReader reader = command.ExecuteReader();
// Add the results to the query list.
results.Add(GetQueryResult(reader));
// Close the database connection.
reader.Close();
}
// Return the query results.
return results.ToArray();
}
catch(Exception ex)
{
throw new ProviderException(ex.Message);
}
}
...
private QueryResult GetQueryResult(OleDbDataReader reader)
{
QueryResult result = new QueryResult();
int fieldCount = reader.FieldCount;
for (int i = 0; i < fieldCount; i++)
{
QueryColumnMetadata metadata = new QueryColumnMetadata();
metadata.Name = reader.GetName(i);
result.ColumnMetadata.Add(metadata);
}
while (reader.Read())
{
object[] itemData = new object[fieldCount];
for (int i = 0; i < fieldCount; i++)
{
itemData[i] = ConvertToSerializable(reader[i]);
}
result.QueryResults.Add(itemData);
}
return result;
}
Permissions
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.