What a Laugh

I could not help laughing when reading my server logs, besides the usual traffic, there are a few trying to launch games (none on my site) run perl scripts (no perl on my server) and hunt for some linux oriented folders etc. All I can say is good luck, because the server is secure, and the firewall prevents anything but port 80 requests in.

www.greenrelations.com

Now, the x64 machine I use is now doing better. Been upgrading the site, with ASP and ASP.NET as needed. Still questioning the usefulness of SQL for my own site, bit the manuals are good reading and I can see where SQL would be useful in a more complicated site.

Was considering serving my site from SQL but its not so easy for me to do yet. So back to the book.

Any simple code to grab content from an SQL server to serve pages from




Answer this question

What a Laugh

  • GodzillaMonster

    I do it for my vb-tips.com website. I have a dropdown list on an asp.net page which is bound to a dataset. The display member is the tips title and the value member is the tips id a guid. I have a div which has id = "dPage" runat="server" so I can change the value from the code behind file. I store the tips html in the sql server database and retrive it with the tips id from the database in the selected index changed event for the dropdown list. I set dPages.innerhtml to the tips html. The version I am using now uses ajax to change dpage.innerhtml without posting back.

  • crescens2k

    Hi!

    Thanks for asking! I'm a member of the ASP.NET team, and was just popping over here to see what was going on. The best place to ask ASP.NET questions is over on the ASP.NET forums at http://www.asp.net/welcome.aspx tabindex=1&tabid=39

    The best place to start would be the ASP.NET quick starts, as they have plenty of code for doing exactly what you're looking for. Check out http://www.asp.net

    HTH,

    PEte



  • Brian Fitzgerald

    Can you paste it here

    Might work, right now I am considering a menu to replace the table of contents parts of the left frame. After thats done, then I can look at feeding content from SQL, stuff takes time.

    I am looking at abandoning my simplistic frames based approach for a template/cookie cutter approach. I have no more then 12 pages to show, might grow to 15-20 max.

    So I am thinking, putting the banner, under the banner the menu, the body of the document, followed by another menu at the bottom for copyright/about/bla bla....

    Then I was going to use links inside the body, as well as from the menu. So there could be a few calls here and there to a SQL server to replace content.

    I know this could be done with a 3rd party tool, but that defeats the idea of actually learning how to hand craft a page.

    I presume the SQL calls can be pasted anywhere I would usually use a href tag   



  • Questa

    I found a book at the flea market thats exactly what I was looking for.

  • Frens

    OK I am using simple pages that are accumulating, they are text which is simple enough for SQL to manage. I guess I will need to create a form to feed text articles to SQL, you got any suggestions to create such a tool

  • houtexwebdev

    I just made a windows forms application for that in vs 2005. I have a tab control with 2 pages. Page one has a textbox on it and the other a webbrowser control. In the textboxes text changed event I set the webbrowser controls document text to textbox's text. That give me a little preview.




  • sacrosancttayyar

    Sounds like a workable solution, how many pages does your solution have to contend with

  • ujjwalprakash

    Currently I have 150 tips loaded


  • What a Laugh