Am a C#/SQL software developer.
I do a bit of IT work here and there for a bloke who runs a business from home, simple stuff thats hard for him.
Now what I am thinking of doing as a little project is making a program for something he has.
Basically he has a list "monthly customers" "monthly suppliers" both seperate Excel spreadsheets.
Then random number next to each one.
Each month there might be a new client so i'd have to add that to the list, with "NEW CLIENT" next to it, the next month taking away the "NEW CLIENT" part
then at the bottom it'll have total clients and total jobs. All the same with the customer one as well.
I've got the formuale in place that adds up total clients and jobs.
Just wondering if it'd be worth making a little program for adding clients and stuff. Just for portfolio mainly but also to get a bit of experience as well, i'm pretty sure it'd work as a fairly straight forward program.
What should I use? VB?
Probably best you use C# as it is the 'in' language at the moment. Use an SQL server of some kind (best option would be SQL CE, as you can then bundle it with the application and it will get installed under the clickonce installer). My advice for data manipulation would be to use Datatables, dont use datasets. If your loading data for grids etc, use a data adapter. If you setup the insert/delete/update commands of the data adaptor, you will be able to bind directly to a datagridview, meaning you wont have to manually manage the updating of data via specific events. Sounds like he wants a report at the end of each month, so display things in a printable format, write a crystal report. I would suggest the following tables:
tblCustomers - holds the details of the customers
tblSuppliers - hold the details of the suppliers
tblSales - holds all the sales order records
tblPurchases- holds all the purchase order records
from these tables, you can create a form that filters for all records int he current month. You can determin if they are a new customer/supplier in that month by use of a 'Date_Added' field in the customers/supplliers tables.
A good point of call if you get stuck in the MSDN website.