Re: How complex is this, really?

If it were me, I'd just create an asp.net web app with a SQL backend. Users can enter orders on a "public" web site up until the event (hosting is dirt cheap). Also install the web app on the notebook (I assume it's yours).

The night of the event, I'd back up the SQL database and restore it to the notebook. You can run the web app locally (on the notebook) the night of the meeting and continue to enter orders as usual.

After the event, you can move the database back to the hosted site (if necessary).


"sam" <scarleton@xxxxxxxxx> wrote in message news:19e5d7d5-d4dc-43f3-8982-8f8a68a6fd3c@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have been a Window application developer for over 13 years. I know
SQL though I have been able to avoid it for a vast majority of my
career. I understand the basics of ASP.Net and Web servers, actually
put together a VERY basic Asp.net web site for my little business. It
was basically a static site that I used ASP.Net to implement a fancy
navigation system. But now I am wondering if I am biting off more
then I can chew...

My son's Boy Scout Troop has one big fund raiser each year and I have
volunteered to revamp the order entry/tracking software. Two people
from their respected homes will enter the orders into the system
through out the week. The night of the meeting orders will be entered
on a laptop that is disconnected from the Internet.

My whole strategy is to leverage what I know best, Windows.Form
development. I will develop a basic Windows Application in .Net 3.5
to enter orders. Originally I had some crazy ideas to make the data
store XML and sync everything myself. Then last night I learned of
the existence of SQL Server Compact 3.5 and Sync Services.

My thought now is to leverage SQL Server Compact 3.5, Sync Services,
and Web Services. All the web service would be doing is keeping four
different tables in sync for a handful of known users. My web hosting
account is .Net 2.0 but I only have access to a MySQL database. One
of the other things the web service is going to have to do is allow
large (500K ~ 4M) images to be uploaded (I am going to have the order
forms scanned into the system to ease order verification).

It sounds like pretty straight forward web service to me, but is it?
One of my issues is I don't know how to contend with security.

Hay, is there anyone out there that might be willing to give me hand
in this?

Sam

.

Relevant Pages

  • Re: error: The operation has timed-out (executionTimeout?)
    ... Actually, there was no SQL timeout issue in this case, and when I said ... fixing the performance of this particular report. ... I had to set executionTimeout in both my web site and the web ... web service timing out, then my web site timing out it's own request to the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Converting Web Site to Web Application (AJAX web service goes missing)
    ... I have just completed an exercise to convert a web site to a web app. ... You have to add the _ attribute to the class file for the web service and it then works. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: REPOST: One Web Service updates SQL, the other cant
    ... insert is executed a reference to rs.eof is invalid and the program bombs. ... > get recordset back and ADO could generate error here. ... Another instance of the same Web Service code, ... >> Watching both the debugger and the trace, SQL is receiving what I send ...
    (microsoft.public.vb.database.ado)
  • Performance optimization problem
    ... I have a social networking web site running on asp.net 2.0 and sql 2000. ... Recently we have updated the main page of the web site to make it display content based on the user's country, and her relationships, as opposed to just displaying the same content for everyone. ... the sql server is shooting to 100% cpu usage. ... There are a number of stored procedures that get loaded when the main page of a site is loaded most of them have a small read and duration value. ...
    (microsoft.public.sqlserver.clients)
  • Re: Tracing Web service calls
    ... Message logs. ... I beleive IBM have created such a tool for their web service ... No SQL database blocking. ...
    (microsoft.public.dotnet.framework.aspnet)