C# Order Entry Code Primer

I am looking for sample code written in C# that would illustrate the basic concepts of creating an order entry program. This could be for sales or purchase. The most important concepts would be establishing an header to detail relationship. The header would have customer/vendor information plus the document total dollar amount. In the detail section would be a datagrid containing the detail of what was ordered. The extended price column would be dependent upon the quantity ordered times the sell price and the document total amount would be dependent upon the extended price of the lines.  The sample can use the Northwind database as a base. This code would be wrapped around a SQL database.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

anarki_jimbelSenior DeveloperCommented:
It's pretty hard to find exactly what you want. And of course no one would write a sample specially for the question.

have a look at the link, this is most relevant to your question, I think:


The idea how to build such applications - look at this example, quite interestin and more sophisticated than the above one:

rwheeler23Author Commented:
Thanks, I will give these a look. I can do this in other languages, I just need to get more up to speed with VS C#.
anarki_jimbelSenior DeveloperCommented:
I quite liked the second example but didn't get into details.

That example is for MS Access database, not SQL Server.

Not much difference but you'll need to use SqlDataAdapter rather than OleDbDataAdapter, SqlDataReader rather than OleDbDatareader, SqlCommand rather than OleDbCommand etc.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rwheeler23Author Commented:
Thnaks for your tips. Now I need to find the time!
rwheeler23Author Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.