Embarking on first big program

[Deathblake]

It's time for me to start looking at how to make my first major application. I am looking at using Visual C# Express 2008. If another language sounds more suitable please suggest it

Right now I need help on how I am going to sort my data.

This is what my application will need to store (and edit):
Names of customers
Product information
Current months orders
Pending orders

Is it possible to add the information in current months orders into pending orders, then start over (For the end of each month)
Can information be extracted directly from one table into a cell in another? i.e Names of customers/Product information into Current months orders


Is it possible to upload the information in a table directly into comboboxes? And vice versa?

Basically I'm looking for general database help

I can create the tables, but it's the loading and saving from components that I need help with

I.e. Loading customer names and product information into comboboxes, hitting an order button and passing that information into the Current months orders.

I've done searches on MSDN but I may of missed an in-depth database tutorial

Thanks

[Red_Shadow]

Yea,
I suggest you use SQL for large data storages.
I don't do C# (for obvious reasons..) but this looks useful: SQL Basics In C# - C# Tutorials | Dream.In.Code

Hope this helps.

[lobo521]

Great book about database applications: Patterns of Enterprise Application Architecture The Addison-Wesley Signature Series: Amazon.co.uk: Martin Fowler: Books

I also recommend NHibernate for data access.

[Davide]

It is simple.
Add a Datagrid view to your form, and create a new DataSet with the that table inside it.
Add a few text fields for input, and to ad an entry:
DataSetName.Table.Add("field 1, "Field2")

Check out my video tutorials for C#: http://forum.codecall.net/showthread.php?25722
Vote them if you like them. I could make one about the DataGridView if you want to.