private void Page_Load(object sender, System.EventArgs e)
{
localhost.procedures oWSProcs = null;
int nReturnValue;
XmlElement[] oXmlResult = null;
DataSet ds = null;
StringBuilder sOutput = new StringBuilder();
try
{
// instantiate our web service
oWSProcs = new localhost.procedures();
// call stored proc number 1
sOutput.Append("CustOrderHist StoredProcedure Results -----------");
oXmlResult = WSLib.GetXmlFromObjectArray(oWSProcs.CustOrderHist(txtParm1.Text));
ds = WSLib.FormatDataToBuffer("CustOrderHist", oXmlResult, sOutput);
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
// call our template
sOutput.Append("GetAllCustomers Template Results -----------");
oXmlResult = WSLib.GetXmlFromObjectArray(oWSProcs.GetAllCustomers());
ds = WSLib.FormatDataToBuffer("GetAllCustomers", oXmlResult, sOutput);
DataGrid2.DataSource = ds;
DataGrid2.DataBind();
}
catch (Exception err)
{
ErrorPage = "Error Retrieving Results" + err.Message;
}
}
/// <summary>
/// Simply formats the output into a string builder so that its contents can be dumped to screen
/// </summary>
/// <param name="sProcName"></param>
/// <param name="oXmlResult"></param>
/// <param name="sOutput"></param>
/// <returns></returns>
public static DataSet FormatDataToBuffer(string sProcName, XmlElement[] oXmlResult, StringBuilder sOutput)
{
DataSet ds = null;
StringWriter oWriter;
for (int i = 0; i < oXmlResult.Length; i++)
{
sOutput.Append(sProcName + " Results Schema -----------");
// now hydrate our dataset... schema and all
if (oXmlResult[i] != null)
{
ds = WSLib.GetDataSetFromXmlFragment(oXmlResult[i]);
oWriter = new StringWriter();
ds.WriteXml(oWriter, XmlWriteMode.WriteSchema);
// send the schema to screen
sOutput.Append(oWriter.ToString());
}
}
return(ds);
}
