CODEWITHSUNDEEP
c#database-designdata-structuresdatabase-connectionmultiple-forms
Marc
Marc

Reputation: 1

C# App database - small, miltiple-form application - forms need to exchange data via database

To give you some background, the project I am working on is a poker tournament manager. It uses two forms - the main form will display information throughout the tournament, such as players remaining, player names, stakes, payout structure, time left etc; and the other form will be used as a 'setup' form. Both of these forms are built and working, but I am struggling to get them to share data with each other.

What I want to do is load the setup form, select my options for configuring the tournament, and then clicking 'save' will assign all of my options to variables and then write these variables to a database of some kind (I'm new to DB design and I haven't used any DB objects in Visual Studio yet). The main form can then read the DB and display the relevant data. The benefits I can see of this is that the tournament setup can be saved for future use, and player stats can be accumulated over time.

What sort of database object do I need to create to store this data, and how do I open connections etc and write data to the DB?

Upvotes: 0

Views: 377

Answers (1)

David Neale
David Neale

Reputation: 17018

I'd probably suggest that you use LINQ to SQL. ScottGu did an excellent series on blog posts on how to build a model with this. You only really need to read the first few for a simple CRUD application.

Reference: http://msdn.microsoft.com/en-us/library/bb425822.aspx

Upvotes: 2

Related Questions