Xml file database c#

In this example we added a TextBox for XML file path, a Button to browse and select the XML file from our local drive, an OpenFileDialog component to handle the file selection, an Import Button which will perform the main functionality of our project, and a ProgressBar to show the progress rate of our application function. After designing the form, we can start coding.

We will follow some simple steps to get a better understand of our project. We will refer the same ConnectionString while writing the code for our WinForm. We also changed the Data Source Server Name with our local database server name. After adding the controls and the Namespace, we will start writing the code for each of our controls. First we will create an event of the Browse button. We will generate a DataTable by using that file. In this function, we are extracting XML nodes and by using these nodes we are structuring the DataTable.

Also, we are showing the progress of this function in the ProgressBar. After Generation of DataTable, we have to check whether the same table already exists in the database. If it already exists, then we will have to delete the table and re-create the same.

To do this, we need the table creation query that we are getting from the following function. In the above function we are generating a query for creating a table using a DataTable. This project can act as a sub-project or a module to any other project. You can integrate the concept within any of your projects where you are creating an SQL table dynamically by using XML files.

This will erase the need to write the code manually each time. This will help you survive the inevitable corruption that will occur during writing when something goes wrong.

Due to history of each data base company coming up with a "standard" interface that no other company follows, XML has become the defacto way to transfer data between databases. If this in the intended use than it is fine as it only has to write in this format some times. There is a lot to worry about in writting XML using.

Warning: The more processing cores the more often. Net screws up. Use Thread. EndCriticalRegion if you have more than four real cores. Also as suggested it is best to save the earlier version as a. Of course if the XML standards could have a declaration of "document set" then we could append a document each time and life would be a lot easier.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow.

Learn more. XML Database in C. Asked 11 years, 9 months ago. Active 10 years, 8 months ago. Viewed 20k times. Improve this question. Axarydax 16k 19 19 gold badges 89 89 silver badges bronze badges. Add a comment. Active Oldest Votes.

But you should also seriously consider not using XML as a database. Improve this answer. Jay Riggs Jay Riggs Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 10 years, 7 months ago.

Active 4 years ago. Viewed k times. Improve this question. Furqan Safdar Vijjendra Vijjendra Please format the data that you need to insert in datatable, properly. It is difficult to understand that way. Is there a specific reason you need a DataTable? You could probably define a serializable class and deserialize this into an object just as easy, and it would likely be more useful in that form. Joe:no there is no any specific, just want to store the XML file in tabular format..

Add a comment. Active Oldest Votes. Load "filename. Descendants "QuestId". Element "Answer1". Element "Answer2". Element "Answer3". Element "Answer4".