Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>They are 2 different things, one <strong>SAVES</strong> [Response], the other <strong>READS</strong> [Request] </p> <p>in a Cookie (informatics speaking) :) you save a small file for a <strong>period of time</strong> that contains an object of the type <strong>string</strong></p> <p>in the .NET framework you <a href="http://msdn.microsoft.com/en-us/library/aa287547(VS.71).aspx" rel="noreferrer">save a cookie</a> doing:</p> <pre><code>HttpCookie myCookie = new HttpCookie("MyTestCookie"); DateTime now = DateTime.Now; // Set the cookie value. myCookie.Value = now.ToString(); // Set the cookie expiration date. myCookie.Expires = now.AddMinutes(1); // Add the cookie. Response.Cookies.Add(myCookie); Response.Write("&lt;p&gt; The cookie has been written."); </code></pre> <p>You wrote a cookie that will be available for one minute... normally we do <em>now.AddMonth(1)</em> so you can save a cookie for one entire month.</p> <p>To <a href="http://msdn.microsoft.com/en-us/library/aa287533(VS.71).aspx" rel="noreferrer">retrieve a cookie</a>, you use the Request (you are Requesting), like:</p> <pre><code>HttpCookie myCookie = new HttpCookie("MyTestCookie"); myCookie = Request.Cookies["MyTestCookie"]; // Read the cookie information and display it. if (myCookie != null) Response.Write("&lt;p&gt;"+ myCookie.Name + "&lt;p&gt;"+ myCookie.Value); else Response.Write("not found"); </code></pre> <p><strong>Remember:</strong></p> <p>To Delete a Cookie, there is no direct code, the trick is to <strong>Save</strong> the same Cookie Name with an Expiration date that already passed, for example, <strong>now.AddMinutes(-1)</strong></p> <p>this will delete the cookie.</p> <p>As you can see, every time that the time of life of the cookie expires, that file is deleted from the system automatically.</p>
    singulars
    1. This table or related slice is empty.
    1. POWhen to use Request.Cookies over Response.Cookies?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USbalexandre
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 I didn't realise you had to re-save the cookie to update the expiry
      singulars
      1. PO
      1. USAndrew
    2. CO+1 clear yet simple explanation
      singulars
      1. PO
      1. USRami Shareef
    3. COThis was mostly helpful, but a bit misleading since in your example when you go to retrieve the cookie you actually overwrite the cookie that was previously saved with the line `HttpCookie myCookie = new HttpCookie("MyTestCookie");` Instead use something like `HttpCookie myCookie = new HttpCookie("MyWrittenCookie");`
      singulars
      1. PO
      1. USOff The Gold
 

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