Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > C# and C > C# 1.0 > C#
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
C# Programming questions specific to the Microsoft C# language. See also the forum Beginning Visual C# to discuss that specific Wrox book and code.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the C# section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 3rd, 2004, 12:56 PM
Registered User
 
Join Date: Nov 2004
Location: Berkeley, CA, .
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default Confused about C# and Access

i am working on a database in Access, but i'm not too far along with it. A friend (programmer) told me i should use C#. i've been reading "Beginning C# Databases", but i still can't figure out if i would be better off creating the database in C#, SQL, Access,or a combination of those. This database will contain data about myths around the world to be distributed via the web and CD. Can someone please help straighten me out? Thanks.
--e
Reply With Quote
  #2 (permalink)  
Old November 3rd, 2004, 02:24 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Will the database change often? And do you need dynamic capabilities when it comes to defining the database?

Usually, you create the database in Access (or any other database engine / server) and then use code like C# to access the database and select, insert, update and delete records.

So, usually there is no need to create the database at run-time through code.

Does that answer your question?

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Last Call by Big Boi feat. Slimm Calhoun, Lil’ Jon & The East Side Boyz & Mello (Track 18 from the album: Speakerboxxx) What's This?
Reply With Quote
  #3 (permalink)  
Old November 3rd, 2004, 02:49 PM
Registered User
 
Join Date: Nov 2004
Location: Berkeley, CA, .
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default

No, the database will not be updated often, if at all, once the application is completed. i have image and text files in different directories on my computer that also need to be accessed, and the text files must be searchable by the user.

If i understand you correctly, i would create the tables in Access and the user interface, i.e., forms (and the code behind them) in C#.

Or would Java be better than C#? My application must be cross-platform on the CD.

Thanks,
--e
Reply With Quote
  #4 (permalink)  
Old November 3rd, 2004, 02:55 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

If it has to run from a CD, you'll be in trouble. A CD is read-only, so you cannot update the database.

How cross-platform does it have to be? If you're coding in C#, your users will need the .NET framework. Many Windows machines will already have it, and for other OS's there is Project Mono. Not sure how stable that is yet, though.

What kind of application are you building? Is a CD the best distribution mechanism? What about a Web application?

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Party Weirdo by Moloko (Track 9 from the album: Do You Like My Tight Sweater?) What's This?
Reply With Quote
  #5 (permalink)  
Old November 3rd, 2004, 05:33 PM
Registered User
 
Join Date: Nov 2004
Location: Berkeley, CA, .
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default

As the application is currently set up, it has text files and images, each stored in their own file directories and referenced in the application via relatie paths. All text files must be searchable, in addition to the database.

The application contains, e.g., :
1. Text excerpted from books studied by the artist who painted the images (accessed via relative paths). Book data is given for the user, i.e., title, author,publisher, page num of the relevant myth, etc.
2. Files containing images of the paintings for the myths (accessed via relative paths).
3. The location of the myth is provided
4. The people who created the myth is provided
5. More than one version of the same myth is provided where appropriate
etc.

The finished application will not be editable, only searchable (both text and the database itself).
Re the website, users have no edit, add, delete privileges--the application is strictly for reference and study purposes.

This application also will be given away via CD at an art retrospective showing the 600+ paintings in the application created by a Professor Emeritus from UC Berkeley.

The art retrospective is funded by my employer, a non-profit organization.

An extensive program is also being created for seminars with various academics and luminaries from around the world and
also for elementary (in particular), junior-high, and high-school programs. These myths address questions all people ask, like "Where are we from?", "Why is there sickness?", etc.

Most individuals and businesses have Windows-based PC's, but many, many schools use Macs, thus the desire for cross-platform CDs.

i hope this addresses the issue of CD vs. web versions.

--e

P.S. What is Project Mono?
Reply With Quote
  #6 (permalink)  
Old November 4th, 2004, 05:03 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi again,

Sorry for the late response. Somehow this message got lost in my mail box.

Anyway, Project Mono is an open source OS-independent (sort of) implementation of .NET. You can find out more about it here: http://www.mono-project.com/about/index.html

I am not sure if and how you could create a OS independent application that will run on a variety of platforms. It sure won't work with C# / .NET / Project Mono as it requires the run-time to be installed on the client, which will definitely not be there by default on OS's like Linux and Mac OS.

I think your best bet is to create a browser based application that runs on the local client in a browser. That allows you to create applications with Java or maybe even with Flash.

Either way, it's a daunting task.....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
The Following User Says Thank You to Imar For This Useful Post:
baker_eliz (March 30th, 2010)
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
confused mohabedalgani VB.NET 2002/2003 Basics 3 March 30th, 2005 11:48 PM
I'm Confused. Help!!! dangel75 General .NET 1 July 10th, 2004 09:54 AM
Confused on error fs22 Javascript 5 June 23rd, 2004 11:53 AM



All times are GMT -4. The time now is 02:58 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.