To Bind Or Not to Bind
-
Hi, I have a question regarding binding and am looking for the pros and cons of each. The question is whether to bind a windows forms system to a database on the server or to have it store the data locally on each of the clients computers and update/insert/delete/ and refresh only when the user has made a change or switched tab pages etc. My current database is not connected to the database and retrieves and stores the data in one dataset and that dataset gets updated as needed. Not sure if it is more efficient to connect directly to the database or if it is better coding standards etc to be linked to the database. Thank you
eatwork
-
Hi, I have a question regarding binding and am looking for the pros and cons of each. The question is whether to bind a windows forms system to a database on the server or to have it store the data locally on each of the clients computers and update/insert/delete/ and refresh only when the user has made a change or switched tab pages etc. My current database is not connected to the database and retrieves and stores the data in one dataset and that dataset gets updated as needed. Not sure if it is more efficient to connect directly to the database or if it is better coding standards etc to be linked to the database. Thank you
eatwork
I would imagine the best solution would probably be just to use the database, that is what they are for.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog
-
I would imagine the best solution would probably be just to use the database, that is what they are for.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog
-
hello christian, thank you for your reply. Point well taken, but does it require more maintenance in the future is it faster, etc? thank you
eatwork
In fact, it's faster and easier to maintain.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog
-
In fact, it's faster and easier to maintain.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog
Thanks, are there any other pros / cons that you can think of for binding a database? And do you know of any examples/solutions out there that I could look at? My project has 120 tables and the system requires a user login, the user to select their database connection location on the server and I am not sure I want to continue the project in the unbound format. Thanks
eatwork
-
Thanks, are there any other pros / cons that you can think of for binding a database? And do you know of any examples/solutions out there that I could look at? My project has 120 tables and the system requires a user login, the user to select their database connection location on the server and I am not sure I want to continue the project in the unbound format. Thanks
eatwork
To be honest, I'd assume being bound to the database would be the default, and most examples on the web would assume this approach
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog