I'm in the process of learning C# and windows forms. What I'm trying to do is adapt some scripts I have already made using PHP and MySQL to work in a windows environment and GUI. I previously wrote it using PHP because I was already familiar with the language and could output the information I needed to a web browser, so didn't have to mess around with coding a proper GUI, but would now like to do so. I've been trying to work out the best way to do this, so have a few questions:
1) Would I be better off not bothering with MySQL and using MS SQL instead? Ultimately people will be able to download what I am making so I'm not sure which would be the best option in terms of when a user is installing all the necessary bits and pieces.
2) Could I ditch SQL databases entirely and run queries of some sort on flat text files (or excel files)?
3) I've been messing around with DataTables, and data sources of various types. What's the best one for displaying the contents of a database in a window? I'm not sure what the pros and cons are here.