/// <summary> /// 调用外观对象,并将请求结果以自定义的XML序列化方式打包; /// </summary> /// <param name="facade"></param> /// <param name="sql"></param> /// <returns></returns> public XmlDocument GetCurrency(string sql) { if (facade == null) { throw new ArgumentNullException("facade"); } if (string.IsNullOrEmpty(sql)) { throw new ArgumentNullException("sql"); } DbDataReader reader = facade.ExecuteQuery(sql); if (!reader.HasRows) { return(null); } XmlDocument doc = new XmlDocument(); XmlElement root = doc.CreateElement("root"); doc.AppendChild(root); while (reader.Read()) { XmlElement element = doc.CreateElement("currency"); element.SetAttribute("code", reader.GetString(0)); // currency code element.SetAttribute("name", reader.GetString(1)); // currency code root.AppendChild(element); } return(doc); }
private void btnQuery_Click(object sender, EventArgs e) { DataSet result = remObj.ExecuteQuery(txtQuery.Text); if ((result == null) || (result.Tables[0].Rows.Count == 0)) { return; } txtMessage.Text = ""; StringBuilder sb = new StringBuilder(); for (int i = 0; i < 10; i++) { sb.Append(Convert.ToString(result.Tables[0].Rows[i][1]) + Environment.NewLine); } txtMessage.Text = sb.ToString(); }