5

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.

Improve this question

4 Answers 4

Reset to default
3

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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

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.

Improve this answer

Comments

2

If you are looking for a RAD none generic solution use GRIDVIEW with winforms ,if you are looking for a generic and flexible solution i liked this tutorial

Improve this answer

Comments

1

I would go for WinForms for the first application. To display your data I'd use a DataGrid which I would feed a DataTable filled with the query result. The Grid and the Table have standard sort functionality built in.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.