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); }