I am looking for input on the best method to interact with data in a C#/Visual Studio Windows Forms application using an SQL database.
I have limited experience working with data in this scenario. What I am looking for is your input on if I should use Visual Studio’s “drag and drop” data binding to work with data or code the SQL connection/data set. I have worked with small apps using both methods to fill list boxes, text boxes where I have added new records, searched records and populated forms. The apps I build are used in my company to manage various data projects. I enjoy programming and learning new methods to incorporate into the apps.
I now find myself at a fork where I believe I would be better served to code everything related to data access. Getting the correct data in the correct format using SQL statements in code seems to allow for greater flexibility.
Am I wrong? Should I learn to better manage built in data binding functions?
Your thoughts on this are much appreciated.
- Brian
I have limited experience working with data in this scenario. What I am looking for is your input on if I should use Visual Studio’s “drag and drop” data binding to work with data or code the SQL connection/data set. I have worked with small apps using both methods to fill list boxes, text boxes where I have added new records, searched records and populated forms. The apps I build are used in my company to manage various data projects. I enjoy programming and learning new methods to incorporate into the apps.
I now find myself at a fork where I believe I would be better served to code everything related to data access. Getting the correct data in the correct format using SQL statements in code seems to allow for greater flexibility.
Am I wrong? Should I learn to better manage built in data binding functions?
Your thoughts on this are much appreciated.
- Brian
Comment