sql admin needs to know where to start a web development project using sql server

  • I am not a student although this may so very beginnerish. I am an sql server admin and back end developer and have a client on the the side with an AC servicing company that is paying enough to make it worth while to go through the learning curve of web development for him.

    I will use Visual Studios 2008 or 2010 beta 2. He wants company management software that can be accessed from by him and by any potential clients.

    I can google the details, if someone will help me with the building blocks.

    I did write a cool little app in vs 2008 c# as a windows service that used the filewatcher to raise the event to fire some code. Filewatcher is pretty cool if you have not used it. when a file is moved to a directory , you can have any code kick off, in this case it moved it to its final directory and called t_sql to update the Db table to say it was there. Someone told me to use filewatcher to do it. I told them I'd be starting on google. The said thats fine. 4 days later it was tested and went live.

    I just mentioned mostly to share that although I have not written a novel, I have written a short story. Your help will be very much appreciated and not for nothing.

    here is my question.

    Were do the building blocks go?

    In my research for a website host company, will I be looking to use their Sql server to store the data or will I be somehow putting like sql 2008 express on their site?

    Asp.net is for the round trips from the browser to the webserver .yes?

    ADO.net allows you to talk to the DB. Yes? I will surely need to use ADO.net or is there a better way to talk to the DB engine?

    C# does logic that does not require a round trip to the server. Am I on the right track?

    C# is the same as VB accept it uses curly braces?

    That was a joke.

    CSS is where you put the foreground, background, images, styling info of that nature. Something like that?

    When it is all finsihed and working correctly, I move the website files to the proper folder on the web server, and I recreate UDF's and Stored procedures on the website host's sql server, and maybe do a back up of the DB locally and restore it to their SQL server (or use SSIS to copy it).

    Should I be working off the hosting web server much sooner in development? I think some of this is on the right track, but I know some of it is not and some blocks are missing.

    There is no point in me starting to I have researched a viable route 🙂

  • Windows service and Asp.net application cannot be compared because the later is very complicated. That said the first link takes you to free decent tutorials and the second link takes you to ready to used finished Asp.net and PHP applications.

    http://www.asp.net/learn/

    http://www.microsoft.com/web/gallery/default.aspx

    Kind regards,
    Gift Peddie

  • Thanks very much. the links are helpful.

    How is Dot Net Nuke related to all this.

    Is it popular among windows based web developers and something I should consider employing?

    Is it something you load on the web server the helps devlope more powerful sites faster.

    Basically, I want to learn and work with what the rest of the industry considers a strong and commonly used product.

    I overheard a web developer at my last IT shop going on about DNN.

  • adam spencer (1/29/2010)


    Thanks very much. the links are helpful.

    How is Dot Net Nuke related to all this.

    Is it popular among windows based web developers and something I should consider employing?

    Is it something you load on the web server the helps devlope more powerful sites faster.

    Basically, I want to learn and work with what the rest of the industry considers a strong and commonly used product.

    I overheard a web developer at my last IT shop going on about DNN.

    DNN is just one framework in that second link, there are many others, it will help if you get some help for your first project so you can learn faster. Let me know if you need some help.

    🙂

    Kind regards,
    Gift Peddie

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply