Connecting asp.net web-application to a system..

[Rashrashetta]

Hai all,


I am a computre science student.I am actually required to build a
system with the following description: an intructor wants to use an
excel sheet to put his/her students marks information in. This must be
done via a simple interface of a simple system. Also he would like to
be able to send emails to his student using this system. Now on the
other hand, the stundet must be able to access a web page using
his/her ID and password to see his/her marks and other
information.....
So, we decided that we need to build an application for the instructor
and a web-application to make the web-page for the students.


Now, the problem I have is that I cant understand how the connection
will be betweeen the web-page and the excel sheet on the instructor
computer. Do I have to make sure that the two parts of the system (
The intrustor system and the web-application ) are available on the
instructor PC, so that somehow he can publish the asp or jsp page to
the internet?? And of course that way, it will be easy becuase the
excel sheet is in the same place as the web-application...Or I may be
able to seperate the two parts?...I mean the istructor just install
the parts he want....and in another place I will install the
web-application and then publish it....BUT...at that time how can I
define the connection between the web-application and the excel sheet
to read from???Is it via ODBC? Or shared folder? and how?
Because when I use the ODBC I have to browse for the excel sheet but
only on my computer!! And about shared folder, I just heard about it
but know nothing how it can be created????


Thanks alto for reading this long message....
Yours,
Rahsrashetta

 

[Kamal Vaghjiani]

Rashrashetta

If my understanding is correct then the excel spreadsheet is the
datasource......

So if this is the case, create one web application which requires login,
when the student logs in he only see what the students are supposed to see
and when the teacher logins in he has a menu of items enabling him to set
student information.......

this way you don't need to worry about connections as the excel spreadsheet
will be on the webserver directory.....

I hope this helps

KV

 

[Kevin Spencer]

I'm a bit confused. Your first paragraph seems to spell out the requirements
of the app well enough. However, there seems to be a gap in your discourse.
In the third paragraph, you say that you can't "understand how the
connection will be between the web-page and the excel sheet of the
instructor computer." How did an Excel Spreadsheet become a requirement for
your app? It's one of the worst database back-ends you could possibly
choose.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.