| | |
Xml & Ado.net
Please support our VB.NET advertiser: Intel Parallel Studio Home
Thread Solved |
Is it possible to issue SQL Style Commands to manipulate data from XML Files
ie. SELECT, INSERT, UPDATE and DELETE
The reason i ask is the i want to write an appliclation that will store the database with the application but with out the user needing to have MSAssess (for MDB or ACCDB files) installed
I have used MDBs, ACCDBs, SQL and SQLExpress before but
SQL is for Network apps
SQLExpress is for Local PC Data based apps
MDB & ACCDB can be used to transfer the data along with the app but require the users PC to have MSAccess installed
so is there any way to use SELECT, INSERT, UPDATE and DELETE statments with XML, If not is there any other datasource type that will
ie. SELECT, INSERT, UPDATE and DELETE
The reason i ask is the i want to write an appliclation that will store the database with the application but with out the user needing to have MSAssess (for MDB or ACCDB files) installed
I have used MDBs, ACCDBs, SQL and SQLExpress before but
SQL is for Network apps
SQLExpress is for Local PC Data based apps
MDB & ACCDB can be used to transfer the data along with the app but require the users PC to have MSAccess installed
so is there any way to use SELECT, INSERT, UPDATE and DELETE statments with XML, If not is there any other datasource type that will
Yes, it is possible to save and load Datasets to and from xml.
And after loading you can manipulate the dataset as you would after filling it with data from any database.
Here is how you can use the Select.
Load your XML file into DataSet and Select() method to select from your XML.
And after loading you can manipulate the dataset as you would after filling it with data from any database.
Here is how you can use the Select.
Load your XML file into DataSet and Select() method to select from your XML.
The only issue I found with this approach is that, you have to load the entire xml file into your dataset. wich could be a problem when your database gets to a larger size. I would still use SQL Server, XML requires you to load ALL the data first before being able to query it. At least with SQL server you can query the exact id you want. With increase in the XML file size there will be performance issues too.
Data Backup and reliability is also high on SQL. But as you want to go without any DB software. It can be either XML or .dat files.
Data Backup and reliability is also high on SQL. But as you want to go without any DB software. It can be either XML or .dat files.
Thanks binjo_daniel,
I was looking at using dataset.readxml & datatable.readxml but i wanted to use SQL Statements to filter the data
I will look into .dat files but i think dataset.readxml & datatable.readxml will work for some small apps
I hope that VB.NET 2008 has SQL Statments for XML Queries as i work with SQL every day and much prefer to have the control that the SQL Statments bring over DataAdapter.update and Datatable.WriteXML
Thanks
I was looking at using dataset.readxml & datatable.readxml but i wanted to use SQL Statements to filter the data
I will look into .dat files but i think dataset.readxml & datatable.readxml will work for some small apps
I hope that VB.NET 2008 has SQL Statments for XML Queries as i work with SQL every day and much prefer to have the control that the SQL Statments bring over DataAdapter.update and Datatable.WriteXML
Thanks
Hope they include something to support your requirement in Orcas. Code Name for VS 2008
Last edited by binoj_daniel; Sep 25th, 2007 at 5:50 pm.
![]() |
Similar Threads
- Saving Excel Spreadsheet using ADO.net gives inconsistent results (C#)
- DataGrid with ado.net. (VB.NET)
- Long ado net question but urgent help required (ASP.NET)
- ADO.NET question modification. (VB.NET)
- ADO.Net SQL UPDATE using OleDBAdapter (C#)
- Can i do something international using which side of vb.net whether it is ado.net, we (VB.NET)
- Data Navigation in textboxes with ADO.NET (like ADO) (ASP.NET)
Other Threads in the VB.NET Forum
- Previous Thread: crystal report
- Next Thread: DataGridView Behavior
| Thread Tools | Search this Thread |
"crystal .net .net2005 30minutes 2005 2008 access add arithmetic array assignment basic binary bing box button buttons center check code combobox component connectionstring convert cpu crystalreport data database databasesearch datagrid datagridview design dissertation dissertations dissertationthesis dosconsolevb.net dropdownlist editvb.net excel file-dialog firewall folder ftp google hardcopy image images isnumericfuntioncall login math memory mobile ms mssqlbackend mysql navigate net networking opacity output peertopeervideostreaming picturebox1 port print printpreview problemwithinstallation project record reports" reuse save savedialog searchbox serial soap storedprocedure string tcp temp text textbox timer toolbox trim updown useraccounts usercontrol vb vb.net vb.netcode vb.nettoolboxvisualbasic2008sidebar vb2008 vbnet view visual visualbasic visualbasic.net visualstudio web wpf





