•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 456,508 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,677 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our VB.NET advertiser: Programming Forums
Views: 1610 | Replies: 6 | 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
•
•
Join Date: Dec 2006
Location: United States
Posts: 613
Reputation:
Rep Power: 3
Solved Threads: 15
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.
•
•
Join Date: Dec 2006
Location: United States
Posts: 613
Reputation:
Rep Power: 3
Solved Threads: 15
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
•
•
Join Date: Dec 2006
Location: United States
Posts: 613
Reputation:
Rep Power: 3
Solved Threads: 15
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.
![]() |
•
•
•
•
•
•
•
•
DaniWeb VB.NET Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
- 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


Linear Mode