Databases
StackOverflow2013
Postsdbo
POUsing more than one table with linq datasource on custom control
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing more than one table with linq datasource on custom control
    text
    copied!<p>I'm probably opening myself up to a world of trouble with this one but here goes. As part of a project I have to have a method of representing a timetable for university students, showing lectures, times, rooms etc. I'm not a coding pro so I have found (and ok'd with uni) an opensource control by the name of DayPilot lite <code>www.daypilot.org</code>. I have that installed now and am beginning the arduous task of figuring out what to do with it. I know I need to bind it to a datasource. My problem is that to give all the information I have mentioned, I need to pull data from 3 tables. When I go to set up a LinqDataSource on the aspx page I can only pick tables from one. I have been searching for ages trying to locate some info. This is the best I have came across: <code>http://weblogs.asp.net/scottgu/archive/2007/09/07/linq-to-sql-part-9-using-a-custom-linq-expression-with-the-lt-asp-linqdatasource-gt-control.aspx</code>.</p> <p>However it does not make sense to me. I can't see where he actually connects more than one table to the datasource on the aspx page, in asp code. Am I missing something glaringly obvious here. Is it perhaps a case that I connect it to one table through the linq DS and then write queries to pull the rest of the data I need. In that case how would the data be shown in the calendar if I only connect to one table. Here is the asp code for the calendar anyway.</p> <pre><code> `&lt;asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="OrionDataClassesDataContext" EntityTypeName="" Select="new (Module, Building_code, Event_type)" TableName="Events"&gt; &lt;/asp:LinqDataSource&gt; &lt;DayPilot:DayPilotCalendar ID="DayPilotCalendar1" runat="server" /&gt;` </code></pre> <p>Obviously that is very preliminary. Plenty of work to do. If someone could give some (simple) advice it would be great. Thanks....and before anyone says it, I know I need to get rid of the default names haha.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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