protected void Page_Load(object sender, EventArgs e) { DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); ds.ReadXml(@"D:\Books.xml"); bookgrd.DataSource = ds.Tables[0]; bookgrd.DataBind(); IEnumerable<DataRow> tbl1row = ds.Tables[0].AsEnumerable(); ds1.ReadXml(@"D:\Books2.xml"); IEnumerable<DataRow> tbl2row = ds1.Tables[0].AsEnumerable(); GridView1.DataSource = ds1.Tables[0]; GridView1.DataBind(); var items = tbl2row.AsEnumerable().Select(r => r.Field<string>("id")) .Except(tbl1row.AsEnumerable().Select(r => r.Field<string>("id"))); DataTable TableC = (from row in tbl2row.AsEnumerable() join id in items on row.Field<string>("id") equals id select row).CopyToDataTable(); GridView2.DataSource = TableC; GridView2.DataBind(); }
private void ArrayBinding_Load(object sender, System.EventArgs e) { // Access database System.Windows.Forms.DataVisualization.Charting.Utilities.SampleMain.MainForm mainForm = (System.Windows.Forms.DataVisualization.Charting.Utilities.SampleMain.MainForm)this.ParentForm; // The XML document string fileNameString = mainForm.applicationPath + "\\data\\data.xml"; string fileNameSchema = mainForm.applicationPath + "\\data\\data.xsd"; // Initializes a new instance of the DataSet class DataSet custDS = new DataSet(); // Reads an XML schema into the DataSet. custDS.ReadXmlSchema( fileNameSchema ); // Reads XML schema and data into the DataSet. custDS.ReadXml( fileNameString ); // Initializes a new instance of the DataView class DataView firstView = new DataView(custDS.Tables[0]); Chart1.Series.Clear(); // Since the DataView implements and IEnumerable, pass the reader directly into // the DataBindTable method with the name of the column used for the X value. Chart1.DataBindTable(firstView, "Name"); // Set series appearance Chart1.Series[0].ChartType = SeriesChartType.Bar; Chart1.Series[0].Font = new Font("Trebuchet MS", 8); Chart1.Series[0].Color = System.Drawing.Color.FromArgb(220, 224,64,10); Chart1.Series[0].BorderWidth = 0; }
public XmlToCsvUsingDataSet(string xmlSourceFilePath, bool autoRenameWhenNamingConflict) { XmlDataSet = new DataSet(); try { XmlDataSet.ReadXml(xmlSourceFilePath); foreach (DataTable table in XmlDataSet.Tables) { TableNameCollection.Add(table.TableName); } } catch (DuplicateNameException) { if (autoRenameWhenNamingConflict) { XmlDataSet.ReadXml(xmlSourceFilePath, XmlReadMode.IgnoreSchema); foreach (DataTable table in XmlDataSet.Tables) { TableNameCollection.Add(table.TableName); } RenameDuplicateColumn(); } else { throw; } } }
public virtual DataSet Parse(string fileName, Stream stream) { DataSet ds = new DataSet(); if (stream != null) { ds.ReadXml(stream); } else ds.ReadXml(fileName); return ds; }
public static DataTable DeserializeTable(string filename) { DataSet ds = new DataSet(); ds.Locale = System.Globalization.CultureInfo.InvariantCulture; if (File.Exists(GetPath(filename))) ds.ReadXml(GetPath(filename)); else ds.ReadXml(GetResource(filename)); DataTable dt = ds.Tables[0]; ds.Tables.Remove(dt); return dt; }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request.QueryString["dil"]) && !IsPostBack) { ImgKaydet.Visible = true; dil = (new CultureInfo(Convert.ToInt32(Request.QueryString["dil"]))).Name; if (Request.QueryString["dil"] != Snlg_ConfigValues.defaultLangId ) dosyaYolu = Server.MapPath("~/App_GlobalResources/default." + dil + ".resx"); else dosyaYolu = Server.MapPath("~/App_GlobalResources/default.resx"); DataSet ds = new DataSet(); DataTable dtOrj = new DataTable(); DataTable dtLang = new DataTable(); try { ds.ReadXml(Server.MapPath("~/App_GlobalResources/default.resx")); dtOrj.Merge(ds.Tables["data"]); dtOrj.PrimaryKey = new DataColumn[1] { dtOrj.Columns["name"] }; dtOrj.Columns.Add(new DataColumn("yeniDeger", System.Type.GetType("System.String"))); if (Request.QueryString["dil"] != Snlg_ConfigValues.defaultLangId ) { if (File.Exists(dosyaYolu)) { ds.Tables.Clear(); ds.ReadXml(dosyaYolu); dtLang.Merge(ds.Tables["data"]); foreach (DataRow dr in dtLang.Rows) { try { dtOrj.Rows.Find(dr["name"])["yeniDeger"] = dr["value"]; } catch { } } } } else foreach (DataRow dr in dtOrj.Rows) dr["yeniDeger"] = dr["value"]; dtLang = null; DataView dv = dtOrj.DefaultView; dv.Sort = "name"; Grid.DataSource = dv; Grid.DataBind(); } catch (Exception exc) { Snlg_Hata.ziyaretci.ExceptionLogla(exc); } } }
internal static void getLocalResource(string filePath, string languageCode, out System.Data.DataSet dataSet) { dataSet = null; string xmlFilePath = string.Empty; if (string.IsNullOrEmpty(filePath)) { filePath = System.Web.HttpContext.Current.Request.CurrentExecutionFilePath; } if (string.IsNullOrEmpty(languageCode)) { languageCode = commonVariables.SelectedLanguage; } xmlFilePath = System.Web.HttpContext.Current.Server.MapPath(@"~/App_Data/" + languageCode + @"/" + filePath + ".xml"); if (System.IO.File.Exists(xmlFilePath)) { dataSet = new System.Data.DataSet(); dataSet.ReadXml(xmlFilePath); } else { xmlFilePath = System.Web.HttpContext.Current.Server.MapPath(@"~/App_Data/en-us/" + filePath + ".xml"); if (System.IO.File.Exists(xmlFilePath)) { dataSet = new System.Data.DataSet(); dataSet.ReadXml(xmlFilePath); } } }
public Dictionary <string, string> getLicDetails(string licFile) { try { string path = licFile;// @"License.XML"; if (File.Exists(path)) { System.Data.DataSet _ds = new System.Data.DataSet(); XmlDocument xmlDoc = new XmlDocument(); xmlDoc = Helper.Encryption.getXmlData(path); _ds.ReadXml(new XmlTextReader(new System.IO.StringReader(xmlDoc.InnerXml))); guid = _ds.Tables[0].Rows[0]["GUID"].ToString(); if (_ds.Tables[0].Rows.Count > 0) { string macAddress = GetMACAddress(); // MessageBox.Show(macAddress); licDetailsDict.Add("MAC", _ds.Tables[0].Rows[0]["MacAddress"].ToString().Trim()); licDetailsDict.Add("MachineName", _ds.Tables[0].Rows[0]["MachineName"].ToString().Trim()); licDetailsDict.Add("Version", _ds.Tables[0].Rows[0]["Version"].ToString().Trim()); licDetailsDict.Add("NoOfDays", _ds.Tables[0].Rows[0]["NoOfDays"].ToString().Trim()); licDetailsDict.Add("DevCode", _ds.Tables[0].Rows[0]["DevCode"].ToString().Trim()); licDetailsDict.Add("GUID", _ds.Tables[0].Rows[0]["GUID"].ToString().Trim()); } } } catch (SystemException ex) { } return(licDetailsDict); }
internal static void getRootResource(string fileName, string languageCode, out System.Data.DataTable dataTable) { dataTable = null; string fileDirectory = string.Empty; string xmlFilePath = string.Empty; System.Data.DataSet dataSet = null; fileDirectory = directory.appPath; if (string.IsNullOrEmpty(languageCode)) { languageCode = commonVariables.SelectedLanguage; } xmlFilePath = fileDirectory + @"App_LocalResources\" + languageCode + @"\" + fileName + ".xml"; if (System.IO.File.Exists(xmlFilePath)) { using (dataSet = new System.Data.DataSet()) { dataSet.ReadXml(xmlFilePath); dataTable = dataSet.Tables[0]; } } else { xmlFilePath = fileDirectory + @"App_LocalResources\en-us\" + fileName + ".xml"; using (dataSet = new System.Data.DataSet()) { dataSet.ReadXml(xmlFilePath); dataTable = dataSet.Tables[0]; } } }
protected void Page_Load(object sender, EventArgs e) { // create the connection, DataAdapter and DataSet string connectionString = WebConfigurationManager.ConnectionStrings["Northwind"].ConnectionString; string sql = "SELECT TOP 5 EmployeeID, TitleOfCourtesy, LastName, FirstName FROM Employees"; SqlConnection conn = new SqlConnection(connectionString); SqlDataAdapter da = new SqlDataAdapter(sql, conn); DataSet ds = new DataSet(); // Fill the DataSet and fill the first grid. da.Fill(ds, "Employees"); Datagrid1.DataSource = ds.Tables["Employees"]; Datagrid1.DataBind(); // Generate the XML file. string xmlFile = Server.MapPath("Employees.xml"); ds.WriteXml(xmlFile, XmlWriteMode.WriteSchema); // Load the XML file. DataSet dsXml = new DataSet(); dsXml.ReadXml(xmlFile); // Fill the second grid. Datagrid2.DataSource = dsXml.Tables["Employees"]; Datagrid2.DataBind(); }
/// <summary> /// 查找数据。返回一个DataView /// </summary> /// <param name="XmlPathNode"></param> /// <returns></returns> public DataView GetData(string _XmlPathNode) { DataSet _ds = new DataSet(); StringReader _read = new StringReader(_objXmlDoc.SelectSingleNode(_XmlPathNode).OuterXml); _ds.ReadXml(_read); return _ds.Tables[0].DefaultView; }
protected void InitData() { string text = base.Request.QueryString["id"]; System.Data.DataSet dataSet = new System.Data.DataSet(); string text2 = System.Web.HttpContext.Current.Server.MapPath("/config/WifiConfig.xml"); if (System.IO.File.Exists(text2)) { dataSet.ReadXml(text2); if (dataSet != null) { foreach (System.Data.DataRow dataRow in dataSet.Tables[0].Rows) { if (dataRow["id"].ToString() == text) { this.hd_id.Value = text; this.txt_wifiName.Text = dataRow["wifiName"].ToString(); this.txt_wifiPwd.Text = dataRow["wifiPwd"].ToString(); this.txt_wifiDescribe.Text = dataRow["wifiDescribe"].ToString(); } } } } }
public IpProperties GetCountryByIP(string ipAddress) { string ipResponse = IPRequestHelper("http://ip-api.com/xml/" + ipAddress); using (TextReader sr = new StringReader(ipResponse)) { using (System.Data.DataSet dataBase = new System.Data.DataSet()) { IpProperties ipProperties = new IpProperties(); dataBase.ReadXml(sr); ipProperties.Status = dataBase.Tables[0].Rows[0][0].ToString(); ipProperties.Country = dataBase.Tables[0].Rows[0][1].ToString(); ipProperties.CountryCode = dataBase.Tables[0].Rows[0][2].ToString(); ipProperties.Region = dataBase.Tables[0].Rows[0][3].ToString(); ipProperties.RegionName = dataBase.Tables[0].Rows[0][4].ToString(); ipProperties.City = dataBase.Tables[0].Rows[0][5].ToString(); ipProperties.Zip = dataBase.Tables[0].Rows[0][6].ToString(); ipProperties.Lat = dataBase.Tables[0].Rows[0][7].ToString(); ipProperties.Lon = dataBase.Tables[0].Rows[0][8].ToString(); ipProperties.TimeZone = dataBase.Tables[0].Rows[0][9].ToString(); ipProperties.ISP = dataBase.Tables[0].Rows[0][10].ToString(); ipProperties.ORG = dataBase.Tables[0].Rows[0][11].ToString(); ipProperties.AS = dataBase.Tables[0].Rows[0][12].ToString(); ipProperties.Query = dataBase.Tables[0].Rows[0][13].ToString(); country = ipProperties.Country; return(ipProperties); } } }
internal static void getLocalResource(string filePath, string languageCode, out System.Data.DataTable dataTable) { dataTable = null; string fileName = string.Empty; string fileDirectory = string.Empty; string xmlFilePath = string.Empty; System.Data.DataSet dataSet = null; if (string.IsNullOrEmpty(filePath)) { filePath = System.Web.HttpContext.Current.Request.CurrentExecutionFilePath; } fileName = System.IO.Path.GetFileName(filePath); fileDirectory = System.Web.HttpContext.Current.Server.MapPath(filePath).Replace(fileName, ""); if (string.IsNullOrEmpty(languageCode)) { languageCode = commonVariables.SelectedLanguage; } xmlFilePath = fileDirectory + @"App_LocalResources\" + languageCode + @"\" + fileName + ".xml"; if (System.IO.File.Exists(xmlFilePath)) { using (dataSet = new System.Data.DataSet()) { dataSet.ReadXml(xmlFilePath); dataTable = dataSet.Tables[0]; } } else { xmlFilePath = fileDirectory + @"App_LocalResources\en-us\" + fileName + ".xml"; using (dataSet = new System.Data.DataSet()) { dataSet.ReadXml(xmlFilePath); dataTable = dataSet.Tables[0]; } } }
public Form1() { InitializeComponent(); XmlReader xmlFile1; xmlFile1 = XmlReader.Create("../../cd_catalog _1.xml", new XmlReaderSettings()); DataSet ds1 = new DataSet(); ds1.ReadXml(xmlFile1); dataGridView1.DataSource = ds1.Tables[0]; XmlReader xmlFile2; xmlFile2 = XmlReader.Create("../../cd_catalog _2.xml", new XmlReaderSettings()); DataSet ds2 = new DataSet(); ds2.ReadXml(xmlFile2); dataGridView2.DataSource = ds2.Tables[0]; List<string> cd_catalog_1 = dataGridView1.Rows .OfType<DataGridViewRow>() .Where(x => x.Cells[1].Value != null) .Select(x => x.Cells[1].Value.ToString()) .ToList(); List<string> cd_catalog_2 = dataGridView2.Rows .OfType<DataGridViewRow>() .Where(x => x.Cells[1].Value != null) .Select(x => x.Cells[1].Value.ToString()) .ToList(); }
private void mergeToolStripMenuItem_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); ds.ReadXml("data.xml"); mailMerge1.Merge(ds.Tables[0]); }
public static string GetTableAlias(string tableName) { if (__tableNames == null) { DataSet _data = new DataSet(); _data.ReadXml(System.Configuration.ConfigurationManager.AppSettings["PathXMLAlias"]); __tableNames = new System.Collections.Hashtable(); foreach (DataRow row in _data.Tables[0].Rows) { if (!__tableNames.ContainsKey(row["name"].ToString().ToLower().Trim())) { __tableNames.Add(row["name"].ToString().ToLower().Trim(), row["alias"].ToString()); } } } if (__tableNames.ContainsKey(tableName)) { return __tableNames[tableName].ToString(); } return tableName; }
public static DataTable GetProducts() { DataSet dsStore = new DataSet(); dsStore.ReadXmlSchema(Application.StartupPath + "\\store.xsd"); dsStore.ReadXml(Application.StartupPath + "\\store.xml"); return dsStore.Tables["Products"]; }
private void Inventory1_Load(object sender, EventArgs e) { lblItemCode.Text = CERPInventory.ItemCode; lblItemDesc.Text = CERPInventory.ItemDesc; CERPWS.Service1 svc = new CERPWS.Service1(); string result = svc.GetWarehouseInventory(CERPInventory.ItemID); StringReader sr = new StringReader(result); DataSet ds = new DataSet(); DataTable dt = new DataTable("table"); ds.ReadXml(sr); dt = ds.Tables[0]; if (dt.Rows[0].ItemArray[0].ToString() == "0") { MessageBox.Show(dt.Rows[0].ItemArray[1].ToString()); CERPInventory.Qty = 0; lblQty.Text = CERPInventory.Qty.ToString(); lblUOM.Text = ""; CERPInventory.OutOfStock = true; } else { CERPInventory.Qty = Convert.ToDecimal(dt.Rows[0].ItemArray[0].ToString()); CERPInventory.UOM = dt.Rows[0].ItemArray[1].ToString(); lblQty.Text = CERPInventory.Qty.ToString("G29"); lblUOM.Text = CERPInventory.UOM; CERPInventory.OutOfStock = false; } }
/// <summary> /// WebService para Busca de CEP /// </summary> /// <param name="CEP"></param> public CEP(string CEP) { _uf = ""; _cidade = ""; _bairro = ""; _tipo_lagradouro = ""; _lagradouro = ""; _resultado = "0"; _resultato_txt = "CEP não encontrado"; //Cria um DataSet baseado no retorno do XML DataSet ds = new DataSet(); ds.ReadXml("http://cep.republicavirtual.com.br/web_cep.php?cep=" + CEP.Replace("-", "").Trim() + "&formato=xml"); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { _resultado = ds.Tables[0].Rows[0]["resultado"].ToString(); switch (_resultado) { case "1": _uf = ds.Tables[0].Rows[0]["uf"].ToString().Trim(); _cidade = ds.Tables[0].Rows[0]["cidade"].ToString().Trim(); _bairro = ds.Tables[0].Rows[0]["bairro"].ToString().Trim(); _tipo_lagradouro = ds.Tables[0].Rows[0]["tipo_logradouro"].ToString().Trim(); _lagradouro = ds.Tables[0].Rows[0]["logradouro"].ToString().Trim(); _resultato_txt = "CEP completo"; break; case "2": _uf = ds.Tables[0].Rows[0]["uf"].ToString().Trim(); _cidade = ds.Tables[0].Rows[0]["cidade"].ToString().Trim(); _bairro = ""; _tipo_lagradouro = ""; _lagradouro = ""; _resultato_txt = "CEP único"; break; default: _uf = ""; _cidade = ""; _bairro = ""; _tipo_lagradouro = ""; _lagradouro = ""; _resultato_txt = "CEP não encontrado"; break; } } } //Exemplo do retorno da WEB //<?xml version="1.0" encoding="iso-8859-1"?> //<webservicecep> //<uf>RS</uf> //<cidade>Porto Alegre</cidade> //<bairro>Passo D'Areia</bairro> //<tipo_logradouro>Avenida</tipo_logradouro> //<logradouro>Assis Brasil</logradouro> //<resultado>1</resultado> //<resultado_txt>sucesso - cep completo</resultado_txt> //</webservicecep> }
public void ThrowException() { DataSet result = new DataSet(); XmlReader xRead = XmlReader.Create(new StringReader(new backoffice.proxy().request("", ""))); result.ReadXml(xRead); }
/// <summary> /// Reads the list of recognized keyboards /// </summary> /// <param name="path"></param> /// <returns></returns> public static DataSet readKeyboardList(string path) { string ProfilePathFilename = path + @"\ValidKeyboards.xml"; DataTable dtValidKeyboards; // Create the Profile data set. DataSet dsValidKeyboards = new DataSet(); dtValidKeyboards = new DataTable("Keyboard"); dtValidKeyboards.Columns.Add(new DataColumn("DeviceName", typeof(string))); dsValidKeyboards.Tables.Add(dtValidKeyboards); // Clear out the Profile data table. dtValidKeyboards.Rows.Clear(); // Check to see if the Profile already exists in storage, load and return true. // If it does not exist, only return false. if (File.Exists(ProfilePathFilename)) { dsValidKeyboards.ReadXml(ProfilePathFilename, XmlReadMode.ReadSchema); } else { // maybe do something here } // Return the file loaded status. Default is false / bad load. return dsValidKeyboards; }
public ActionResult Feedback() { List <ContactModel> list = new List <ContactModel>(); if (System.IO.File.Exists(Server.MapPath(@"~/feedback.xml"))) { DataSet dSet = new System.Data.DataSet(); dSet.ReadXml(Server.MapPath(@"~/feedback.xml")); DataTable comments = dSet.Tables["customer_comment"]; foreach (DataRow row in comments.Rows) { ContactModel model = new ContactModel(); model.Name = row["name"].ToString(); model.Email = row["email"].ToString(); model.BookingRef = row["bookingRef"].ToString(); model.Topic = row["topic"].ToString(); model.Comments = row["comments"].ToString(); model.Stay = row["stayAgain"].ToString(); model.Recommend = row["recommend"].ToString(); //string istring = row["date"].ToString(); //model.Time = DateTime.ParseExact(istring, "dd-mmM-yyyy HH:mm:ss tt", null); //model.Time = DateTime.ParseExact(istring, "D", null); list.Add(model); } } return(View(list)); }
public XmlDataAdapter(String dbname) { _savePath = Environment.CurrentDirectory; _savePath = Path.Combine(_savePath,dbname + ".xml"); if(Directory.Exists(Path.GetDirectoryName(_savePath)) == false) Directory.CreateDirectory(Path.GetDirectoryName(_savePath)); if (File.Exists(_savePath)) { _dataset = new DataSet(); try { _dataset.ReadXml(_savePath, XmlReadMode.Auto); } catch(Exception e) { File.Move(_savePath, String.Format("{0}.corrupted",_savePath)); _dataset = new DataSet(dbname); _dataset.WriteXml(_savePath, XmlWriteMode.WriteSchema); } } else { _dataset = new DataSet(dbname); _dataset.WriteXml(_savePath, XmlWriteMode.WriteSchema); } }
/// <summary> /// 读取指定节点的值 /// </summary> /// <param name="XmlPathNode">节点的XPATH</param> /// <returns>返回一个DataView</returns> public DataSet GetData(string XmlPathNode) { DataSet ds = new DataSet(); StringReader read = new StringReader(objXmlDoc.SelectSingleNode(XmlPathNode).OuterXml); ds.ReadXml(read); return ds; }
public static void ReadXMLToRestoreDatabase() { foreach (var tblName in tableNames.Reverse()) { String tblFileName = tblName + ".xml"; if (File.Exists(PATH + tblFileName)) { using (var filestream = File.Open(PATH + tblFileName, FileMode.Open)) { System.Data.DataSet ds = new System.Data.DataSet(tblName); using (SqlConnection con = (SqlConnection)database.CreateOpenConnection()) { database.CreateStoredProcCommand("EnableIDInsert", con).ExecuteNonQuery(); var adapter = SetUPAdapterForTable((SqlConnection)con, tblName); adapter.TableMappings.Add(tblName, tblName); //adapter.Fill(dataSet); ds.ReadXml(filestream); if (ds.Tables.Count > 0) { using (SqlBulkCopy cop = new SqlBulkCopy(con, SqlBulkCopyOptions.KeepIdentity, null)) { cop.DestinationTableName = "dbo." + tblName; cop.WriteToServer(ds.Tables[0]); } } database.CreateStoredProcCommand("DisableIDInsert", con).ExecuteNonQuery(); } } } } }
public static void ReadRoutesFromXML(String fileName) { if (File.Exists(PATH + fileName)) { using (var filestream = File.Open(PATH + fileName, FileMode.Open)) { System.Data.DataSet ds = new System.Data.DataSet("tblRuta"); using (SqlConnection con = (SqlConnection)database.CreateOpenConnection()) { database.CreateStoredProcCommand("emptyDB", con).ExecuteNonQuery(); database.CreateStoredProcCommand("EnableIDInsert", con).ExecuteNonQuery(); var adapter = SetUPAdapterForTable((SqlConnection)con, "tblRuta"); adapter.TableMappings.Add("tblRuta", "tblRuta"); //adapter.Fill(dataSet); ds.ReadXml(filestream); if (ds.Tables.Count > 0) { using (SqlBulkCopy cop = new SqlBulkCopy(con, SqlBulkCopyOptions.KeepIdentity, null)) { cop.DestinationTableName = "dbo." + "tblRuta"; cop.WriteToServer(ds.Tables[0]); } } database.CreateStoredProcCommand("DisableIDInsert", con).ExecuteNonQuery(); } } } }
private void GetDetailInfo() { #region //调用台站详细信息服务 PT_BS_Service.Client.Framework.BeOperationInvoker.Invoke <I_CO_IA_StationManage>(channel => { string strStation = channel.SearchStationByGuid(m_statGuid); if (!string.IsNullOrEmpty(strStation)) { System.IO.StringReader xmlSR = new System.IO.StringReader(strStation); System.Data.DataSet CurrentResult = new System.Data.DataSet(); MemoryStream ms = new MemoryStream(Convert.FromBase64String(strStation)); CurrentResult.ReadXml(ms, XmlReadMode.Auto); //StringReader xmlSR = new StringReader(strStationStr); //CurrentResult.ReadXml(xmlSR, XmlReadMode.Auto); //忽视任何内联架构,从数据推断出强类型架构并加载数据。如果无法推断,则解释成字符串数据 if (CurrentResult.Tables.Count > 0) { ShowDetail(CurrentResult); } else { MessageBox.Show("获取不到台站概要信息,请确认数据源是否改变!"); } } else { MessageBox.Show("获取不到台站概要信息,请确认数据源是否改变!"); } }); #endregion }
private void Bind(string strTypeID,string strTypeName="") { DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("~/FileManager/File.xml")); DataRow[] drs = null; if (strTypeID != "") { drs = ds.Tables[0].Select("ParentID='" + strTypeID + "'"); } else { drs = ds.Tables[0].Select("ParentID='0'"); } DataTable dt = ds.Tables[0].Clone(); foreach (DataRow dr in drs) { dt.Rows.Add(dr.ItemArray); } dt.AcceptChanges(); this.dgDocView.DataSource = dt; this.dgDocView.DataBind(); ViewState["TypeID"] = strTypeID; ViewState["TypeName"] = strTypeName; lbTypeName.Text = strTypeName; }
public Form1() { // How to Activate //Stimulsoft.Base.StiLicense.Key = "6vJhGtLLLz2GNviWmUTrhSqnO..."; //Stimulsoft.Base.StiLicense.LoadFromFile("license.key"); //Stimulsoft.Base.StiLicense.LoadFromStream(stream); InitializeComponent(); if (File.Exists("..\\Data\\Demo.xsd")) { dataSet1.ReadXmlSchema("..\\Data\\Demo.xsd"); } else { MessageBox.Show("File \"Demo.xsd\" not found"); } if (File.Exists("..\\Data\\Demo.xsd")) { dataSet1.ReadXml("..\\Data\\Demo.xml"); } else { MessageBox.Show("File \"Demo.xml\" not found"); } dataSet1.DataSetName = "Demo"; }
public void helloWorldTest() { DataSet helloworld = new DataSet(); helloworld.ReadXml(ConfigurationSettings.AppSettings["XmlPath"].ToString()); sceenshotpath=helloworld.Tables[0].Rows[0].ItemArray[10].ToString(); baseUrl = helloworld.Tables[1].Rows[0].ItemArray[1].ToString() + ":" + "//" + helloworld.Tables[1].Rows[0].ItemArray[2].ToString() + ":" + helloworld.Tables[1].Rows[0].ItemArray[3].ToString() + "/" + helloworld.Tables[1].Rows[0].ItemArray[0].ToString(); Directory.CreateDirectory(helloworld.Tables[0].Rows[0].ItemArray[9].ToString()); try { //Opens Phresco Home Page. driver.Navigate().GoToUrl(baseUrl); //Click on site actions and go to edit page. driver.FindElement(By.XPath(helloworld.Tables[0].Rows[0].ItemArray[4].ToString())).Click(); driver.FindElement(By.XPath(helloworld.Tables[0].Rows[0].ItemArray[5].ToString())).Click(); Thread.Sleep(Convert.ToInt32(helloworld.Tables[0].Rows[0].ItemArray[3].ToString())); //Close the hello world web part. driver.FindElement(By.XPath(helloworld.Tables[0].Rows[0].ItemArray[6].ToString())).Click(); Thread.Sleep(Convert.ToInt32(helloworld.Tables[0].Rows[0].ItemArray[3].ToString())); driver.Navigate().Refresh(); driver.Navigate().GoToUrl(baseUrl); } catch (Exception e) { TakeScreenshot(driver, helloworld.Tables[0].Rows[0].ItemArray[10].ToString()); throw e; } }
public static void CreateMenuJson() { string jsPath = Utils.GetMapPath(BaseConfigs.GetForumPath.ToLower() + "admin/xml/navmenu.js"); System.Data.DataSet dsSrc = new System.Data.DataSet(); dsSrc.ReadXml(configPath); StringBuilder menustr = new StringBuilder(); menustr.Append("var toptabmenu = "); menustr.Append(Utils.DataTableToJSON(dsSrc.Tables[2])); menustr.Append("\r\nvar mainmenu = "); menustr.Append(Utils.DataTableToJSON(dsSrc.Tables[0])); menustr.Append("\r\nvar submenu = "); menustr.Append(Utils.DataTableToJSON(dsSrc.Tables[1])); menustr.Append("\r\nvar shortcut = "); if (dsSrc.Tables.Count < 4) { menustr.Append("[]"); } else { menustr.Append(Utils.DataTableToJSON(dsSrc.Tables[3])); } WriteJsonFile(jsPath, menustr); dsSrc.Dispose(); }
internal static void getLocalResource(out System.Data.DataSet dataSet) { dataSet = null; string filePath = string.Empty; string fileDirectory = string.Empty; string filename = string.Empty; string languageCode = string.Empty; string xmlFilePath = string.Empty; filePath = System.Web.HttpContext.Current.Request.CurrentExecutionFilePath; filename = System.IO.Path.GetFileName(filePath); fileDirectory = System.Web.HttpContext.Current.Server.MapPath(filePath).Replace(filename, ""); languageCode = commonVariables.SelectedLanguage; xmlFilePath = fileDirectory + @"App_LocalResources\" + languageCode + @"\" + filename + ".xml"; if (System.IO.File.Exists(xmlFilePath)) { dataSet = new System.Data.DataSet(); dataSet.ReadXml(xmlFilePath); } else { xmlFilePath = fileDirectory + @"App_LocalResources\en-us\" + filename + ".xml"; dataSet = new System.Data.DataSet(); dataSet.ReadXml(xmlFilePath); } }
protected override void ReadXmlSerializable(System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["VoiceNote"] != null)) { base.Tables.Add(new VoiceNoteDataTable(ds.Tables["VoiceNote"])); } this.DataSetName = ds.DataSetName; this.Prefix = ds.Prefix; this.Namespace = ds.Namespace; this.Locale = ds.Locale; this.CaseSensitive = ds.CaseSensitive; this.EnforceConstraints = ds.EnforceConstraints; this.Merge(ds, false, System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } }
private void FormParameter_Load(object sender, EventArgs e) { object[] oTemp = new object[3]; if (strConn != "") { sqlConn.ConnectionString = strConn; sqlComm.Connection = sqlConn; sqlDA.SelectCommand = sqlComm; } else { if (File.Exists(dFileName)) //存在文件 { dSet.ReadXml(dFileName); numericUpDownWeek.Value = int.Parse(dSet.Tables["parameters"].Rows[0][0].ToString()); numericUpDownPass.Value = int.Parse(dSet.Tables["parameters"].Rows[0][1].ToString()); numericUpDownTAC.Value = int.Parse(dSet.Tables["parameters"].Rows[0][2].ToString()); } else //没有文件,建立datatable { dSet.Tables.Add("parameters"); dSet.Tables["parameters"].Columns.Add("Weeks", System.Type.GetType("System.Decimal")); dSet.Tables["parameters"].Columns.Add("Pass", System.Type.GetType("System.Decimal")); dSet.Tables["parameters"].Columns.Add("TAC", System.Type.GetType("System.Decimal")); oTemp[0] = numericUpDownWeek.Value; oTemp[1] = numericUpDownPass.Value; oTemp[2] = numericUpDownTAC.Value; dSet.Tables["parameters"].Rows.Add(oTemp); } } }
/// <summary> /// Запись параметра в файл настроек /// </summary> /// <param name="KeyName">Имя параметра</param> /// <param name="KeyValue">Значение параметра</param> /// <returns></returns> public bool SetSetting(string KeyName, string KeyValue) { try { KeyValue = Encrypt(KeyValue); LoadXml(); System.Data.DataSet ds = new System.Data.DataSet(); ds.ReadXml(_settingsXML); if (ds.Tables.Count == 0 || ds.Tables["SettingString"].Select("KeyName='" + KeyName + "'").Length == 0) { // Добавление параметра в файл, если его не существует AddSettingToXml(KeyName, KeyValue); } else { // Редактировать параметр в файле SettingsXmlDoc.SelectSingleNode("//root/SettingString[@KeyName='" + KeyName + "']").Attributes["KeyValue"].Value = KeyValue; SettingsXmlDoc.Save(_settingsXML); } } catch (Exception) { return(false); } return(true); }
/// <summary> /// 获得模板变量列表 /// </summary> /// <param name="forumpath">模板路径</param> /// <param name="skinName">皮肤名</param> /// <returns></returns> public static DataTable GetTemplateVarList(string forumpath,string skinName) { Discuz.Cache.DNTCache cache = Cache.DNTCache.GetCacheService(); DataTable dt = cache.RetrieveSingleObject("/Forum/" + skinName + "/TemplateVariable") as DataTable; if(dt == null) { DataSet dsSrc = new DataSet("template"); string[] filename = { Utils.GetMapPath(forumpath + "templates/" + skinName + "/templatevariable.xml") }; if (Utils.FileExists(filename[0])) { dsSrc.ReadXml(filename[0]); if (dsSrc.Tables.Count == 0) dsSrc.Tables.Add(TemplateVariableTable()); } else { dsSrc.Tables.Add(TemplateVariableTable()); } dt = dsSrc.Tables[0]; cache.AddSingleObject("/Forum/" + skinName + "/TemplateVariable", dt, filename); } return dt; }
private void formTZ_Load(object sender, EventArgs e) { string dFileName1 = Directory.GetCurrentDirectory() + "\\addcon.xml"; if (File.Exists(dFileName1)) //存在文件 { dSet1.ReadXml(dFileName1); comboBoxCOM.SelectedIndex = Int32.Parse(dSet1.Tables["附加信息"].Rows[0][1].ToString()); } else { comboBoxCOM.SelectedIndex = 0; } //fc = (formConference)this.ParentForm; textBoxTZ.Text = "请您于" + fc.dateTimePickerStart.Value.ToLongDateString() + " " + fc.dateTimePickerStart.Value.ToShortTimeString() + " 参加 " + fc.textBoxCname.Text.Trim(); if (fc.textBoxCname2.Text.Trim() != "") { textBoxTZ.Text += "(" + fc.textBoxCname2.Text.Trim() + ")"; } if (fc.textBoxConferenceNo.Text.Trim() != "") { textBoxTZ.Text += " 会场:" + fc.textBoxConferenceNo.Text.Trim(); } textBoxTZ.Text += " ,请准时到会。"; toolStripStatusLabelCount.Text = "0/" + fc.intCount.ToString(); }
protected void Page_Load(object sender, EventArgs e) { DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("~/App_Data/Players.xml")); ds.Tables[0].DefaultView.RowFilter = "[Nationality]='United States'"; GridExtender1.Data.DataSource = ds.Tables[0].DefaultView; }
private void formSoftSign_Load(object sender, EventArgs e) { string strData = ""; strData = lockit.getMacAddress(); if (strData == "") { strData = lockit.getDiskSerial(); } if (strData == "") { strData = "CHRISTIE(CHENYI)"; } textBoxSerial.Text = lockit.getLockEnData(strData, strpassword); if (File.Exists(dFileName)) //´æÔÚÎļþ { dSet.ReadXml(dFileName); } else //½¨Á¢Îļþ { dSet.Tables.Add("Èí¼þ×¢²á"); dSet.Tables["Èí¼þ×¢²á"].Columns.Add("×¢²áÂë", System.Type.GetType("System.String")); string[] strDRow = { "" }; dSet.Tables["Èí¼þ×¢²á"].Rows.Add(strDRow); } textBoxSign.Text = dSet.Tables["Èí¼þ×¢²á"].Rows[0][0].ToString(); }
private void Form1_Load(object sender, EventArgs e) { //Create a DataSet from the XML file string filePath = "..\\..\\Employees.xml"; DataSet ds = new DataSet(); ds.ReadXml(filePath); //Create and add barcode column DataColumn dc = new DataColumn("BarcodeImage", typeof(byte[])); ds.Tables[0].Columns.Add(dc); //We'll use Code 128 Barcode Symbology BaseBarcode b = BarcodeFactory.GetBarcode(Symbology.Code128); b.Height = 50; b.FontHeight = 0.3F; //Now, generate and fill barcode images foreach (DataRow dr in ds.Tables[0].Rows) { //We'll encode the ID column b.Number = (string)dr["ID"]; //Create bitmap and save it to BarcodeImage column MemoryStream ms = new MemoryStream(); b.Save(ms, ImageType.Png); dr["BarcodeImage"] = ms.GetBuffer(); } CrystalReport1 report = new CrystalReport1(); report.SetDataSource(ds); crystalReportViewer1.ReportSource = report; }
//将xml文件转换为DataSet public static DataSet ConvertXMLFileToDataSet(string xmlFile) { StringReader stream = null; XmlTextReader reader = null; try { XmlDocument xmld = new XmlDocument(); xmld.Load(xmlFile); DataSet xmlDS = new DataSet(); stream = new StringReader(xmld.InnerXml); //从stream装载到XmlTextReader reader = new XmlTextReader(stream); xmlDS.ReadXml(reader); //xmlDS.ReadXml(xmlFile); return xmlDS; } catch (System.Exception ex) { throw ex; //MessageBox.Show(ex.ToString()); } //finally //{ // if (reader != null) reader.Close(); //} }
public static Boolean verificaCEP(String CEP) { bool flag = false; try { DataSet ds = new DataSet(); string xml = "http://cep.republicavirtual.com.br/web_cep.php?cep=@cep&formato=xml".Replace("@cep", CEP); ds.ReadXml(xml); endereco = ds.Tables[0].Rows[0]["logradouro"].ToString(); bairro = ds.Tables[0].Rows[0]["bairro"].ToString(); cidade = ds.Tables[0].Rows[0]["cidade"].ToString(); estado = ds.Tables[0].Rows[0]["uf"].ToString(); cep = CEP; flag = true; } catch (Exception ex) { endereco = ""; bairro = ""; cidade = ""; estado = ""; cep = ""; } return flag; }
private static DataSet GetDataFromService(string url) { var dataSet = new System.Data.DataSet(); dataSet.ReadXml(url); return(dataSet); }
/// <summary> /// Reads the relevant Rss feed and returns a list off RssFeedItems /// </summary> /// <param name="url"></param> /// <returns></returns> public static List<RssFeedItem> ReadFeed(string url) { //create a new list of the rss feed items to return List<RssFeedItem> rssFeedItems = new List<RssFeedItem>(); //create an http request which will be used to retrieve the rss feed HttpWebRequest rssFeed = (HttpWebRequest)WebRequest.Create(url); //use a dataset to retrieve the rss feed using (DataSet rssData = new DataSet()) { //read the xml from the stream of the web request rssData.ReadXml(rssFeed.GetResponse().GetResponseStream()); //loop through the rss items in the dataset and populate the list of rss feed items foreach (DataRow dataRow in rssData.Tables["item"].Rows) { rssFeedItems.Add(new RssFeedItem { ChannelId = Convert.ToInt32(dataRow["channel_Id"]), Description = Convert.ToString(dataRow["description"]), ItemId = Convert.ToInt32(dataRow["item_Id"]), Link = Convert.ToString(dataRow["link"]), PublishDate = Convert.ToDateTime(dataRow["pubDate"]), Title = Convert.ToString(dataRow["title"]) }); } } //return the rss feed items return rssFeedItems; }
public static void CreateMenuJson() { string jsPath = AppDomain.CurrentDomain.BaseDirectory + "/admin/xml/navmenu.js"; System.Data.DataSet dsSrc = new System.Data.DataSet(); dsSrc.ReadXml(configPath); StringBuilder menustr = new StringBuilder(); menustr.Append("var toptabmenu = "); menustr.Append(Utils.DataTableToJSON(dsSrc.Tables[2])); menustr.Append("\r\nvar mainmenu = "); menustr.Append(Utils.DataTableToJSON(dsSrc.Tables[0])); menustr.Append("\r\nvar submenu = "); menustr.Append(Utils.DataTableToJSON(dsSrc.Tables[1])); menustr.Append("\r\nvar shortcut = "); if (dsSrc.Tables.Count < 4) { menustr.Append("[]"); } else { menustr.Append(Utils.DataTableToJSON(dsSrc.Tables[3])); } WriteJsonFile(jsPath, menustr); dsSrc.Dispose(); }
private void BindDir(string strTypeID) { DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("~/SystemManager/Document.xml")); DataTable dt = ds.Tables[0].Clone(); DataRow[] drs = null; drs = ds.Tables[0].Select("ParentID='" + strTypeID + "'"); drpDir.Items.Clear(); drpDir.Items.Add(new ListItem("/", ViewState["TypeID"].ToString())); if (drs.Length > 0) { foreach (DataRow dr in drs) { //dt.Rows.Add(dr.ItemArray); ListItem item = new ListItem("/" + dr["TypeName"].ToString(), dr["TypeID"].ToString()); drpDir.Items.Add(item); } } drpDir.SelectedValue = "0"; //dt.AcceptChanges(); //drpDir.DataSource = dt; //drpDir.DataTextField = "TypeName"; //drpDir.DataValueField="TypeID"; //drpDir.DataBind(); }
/// <summary> /// 从 XML 文件中读取数据,形成 DataTable. /// /// 参考 A0210_DataSetXML 项目的 DataSetReadXml.cs /// </summary> /// <returns></returns> private static DataSet LoadDataSet() { // 桔子 DataTable DataTable orangeDt = new DataTable("桔子"); orangeDt.Columns.Add("产地"); orangeDt.Columns.Add("颜色"); orangeDt.Columns.Add("味道"); orangeDt.Columns.Add("品质"); // 苹果 DataTable DataTable appleDt = new DataTable("苹果"); appleDt.Columns.Add("产地"); appleDt.Columns.Add("颜色"); appleDt.Columns.Add("味道"); appleDt.Columns.Add("品质"); // 用于返回的 DataSet. DataSet ds = new DataSet(); ds.Tables.Add(orangeDt); ds.Tables.Add(appleDt); // 读取文件. ds.ReadXml("xmlSample.xml"); // 返回. return ds; }
private void UpdateFiltter() { try { string filu = @fileUrl; DataSet ds = new DataSet(); DataTable dt = new DataTable(); DataView dv = new DataView(); ds.ReadXml(filu); dt = ds.Tables[0]; dv = dt.DefaultView; if (cbFiltter.SelectedIndex != -1 && cbFiltter.SelectedIndex != 0) { dt.DefaultView.RowFilter = "maa = '" + cbFiltter.SelectedItem.ToString() + "'"; } dgWines.ItemsSource = dv; } catch (Exception ex) { throw; } }
public static int[] LoadFormLocationAndSize(Form xForm) { int[] t = { 0, 0, 300, 300 }; if (!File.Exists(Application.StartupPath + Path.DirectorySeparatorChar + "formornetclose.xml")) return t; DataSet dset = new DataSet(); dset.ReadXml(Application.StartupPath + Path.DirectorySeparatorChar + "formornetclose.xml"); int[] LocationAndSize = new int[] { xForm.Location.X, xForm.Location.Y, xForm.Size.Width, xForm.Size.Height }; //---// try { var AbbA = dset.Tables[0].Rows[0]["Input"].ToString().Split(';'); //---// LocationAndSize[0] = Convert.ToInt32(AbbA[0]); LocationAndSize[1] = Convert.ToInt32(AbbA[1]); LocationAndSize[2] = Convert.ToInt32(AbbA[2]); LocationAndSize[3] = Convert.ToInt32(AbbA[3]); } catch (Exception ex) { MessageBox.Show(ex.Message); } //---// return LocationAndSize; }
public static object GetEmployeeData() { string path = DemoUtils.GetRelativePath("TOC_Employees.xml"); System.Data.DataSet EmployeeDataDS = new System.Data.DataSet(); EmployeeDataDS.ReadXml(path); return(EmployeeDataDS.Tables[1]); }
public static void captureData() { lock (MainClass.data) { try { System.Data.DataSet ds = null; bool create = false; if (!System.IO.File.Exists(MainClass.location + "bd.xml")) { System.Data.DataTable dt = new System.Data.DataTable("Balances"); dt.Columns.Add("Date"); dt.Columns.Add("Coin"); dt.Columns.Add("Amount"); dt.Rows.Add("", "", ""); System.Data.DataTable dtParameters = new System.Data.DataTable("Parameters"); dtParameters.Columns.Add("Parameter"); dtParameters.Columns.Add("Value"); dtParameters.Rows.Add("", ""); ds = new System.Data.DataSet(); ds.DataSetName = "Database"; ds.Tables.Add(dt); ds.Tables.Add(dtParameters); ds.WriteXml(MainClass.location + "bd.xml"); create = true; } ds = new System.Data.DataSet(); ds.ReadXml(MainClass.location + "bd.xml"); BitMEX.BitMEXApi bitMEXApi = new BitMEX.BitMEXApi(MainClass.bitmexKeyWeb, MainClass.bitmexSecretWeb, MainClass.bitmexDomain); string json = bitMEXApi.GetWallet(); JContainer jCointaner = (JContainer)JsonConvert.DeserializeObject(json, (typeof(JContainer))); if (create) { ds.Tables[0].Rows.Clear(); } ds.Tables[0].Rows.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), MainClass.pair, jCointaner[0]["walletBalance"].ToString()); ds.Tables[1].Rows.Clear(); ds.Tables[1].Rows.Add("OpenOrders", bitMEXApi.GetOpenOrders(MainClass.pair).Count); ds.Tables[1].Rows.Add("Amount", jCointaner[0]["walletBalance"].ToString()); System.IO.File.Delete(MainClass.location + "bd.xml"); ds.WriteXml(MainClass.location + "bd.xml"); } catch { } } }
protected void Page_Load(object sender, EventArgs e) { dataSet1 = new DataSet(); string path = Server.MapPath("~/App_Data"); dataSet1.ReadXmlSchema(path + "\\XMLFile1.xsd"); dataSet1.ReadXml(path + "\\XMLFile1.xml"); Page.DataBind(); }
public bool LoadHistoryTable() { if (File.Exists("history.xml")) { ApmHistorySet.ReadXml("history.xml"); return(true); } return(false); }
private BindingSource DataBindingJobsSource() { System.Data.DataSet ds = new System.Data.DataSet(); string xmlfileFullPath = Miscellaneous.GetJobXMLFullPath(); //string rootElement = "Jobs"; ds.ReadXml(xmlfileFullPath); return(new BindingSource(ds.Tables[0], null)); }
public static void LoadXmlToGrid(System.Windows.Forms.DataGridView grid, string fileName, string tableName) { if (System.IO.File.Exists(fileName)) { System.Data.DataSet ds = new System.Data.DataSet("Accounts"); ds.ReadXml(fileName); grid.DataSource = ds; grid.DataMember = tableName; } }
private void getCurrency() { DataTable dtCurrency = new DataTable(); System.Data.DataSet theDS = new System.Data.DataSet(); theDS.ReadXml(Server.MapPath("..\\XMLFiles\\Currency.xml")); DataView theCurrDV = new DataView(theDS.Tables[0]); theCurrDV.RowFilter = "Id=" + Convert.ToInt32(Session["AppCurrency"]); string thestringCurrency = theCurrDV[0]["Name"].ToString(); theCurrency = thestringCurrency.Substring(thestringCurrency.LastIndexOf("(") + 1, 3); }
private BindingSource NursesDataBindingSource() { System.Data.DataSet ds = new System.Data.DataSet(); string fileLocation = System.IO.Path.Combine(APPPATH, "data"); string xmlFileName = "Nursers.xml"; string xmlfileFullPath = System.IO.Path.Combine(fileLocation, xmlFileName); ds.ReadXml(xmlfileFullPath); return(new BindingSource(ds.Tables[0], null)); }
public Form1() { InitializeComponent(); // This line of code is generated by Data Source Configuration Wizard // Create a new DataSet System.Data.DataSet xmlDataSet = new System.Data.DataSet("XML DataSet"); // Load the XML document to the DataSet xmlDataSet.ReadXml(@"..\..\Data\rio2016.xml"); // This line of code is generated by Data Source Configuration Wizard pieChartDataAdapter1.DataSource = xmlDataSet.Tables["Table1"]; }
/// <summary> /// 通过SOAP协议动态调用webservice /// </summary> /// <param name="url"> webservice地址</param> /// <param name="methodName"> 调用方法名</param> /// <param name="pars"> 参数表</param> /// <returns> 结果集转换的DataSet</returns> public static DataSet SoapWebServiceDataSet(String url, String methodName, Hashtable pars) { XmlDocument doc = SoapWebService(url, methodName, pars); System.Data.DataSet ds = new System.Data.DataSet(); using (XmlNodeReader reader = new XmlNodeReader(doc)) { ds.ReadXml(reader); } return(ds); }