Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Ok, an example - adapted from an existing project. Names have been changed to protect the innocent :)</p> <p>First, the HttpHandler. This responds to a specific jQuery AJAX request that asks for the value of a session variable. As it's returning JSON, create a simple object to return the results (the return type can of course be as complex as you need): -</p> <p>(Again apologies for this being C# not VB.NET; I've tried to make it as straightforward as I can)</p> <pre><code>[Serializable] public class ResponseItem { public string SessionVariable { get; set; } public ResponseItem(string sessionVariable) { this.SessionVariable = sessionVariable; } } </code></pre> <p>For simplicity's sake, add the HttpHandler to your web project. You should download the latest version of Newtonsoft.Json and add a reference to it first. This handler simply take whatever is passed in the Request "sessionVariableName" parameter, try to retrieve a Session variable of that name and return its value as a String: -</p> <pre><code>[WebService(Namespace = "http : / / namespace not important for your test")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] public class Handler : IHttpHandler, System.Web.SessionState.IRequiresSessionState { public bool IsReusable { get { return false; } } public void ProcessRequest(HttpContext context) { string json = string.Empty; try { if (!string.IsNullOrEmpty(context.Request["sessionVariableName"])) { string sessionVariableName = context.Request["sessionVariableName"]; if (context.Session[sessionVariableName] != null) { var response = new ResponseItem(context.Session[sessionVariableName].ToString()); json = Newtonsoft.Json.JsonConvert.SerializeObject(response); } } } catch (Exception ex) { // you might want to create an "Error" type to return as JSON here } context.Response.Write(json); } } </code></pre> <p>You'll need to register your handler in web.config; I'll assume you're using IIS7 or above: -</p> <pre><code> &lt;system.webServer&gt; . . . &lt;handlers&gt; &lt;!-- Custom HTTP handlers --&gt; &lt;add name="Handler" preCondition="integratedMode" verb="*" path="Handler.ashx" type="YourProject.YourNamespace.Handler, YourProject" /&gt; </code></pre> <p>Finally, the front end. A simple test form: -</p> <pre><code>&lt;div&gt; &lt;asp:TextBox ID="txtSessionVariableName" runat="server" ClientIDMode="Static" /&gt; &lt;asp:TextBox ID="txtResponse" runat="server" ClientIDMode="Static" /&gt; &lt;input type="button" value="click me" onclick="javascript::CallHandler()" /&gt; &lt;/div&gt; </code></pre> <p>Method to call the handler: -</p> <pre><code>function CallHandler() { $.getJSON("Handler.ashx", { "sessionVariableName": $("#txtSessionVariableName").val() }, handleResult); } </code></pre> <p>Callback method to handle the result: -</p> <pre><code>function handleResult(result) { var sessionItem = eval(result); $("#txtResponse").text(sessionItem.SessionVariable); } </code></pre> <p>To test this, type the name of a session variable you know exists in your app; the handler should return it, and the callback function will write the contents to txtResponse.</p> <p>Sorry if that's a bit of a long example; let me know if you need any more help.</p>
    singulars
    1. This table or related slice is empty.
    1. POsimple and fast ways to retrieve session variables using Javascript or jQuery?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USsh1rts
    1. USsh1rts
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POsimple and fast ways to retrieve session variables using Javascript or jQuery?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks! I will dig in and try to learn something from this. Thanks for taking the time to help. I will let you know how this goes!
      singulars
      1. PO
      1. UStomepenn
    2. COThanks again. I picked up a lot of good pointers here for future reference. So in the end, I ended up with a bit of a quick hack as I ran out of time, threw a hail Mary and it worked! I ended up setting an asp:hidden field at the end of the OnUnload function that was wiping my data. I just ran out of time. Again, I learned several nice things here so thanks for taking your time to help.
      singulars
      1. PO
      1. UStomepenn
 

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