Click here to Skip to main content
16,016,759 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
What I'm trying to code is an application that works like:

Introduce a goat's age -> 1/1/2017 (then the application registers a tag and date)

Next time I run the application the, the application calculates how old every registered animal is. - How this would be done, my guess is using window's date as a reference to make the age difference and calculate the output.

I assume there's the need for a database. MSDB?

Now, I have no clue how to do this.



Anyone here can lend me a hand?


Update:


It's supposed to be a windows application, not a web site.
I was told that the best way to learn code is to practice.

Can someone explain me how complex this can be on the back-end?

What I have tried:

I'm trying to make an application to track the age of my animals.

I googled code examples and keep finding calculators - This isn't what I'm looking for.
Other examples are too complex as well.
Posted
Updated 20-Aug-17 16:59pm
v3
Comments
Jim Meadors 20-Aug-17 22:56pm    
What you want to do can be done with an Excel spreadsheet.
Clark Swanson 20-Aug-17 23:40pm    
You mean google spreadsheets?
Jim Meadors 21-Aug-17 22:34pm    
No, I mean Excel. You can create a form that is your main access to an Excel spreadsheet. On the form you can add all the user controls that you want for your data access and input and save it to the spreadsheet. Open the developer tab and press F1 to get help. I would start with designing a form that looks like everything I wanted and then add the code to make it work. Good Luck!

Answer - Part 1

You don't sound like you have much experience with programming, databases, and/or websites.

Have you considered first where you will be hosting the website? This will have an impact on which database options are available to you.

Have you visited the ASP.NET website? It is a very helpful website with lots of training resources for you: Learn | The ASP.NET Site[^]

Microsoft also has other great resource/learning websites:
* Technical documentation, API, and code examples | Microsoft Docs[^]
* Channel 9: Videos for developers from the people building Microsoft Products & Services[^]
* Microsoft Azure: Cloud Computing Platform & Services[^]

Before you start your main project, do smaller test projects and get familiar with C#, ASP.NET WebForms or MVC, Html, CSS, JavaScript, jQuery, SQL, and the database of your choice.

Once you feel confident with these technologies, then you are ready to begin planning, choosing who you will be hosting with, then working & debugging your main project.

Answer - Part 2

Regarding the Date format question, if you are building a website, then it is a global (worldwide) application by default.

You have no control over where your users are in the world. So you have no control over time zones. Therefore you need to work in UTC times and localize to the individual user.

You can read more about how to do that here: Converting times between time zones | Microsoft Docs[^]
 
Share this answer
 
v2
Comments
BillWoodruff 20-Aug-17 22:31pm    
+5 solid, useful, answer
Graeme_Grant 20-Aug-17 23:02pm    
Thanks Bill :)
Clark Swanson 20-Aug-17 23:21pm    
Still learning to use this forum ^^ First time here.

Thank you for your reply!

What if all I want is an app, no web site?

I'm wondering if it is something simple or complex on the back-end part.
Graeme_Grant 20-Aug-17 23:24pm    
Depends on how it is being used. Single user or multi-user. If single-user, then SQLite is simple to install and use; if multi-user, then SQL Server, MySQL, etc but they are not simple to install and maintain unless you know how.
Clark Swanson 20-Aug-17 23:35pm    
I'm starting to feel there are more practical solutions like google spreadsheets for this like someone mentioned above.

Since it would be multi-user, each time a user would like to register a newborn or check on an animal's age.
First of all, I recommend to write down what you want to do in details, it never hurt.
I use this hierarchical ToDoList app to do it,
- first entry is app features and I use subtasks to get into details until there is enough details on what I want.
- second entry is for database data and usage, kind of queries.
- third entry is for database structure with technical details about indexes and links between tables an so on.
ToDoList 7.1.3 - An effective and flexible way to keep on top of your tasks[^]
Quote:
Anyone here can lend me a hand?
Since the only real help of doing the app for you is out of topic, you have basically 3 choices:
- find an existing app and customize it to your needs. I use the TDL app to remember birthdates of people around me.
- have someone build it for you. Hire a professional programmer to do the job.
Hire Freelancers & Find Freelance Jobs Online - Freelancer[^]
- do it yourself, but you have a lot of study ahead.

[Update]
Quote:
my goal is to learn.
So for this purpose, I thought of a tracking application since I would be interacting with something I would use as a tool.
Any suggestion, as to what would you program to learn, if you could go back in time and tell yourself such?

Advice: Don't try to learn by doing a personal project.
You have to know that you can do pretty much anything in any language, simply some languages are harder for beginners because there is more pitfalls to handle.
You need to master a set of techniques that are the basis of the job and are not linked to a language.

You have to know that you can do pretty much anything in any language, simply some languages are harder for beginners because there is more pitfalls to handle.
You need to master a set of techniques that are the basis of the job and are not linked to a language.

You have to know that you can do pretty much anything in any language, simply some languages are harder for beginners because there is more pitfalls to handle.
You need to master a set of techniques that are the basis of the job and are not linked to a language.

Advices:
- Start with an easy/safe language: VB, Java, C#, not C or C++
- Read documentation / Follow tutorials (a lot of them)
- Start with tiny/useless projects, the purpose is to learn programming, not doing something useful.
- Start with console mode programs (no fancy graphics, no mouse)
- Learn debugger
Debugger - Wikipedia, the free encyclopedia[^]
Mastering Debugging in Visual Studio 2010 - A Beginner's Guide[^]
- A problem ? Google is your friend.
- Learn Boole algebra
- Learn one or more analyze methods, E.W. Djikstra top-Down method is a good start.
https://en.wikipedia.org/wiki/Top-down_and_bottom-up_design[^]
https://en.wikipedia.org/wiki/Structured_programming[^]
https://en.wikipedia.org/wiki/Edsger_W._Dijkstra[^]
https://www.cs.utexas.edu/users/EWD/ewd03xx/EWD316.PDF[^]
- Learn SQL
- Learn Databases design and Administration
Introduction to database design[^]
1NF, 2NF, 3NF and BCNF in Database Normalization | DBMS Tutorial | Studytonight[^]
- Learn Regular Expressions

Interesting link:
Learn to Program[^]

There is no shortcut to knowledge, no one can learn for you, you are the only one that can do it.
Remember the exercises and little projects are not here to make something useful, they are here to teach you programming.
 
Share this answer
 
v2
Comments
Clark Swanson 21-Aug-17 0:18am    
Now that I can reply...

I used to find existing code with arduino, toy with it to my needs, add, extend with new concepts.

With C# what I see out there made me realize I know nothing. Although I know some people that can't even google their own problems like I do.

The applications I've seen out there with C# are too complex for me to understand and my goal is to learn.

So for this purpose, I thought of a tracking application since I would be interacting with something I would use as a tool.

Any suggestion, as to what would you program to learn, if you could go back in time and tell yourself such?
Clark Swanson 21-Aug-17 0:56am    
Damn.

I'll get started.

I actually had this app installed:

https://www.sololearn.com and have been learning C# there, the comment section is very rich and friendly.

I guess so is codeproject.

This all started when I was doing an electronics project with arduino, I succeeded, made a mini-hospital floor work, all automated, sending data logs to a server, via TCP\IP.

A friend of mine advised me to learn C#, since it can cover many areas unlike PHP and arduino c.

I'll give all these replies a good read before I overload for the hour.`

Thank you for your advises! I mean it

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900