I want to have a GUI in which I can type a store number and press search. The application should now extract (from preferably an Excel spreadsheet) that particular store's hours and display them. Now if I search for a second store number, I want the application to display only the hours of the week that are longer than store # 1.
1. What programming language should I use? (I'm thinking Acess, Visual Basic, AutoIt)
2. Depending on my choice of programming language, would it be possible to use the Excel spreadsheet as the source for the data?
3. Do I need to use any special logic when trying to compare hours (10am-5pm vs. 9am-5pm)?
What programming application should I use to achieve the following:?
I would suggest using VisualBasic, if that's what you are comfortable with, and hooking it to an Access backend - if it's only going to be used by you, or just a couple of people. Access doesn't do well with several concurrent users.
In my experience, getting data directly from an Excel spreadsheet can get messy, and if one little cell is referenced incorrectly, everything will be hosed. I would strongly suggest importing the data from the Excel spreadsheet into a table in Access, and getting the store hour data from there. As far as comparing hours, you may want to convert them to 24 hour time format, then compare, That way you don't have to worry about all of the calcs necessary to make sure the program doesn't recognize 10am as later than 9pm. In 24 hour format, it would be comparing 10 to 21, and will avoid those issues. Good luck.
Reply:I'd suggest using a Microsoft Language if you're planning to work with MS applications like Excel to read from. Either VB or C# is good.
After you read the value from the excel sheet, you'll need to convert it to a DateTime object, both are easily done in VB or C#. After you convert it to DateTime doing the compare is easy, you can easily check if one value is before/after/same time as the other.
id cards
Friday, May 21, 2010
What do you think of a tutorial software that teaches basic programming of C in Filipino-English language?
For any Filipino programmer / IT student:
What is your opinion regarding with a tutorial software, which teaches the basic programming of C? The medium of instruction is Taglish (that is, combination of Filipino and English languages).
We are currently conducting a survey.
For more information, please contact me: Send me an email.
What do you think of a tutorial software that teaches basic programming of C in Filipino-English language?
That would be a good idea for Filipino programmers who may have difficulty in understanding English.
However, I would suspect that many Filipinos who wish to pursue a technical career or knowledge would need to know English as the majority of resources that surround the C programming language including hardware, networking, etc. are predominantly already in English. Getting support and seeking help online are also generally in English.
Re-inventing the wheel may be unproductive if your skills can be used to focus on the development of software that are of current interest to a larger target market on a global scale.
I would recommend surveying how many Filipino programmers actually have low English comprehension as part of your effort before final consideration for development.
Good luck!
What is your opinion regarding with a tutorial software, which teaches the basic programming of C? The medium of instruction is Taglish (that is, combination of Filipino and English languages).
We are currently conducting a survey.
For more information, please contact me: Send me an email.
What do you think of a tutorial software that teaches basic programming of C in Filipino-English language?
That would be a good idea for Filipino programmers who may have difficulty in understanding English.
However, I would suspect that many Filipinos who wish to pursue a technical career or knowledge would need to know English as the majority of resources that surround the C programming language including hardware, networking, etc. are predominantly already in English. Getting support and seeking help online are also generally in English.
Re-inventing the wheel may be unproductive if your skills can be used to focus on the development of software that are of current interest to a larger target market on a global scale.
I would recommend surveying how many Filipino programmers actually have low English comprehension as part of your effort before final consideration for development.
Good luck!
How does knowledge of programming concepts benefit individuals working in almost any IT position?
Include at least one specific example of how Java programming knowledge benefits nonprogrammers working in IT.
How does knowledge of programming concepts benefit individuals working in almost any IT position?
Knowledge of the basics of any programming language and designing a program can be helpful in the fact that you will understand the thought processes of writing code. This can be helpful when interacting with a programmer in regards to a specific module he/she has written. For example, if you are reporting an issue with a module, understanding how that module is put together may help you explain the issue to the programmer.
Most users/non-programmers think in terms of the end result, the screen, the report, the message being displayed, whereas the programmer will think in terms of the programs that drive the output and the underlying data. This disconnect tends to slow the process of solving issues.
For this reason, good programmers will request user training on an application so they know how the users use the application everyday.
The fact that you are not a programmer and are being asked to learn a language is strange but in the long run it may help you and your career.
How does knowledge of programming concepts benefit individuals working in almost any IT position?
Knowledge of the basics of any programming language and designing a program can be helpful in the fact that you will understand the thought processes of writing code. This can be helpful when interacting with a programmer in regards to a specific module he/she has written. For example, if you are reporting an issue with a module, understanding how that module is put together may help you explain the issue to the programmer.
Most users/non-programmers think in terms of the end result, the screen, the report, the message being displayed, whereas the programmer will think in terms of the programs that drive the output and the underlying data. This disconnect tends to slow the process of solving issues.
For this reason, good programmers will request user training on an application so they know how the users use the application everyday.
The fact that you are not a programmer and are being asked to learn a language is strange but in the long run it may help you and your career.
Is there a programming language better than Ruby on Rails in regard to creating a large dynamic web system?
Ruby on rails is not a language. It is a web framework built on the programming language Ruby. "Better" is such a subjective term. RoR is quite easy to get into, and great because of it's AJAX integration and database ORM. There are a few alternatives worth checking out:
Turbogears (Python)
Django (Python, my personal favourite.)
Is there a programming language better than Ruby on Rails in regard to creating a large dynamic web system?
I think PHP is better then Ruby on Rails
Reply:php
Turbogears (Python)
Django (Python, my personal favourite.)
Is there a programming language better than Ruby on Rails in regard to creating a large dynamic web system?
I think PHP is better then Ruby on Rails
Reply:php
What is the best and easiest way to learn a programming language?
Can you give me some ideas and tips
What is the best and easiest way to learn a programming language?
It depends which one you are taking about. If you have little programming experience learn HTML first and a little Java script and then you can choose between Java and C++. I find books a better way to learn because the web guides are not too thorough.
Reply:I think it really depends on what kind of learner you are. But one thing is sure - going to school is always a good way to do it.
If you can't - or don't want to - go to school, I would suggest getting a good beginner's book in a language like VB that is fairly easy to learn. Get a free edition of an IDE (Visual Studio Express for VB.NET, Eclipse fo Java, etc) and start following the tutorials in the book.
Deitel makes a great beginning programming book called "Simply VB.NEt" and it takes a tutorial approach, allowing you to follow along and create several different programs as you go.
Basically, the best way to learn to code is to jump in and start coding. But it is crucial to learn best practices, as well as control structures, so you don't make a bunch of spaghetti code.
Good luck and happy coding.
Reply:No matter what you pick, w3schools.com is the best way. Clean and simple. They have a huge list of things you can learn.
Oh... it's free ;-)
flowers online
What is the best and easiest way to learn a programming language?
It depends which one you are taking about. If you have little programming experience learn HTML first and a little Java script and then you can choose between Java and C++. I find books a better way to learn because the web guides are not too thorough.
Reply:I think it really depends on what kind of learner you are. But one thing is sure - going to school is always a good way to do it.
If you can't - or don't want to - go to school, I would suggest getting a good beginner's book in a language like VB that is fairly easy to learn. Get a free edition of an IDE (Visual Studio Express for VB.NET, Eclipse fo Java, etc) and start following the tutorials in the book.
Deitel makes a great beginning programming book called "Simply VB.NEt" and it takes a tutorial approach, allowing you to follow along and create several different programs as you go.
Basically, the best way to learn to code is to jump in and start coding. But it is crucial to learn best practices, as well as control structures, so you don't make a bunch of spaghetti code.
Good luck and happy coding.
Reply:No matter what you pick, w3schools.com is the best way. Clean and simple. They have a huge list of things you can learn.
Oh... it's free ;-)
flowers online
In visual basic programming, how can i insert a picture for a cursor, instead of the default pointer?
I don't want a typical cursor for my program in Visual Basic. I've seen people upload other pictures, such as cross-hairs to symbolize a gun's aim instead of a cursor. How do I do this?
In visual basic programming, how can i insert a picture for a cursor, instead of the default pointer?
http://www.wilsonc.demon.co.uk/d10resour...
http://www.thefreecountry.com/programmin...
I think you need to make a dll that contains the custom cursor.
http://support.microsoft.com/kb/76666
"How to Create and Use a Custom Cursor in Visual Basic; Win SDK
View products that this article applies to.
Article ID : 76666
Last Review : December 12, 2003
Revision : 2.0
This article was previously published under Q76666
On This Page
SUMMARY
MORE INFORMATION
Important
SUMMARY
Using a graphics editor, the Microsoft Windows Software Development Kit (SDK), and the Microsoft C compiler, you can create a dynamic-link library (DLL) containing mouse cursors that can be used in a Microsoft Visual Basic application. By making calls to the Windows API functions LoadLibrary, LoadCursor, SetClassWord, and GetFocus, you can display a custom cursor from within a Visual Basic application. Below are the steps necessary to a create a custom cursor and a Visual Basic application to use this custom cursor. "
Reply:Hi there .. I've found a wonderful site that shows you step by step in how to create a resource file using the Add-in Manager tool and the codes to put into your project. I've used it a few times and it works wonderfully. I find Microsoft sites quite overwhelming sometimes .. hehs
Hope this helps
In visual basic programming, how can i insert a picture for a cursor, instead of the default pointer?
http://www.wilsonc.demon.co.uk/d10resour...
http://www.thefreecountry.com/programmin...
I think you need to make a dll that contains the custom cursor.
http://support.microsoft.com/kb/76666
"How to Create and Use a Custom Cursor in Visual Basic; Win SDK
View products that this article applies to.
Article ID : 76666
Last Review : December 12, 2003
Revision : 2.0
This article was previously published under Q76666
On This Page
SUMMARY
MORE INFORMATION
Important
SUMMARY
Using a graphics editor, the Microsoft Windows Software Development Kit (SDK), and the Microsoft C compiler, you can create a dynamic-link library (DLL) containing mouse cursors that can be used in a Microsoft Visual Basic application. By making calls to the Windows API functions LoadLibrary, LoadCursor, SetClassWord, and GetFocus, you can display a custom cursor from within a Visual Basic application. Below are the steps necessary to a create a custom cursor and a Visual Basic application to use this custom cursor. "
Reply:Hi there .. I've found a wonderful site that shows you step by step in how to create a resource file using the Add-in Manager tool and the codes to put into your project. I've used it a few times and it works wonderfully. I find Microsoft sites quite overwhelming sometimes .. hehs
Hope this helps
What kind of programming skills are needed to allow a site search within its database and take voting info?
What is the difference between a programmer proficient in Ajax vs ASP? I would like to develop a site that is capable of taking in user info, sorting it and categorizing it in a database to be released when another user is in search for such information. What skills are necessary to create a photo sharing-blog community?
What kind of programming skills are needed to allow a site search within its database and take voting info?
That sounds like a fairly difficult undertaking! I certainly would not use plain ASP; you would be much better off using ASP.Net, but Ruby on Rails would be the other logical choice. As far as skills, you are looking at a 3-tiered application: a user interface tier, a business logic tier, and a database tier. So, you would need to know a fair amount of HTML and JavaScript to create nice web pages, and probably Ruby or C# for the business layer, and SQL and some database administration skills for the database layer. Good luck!
What kind of programming skills are needed to allow a site search within its database and take voting info?
That sounds like a fairly difficult undertaking! I certainly would not use plain ASP; you would be much better off using ASP.Net, but Ruby on Rails would be the other logical choice. As far as skills, you are looking at a 3-tiered application: a user interface tier, a business logic tier, and a database tier. So, you would need to know a fair amount of HTML and JavaScript to create nice web pages, and probably Ruby or C# for the business layer, and SQL and some database administration skills for the database layer. Good luck!
Subscribe to:
Posts (Atom)