How to store data in a table locally and present it in C #

Question

I want to set up a table that can:

• Saving data on a user computer
• Link and presentation of data in a graphical interface
• Ability to dynamically add rows at run time

What is the best way to do this?

DataGridView or TableLayoutPanel or ...? I am having problems with the CE SQL server, as I am going to connect it to the DataGridView, but I am very new to this work and wonder if SQL should be used at all.

Answer 1

SQL CE should work fine, but no: you don't need to use SQL. You can simply fill in the DataSet and save / load the file into a file. Or you can use any other serializable tree of objects and serializer like XmlSerializer etc. All of them should work fine with standard DataGridView bindings. However, note that these databases allow you to have more granular control over the data. It all depends on whether it is valuable, or if one flat file is enough.