[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

architecture suggestion needed

Posted on 2007-08-01
10
Medium Priority
?
233 Views
Last Modified: 2013-11-12
Hi:

I would appreciate some suggestions on what programming language and/or tools to use for the a few projects in hand.

Basically the requirements of my projects are:
1. There will be an interface for users to provide inputs and run the programs.
2. There is a database at the backend where all the data needed is stored.
3. After user press some button, the output will be some numbers, data tables, and more importantly, graphs and bar charts, etc. The program should also allow user to push another button and export the output to a file if they want to.

I am free to choose whatever programming languages or tools to use.  I have some experience with core java but have found java interface (AWT, SWING) isn't that easy to work with. In the paste I have been using Excel/VBA to do the work. The advantage of this is that output is right in the same file as the UI. And the user could save a copy of a particular run if he likes. But personally I don't like VBA so much thinking it isn't such an "advanced" programming language (or I am just not used to it?).  I have done a little bit of C# before and found it is pretty convenient for GUI. But, would it be easy to output graphs/charts and have those output exported to a file?

Anyway, this is an open end question. Any suggestions and thoughts about the architecture to use would be very much appreciated. Thank you.
 
0
Comment
Question by:sdc248
  • 6
  • 4
10 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 19610632
1) Is this going to be a web application or desktop application?

2) What are your deployment requirements?

3) Is this going to be a simple GUI, or does it have complex requirements?

4) What type of database are you working with (SQL Server, Access, Oracle, ...)?

bob
0
 

Author Comment

by:sdc248
ID: 19612018
1) this is going to be a desktop application.
2) the application will be placed in a folder on the server that is accessible by everyone in the company.
3) probably a couple of forms will do the trick.
4) database is SQL Server

Thanks.
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 1000 total points
ID: 19612038
C# can make this pretty easy, and provides ClickOnce deployment options to automatically deploy updates.  VBA is associated with Microsoft products like Access or Excel, and in my opinion not a viable development language.  If you think that Java/Swing is complex, then I wouldn't suggest using it.  It requires a lot of work for desktop applications and database access.

There is a free, downloadable version of C# Express Edition 2005.  Do you already have SQL Server installed?

Bob
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:sdc248
ID: 19612122
Is it a good idea to use C# as interface, while using java as business logic layer? i.e. Is it easy to invoke java program from C#? What if the result being outputed from java is a data set/ table? I am considering this because I am more familiar with java than C#, but of course this can be changed by working on more C# projects.

Are there tools out there to help building interface with Java?
0
 

Author Comment

by:sdc248
ID: 19612136
Our company has SQL Server 2005 installed.
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 19612311
C# has tools that interoperate with SQL Server pretty seamlessly.  There are DataSet wizards, and TableAdapters that let you create typed DataSets that are pretty handy if your schema doesn't change frequently.

Bob
0
 

Author Comment

by:sdc248
ID: 19612425
yeah, I kind of remember there are DataGrids that I can use to output whatever comes out of a query in one shot which is pretty cool. But how about graphs and bar charts? Are there readily available tools or plug-ins I can use to produce them easily?
0
 

Author Comment

by:sdc248
ID: 19612438
And how about exporting result sets and graphs to a file, Excel, maybe?
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 19612484
1) Integrating with Excel can be kind of tricky

2) While I haven't used it (I use Dundas . NET charting), I have heard of a free charting tool for .NET:

Chart FX Lite for .NET - Free .NET Charting!
http://www.softwarefx.com/sfxNetProducts/cfxLiteForNet/

3) 2005 has the DataGridView to display data in a grid, and can be bound to a DataTable, or any object that implements the IList interface.

Bob
0
 

Author Comment

by:sdc248
ID: 19627653
I got it. Thank you Bob.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.
The viewer will be introduced to the technique of using vectors in C++. The video will cover how to define a vector, store values in the vector and retrieve data from the values stored in the vector.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question