DataTable Relation - Want to save several Datatables into one xml

[kpmc]

With some clever manipulation you can create a relational system

Wes, don't confuse the poor lad even more. There is absolutely no manipulation adding a data relation to XML file, there is only adding the DataRelation. It is exactly the same for any connection based DBM. The biggest difference is that with XML it will write the DataRelation to the XML, thus you need not try to add it again. This is why in my example it first checks for relations prior to adding them.

I think you should first ask him/her what the application of the dataset is prior to suggesting a DBM. There are plenty of applications why a simple XML based dataset is spot-on

[wes4dbt]

Wes, don't confuse the poor lad even more. There is absolutely no manipulation adding a data relation to XML file, there is only adding the DataRelation. It is exactly the same for any connection based DBM. The biggest difference is that with XML it will write the DataRelation to the XML, thus you need not try to add it again. This is why in my example it first checks for relations prior to adding them.

I think you should first ask him/her what the application of the dataset is prior to suggesting a DBM. There are plenty of applications why a simple XML based dataset is spot-on

Not trying to confuse the OP. Just pointing out that XML is not a database. If the OP want to learn how to develop Relational Database Management Systems then XML is the wrong tool. If the OP wants to use an Xml file, that's fine with me.

[veronica.sa]

Not trying to confuse the OP. Just pointing out that XML is not a database. If the OP want to learn how to develop Relational Database Management Systems then XML is the wrong tool. If the OP wants to use an Xml file, that's fine with me.

NOt confused about this. I know a XML is not a DataBase.

[veronica.sa]

For my application saving the information in a XML is enough. Each project will have just a few data to save, no need for a DataBase.

Thanks for the video suggestion We4dbt

kpcm, you said I could use

TextBox1.DataBindings.Add("Text", MyTableBS, "MyColumn")

to DataBind the control property to the BindingSource/DataProperty(column name). I tried and is giving an error in this line.


First I did like this,

txtName.DataBindings.Add(txtName.Text, dtProjetoBindingSource, "NameProject")

but then I wnet back here adn lookedup more about it and changed for:

txtName.DataBindings.Add("Text", dtProjetoBindingSource, "NameProject")

It is not the location, I have checked and it is supposed to save in the folder I am choosing in the running time. But the file is not generated. I desibled these lines to check, they are the problem.