Using C# to create a frontend for a simple database

Question

I've only used C# to create console apps up to now. What I would like to do next is create a c# application that could open a one table database (probably sqlite) and present the data in table form to the user. I'd like the user to be able to do things like sort by column, search etc. I have a couple of questions with regards to the GUI piece.

What would be the appropriate .Net technology to use for the GUI front end? WinForms?

I would really appreciate a link to a tutorial or worked example of doing something similar

Any help appreciated.

Answer 1

This tutorial shows you how to create a DataGridView, load database values in it. The sorting is an automatic property of the DataGridView. The DataGridView is a control used in a WinForms application, which seems the best solution for your needs.

Answer 2

In your situation I would start with WinForms as GUI technology - simpler and more mature than WPF.

Here

http://www.codeproject.com/KB/cs/SQLiteCSharp.aspx

you find an example application for a single table SqlLite DB.