Forum Home
PC World Chat
 
Thread ID: 115222 2011-01-08 04:57:00 Prog Lang Suggestion learning (5137) PC World Chat
Post ID Timestamp Content User
1168152 2011-01-08 04:57:00 I last did programming like abt a decade ago and i am sure lots has changed since then so i am not in loop with the status quo

I need to develop a little Windows XP/7 based Program that will essentially
lookup a database and show results based on end user input in search field.

The database would probably be a MS Access 2007/2010 with which it will interact or probably a MS Excel doc that holds data in columns.

So the program will interact with database and pull info out of it

What would be quick and easy programming language avilable today to develop this in ? I dont prefer Java though.

I did some brief googling and saw Visual C++ /Basic / C# express available for free but i am not sure if it these IDE's will havae database components disabled or to what extent limited?

thanks
learning (5137)
1168153 2011-01-08 07:17:00 If you're simply presenting a form frontend to an Access database, why not just make this in Access? It's probably the most sensible way of doing it, unless you have requirements that you haven't told us - Access can do this kind of thing in its sleep.

Much though I hate it, Access does occasionally have its uses :rolleyes:.
Erayd (23)
1168154 2011-01-08 08:40:00 Personally I'd stay away from Visual Studio, and even Access, but that's just my preference. I'd go with a LAMP server (Linux, Apache, MySQL, PHP). Just a quick, basic PHP file that takes an HTTP POST, performs an SQL query, and returns data. There is quite a bit of example code out there that does all the heavy lifting for you, just dress it up with a bit of CSS, and any OS with a web browser is compatible with your application. ubergeek85 (131)
1168155 2011-01-08 08:43:00 If you're simply presenting a form frontend to an Access database, why not just make this in Access? It's probably the most sensible way of doing it, unless you have requirements that you haven't told us - Access can do this kind of thing in its sleep.

Much though I hate it, Access does occasionally have its uses :rolleyes:.


I also want to be able to append one column value with a string value dynamically i.e when the search results are displayed.

i.e All users have a cubicle number that will be in a separate colum in the database associated with each user.


when a search is done in front end form for a user and the resulting user details is shown, the users full location will be displayed in a field on the GUI form i.e the cubicle number will be appended at the end of a specific specific string value which will be dependent upon certain conditions. But i might be able to do some scripting with MS Access to achieve this i suppose

So your right, i didnt pay much thought to it. Now that you said it, i think i maybe able to just work with Access....lets see how it goes

Thanks
learning (5137)
1