Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There are no controllers and actions in WebMatrix WebPages. You need to write a separate <code>.cshtml</code> page that will query the database and serve the JSON to the response:</p> <pre><code>@{ var db = Database.Open("events"); var result = db.Query("SELECT * FROM events"); var data = result.Select(x =&gt; new { id = x.id, title = x.title, start = x.start.ToString("s"), end = x.end.ToString("s"), allDay = false }).ToArray(); Json.Write(data, Response.Output); Response.ContentType = "application/json"; } </code></pre> <p>and then in another page in which you want to display the calendar you could configure it:</p> <pre><code>$(document).ready(function() { $('#calendar').fullCalendar({ theme: true, header: { left: '', center: '', right: '' }, defaultView: 'agendaDay', editable: false, events: '/events.cshtml' }); }); </code></pre> <hr> <p>UPDATE: Here's an example of how you could use parametrized queries:</p> <pre><code>@{ var origin = new DateTime(1970, 1, 1, 0, 0, 0, 0); var fromDate = origin.AddSeconds(int.Parse(Request["start"])); var toDate = origin.AddSeconds(int.Parse(Request["end"])); var db = Database.Open("events"); var sql = "SELECT * FROM events WHERE start &gt;= @0 AND end &lt;= @1"; var result = db.Query(sql, fromDate, toDate); var data = result.Select(x =&gt; new { id = x.id, title = x.title, start = x.start.ToString("s"), end = x.end.ToString("s"), allDay = false }).ToArray(); Json.Write(data, Response.Output); Response.ContentType = "application/json"; } </code></pre> <p>Now you could query the page like this: <code>/events.cshtml?start=5&amp;end=10</code></p>
    singulars
    1. This table or related slice is empty.
    1. POCreating a JSON result from SQL server database
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDarin Dimitrov
    1. USDarin Dimitrov
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCreating a JSON result from SQL server database
      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. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank you for your response. I have tried to integrate your code into mine, but it does not appear to be working, unfortunately - there are no events being produced for the calendar. I have two theories - the first is that the start/end times are stored differently and need to be changed, and the second is that in the first .cshtml file, containing the connection to the database, it doesn't seem to be returning anything? Do you have any ideas, as I have been slaving on this since your response to no avail! Thank you very much for the response :)
      singulars
      1. PO
      1. USSimon Kiely
    2. COAlso, in my code above, the start and end time of the current view are provided as parameters, but in your C# function, this data appears not to be used at all?
      singulars
      1. PO
      1. USSimon Kiely
    3. CO@SimonKiely, in your updated answer you seem to be using something that doesn't look much like C# syntax. You concatenate the SQL string with dots. Also you seem to be calling the `ConvertFromUnixTimestamp` function with undefined variables: `start` and `end`. If you wanted to read this from the request you would have used `Request["start"]` and `Request["end"]`. I would recommend you though to first get this working without additional filtering parameters. Also you wrapped the code in a HTML file and haven't returned the JSON data. Also look with FireBug if the script sends correct JSON.
      singulars
      1. PO
      1. USDarin Dimitrov
 

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