Databases
StackOverflow2013
Postsdbo
POaspx ashx mash-up
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POaspx ashx mash-up
    primarykey
    data
    text
    <p>I'm retro-fitting a .aspx page with AJAX functionality (using VB, not C#). The codebehind populates the page with data pulled from a web-service. The page has two panels that are populted (with different data, of course) in this way. On a full page refresh, one or both panels might need to be populated. But populating Panel 2 can take a long time, and I need to be able to update panel 1 without refreshing Panel 2. Hence the need for AJAX (right?)</p> <p>The solution I've come up with still has the old .aspx page with .aspx.vb codebehind, but introduces a Generic Handler (.ashx) page into the mix. Those first two components do the work on the user's first visit or on a full page refresh, but when AJAX is invoked, the request is handled by the .ashx page.</p> <p>First question: Is this sound architecture? I haven't found a situation online quite like mine. Originally, I wanted to make the .aspx page into the AJAX handler by having the codebehind implement IHttpRequest, and then providing "ProcessRequest" and "IsReusable" methods, but I found I couldn't separate a regular visit to the page from an AJAX request, so my AJAX handlers took over even on the first visit to the page. Second question: Am I right to think that this approach (making the .aspx page do double-duty as the AJAX handler) will never work? Is it impossible to tell whether we're getting a full-page request or a partial-page (AJAX) request?</p> <p>If the architecture <strong>is</strong> good, then I need to dynamically generate a lot of HTML in the .ashx file, right? If that is right, should I send HTML back to the client, or should I encode it in some way? I've heard of JSON encryption, but haven't figured out how to use it yet. So, Third question: Is "context.Response.Write" the only pipeline for sending data back to the client? And, if so, should I send back HTML or some kind of JSON-encoded objects?</p> <p>Thanks in advance.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJoel Coehoorn
    1. USnttaylor
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POaspx ashx mash-up
      1. This table or related slice is empty.
      1. VTUpMod
    1. COA couple of questions. Was there a particular design constrained for why went with an `.ashx` handler to do the asynch stuff over a straight up `.asmx` webservice call? Is client side JS templating at all a viable option? If it is you could have a webservice that returns JSON data and you can format it to HTML client side using JavaScript and insert the new content into the DOM.
      singulars
      1. POaspx ashx mash-up
      1. USR0MANARMY
    2. COI'm not familiar with .asmx (just had to look it up!) but the web-service part of this equation is pretty straightforward. As to the JSON data, yes, I could format it into HTML with javascript on the client side, I just haven't learned how to generate JSON-encoded objects yet.
      singulars
      1. POaspx ashx mash-up
      1. USnttaylor
    3. COWhich version of ASP.NET are you on?
      singulars
      1. POaspx ashx mash-up
      1. USR0MANARMY
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload