DGC.Data Programmer's Reference

IDal.GetProcedureXML Method (String, ArrayList)

Executes a Stored Procedure using the supplied parameters and returns the XML results in a String variable.

[Visual Basic]
Function GetProcedureXML( _
   ByVal storedProcedureName As String, _
   ByVal parameters As ArrayList _
) As String
[C#]
string GetProcedureXML(
   string storedProcedureName,
   ArrayList parameters
);

Parameters

storedProcedureName
The name of the Stored Procedure to execute.
parameters
An ArrayList containing DALParameter objects.

Return Value

A String containing the XML results.

Remarks

Example

The following example executes a stored procedure and populates a typed DataTable. 

[Visual Basic] 
    Dim d As DGC.Data.IDAL 
    Dim params as New ArrayList 
    Dim xmlResults as String 

    d = DGC.Data.DALFactory.GetDAL(connectionString, databaseType) 

    params.Add(d.CreateParameter("@pId", ParameterTypes.DalInteger, ParameterDirections.DalInput, idToMatch) 

    xmlResults = d.GetProcedureXML("dbo.usp_getXMLResults", params)

See Also

IDal Interface | DGC.Data Namespace | IDal.GetProcedureXML Overload List