title: How to use Linq To Sql query to show the data in my case?
body: <p>i have a trouble to write a query with Linq i explain better my case, i have a database with 2 tables as follow :</p>
  
  <p>it is the first table ;</p>
  
  <ul>
  <li><p><strong>Hotel</strong>    </p></li>
  <li><p>HotelID (Nvarchar(10)  - PK)</p></li>
  <li>HotelName (Nvarchar (200))</li>
  </ul>
  
  <p>and this one is the second table ;</p>
  
  <ul>
  <li><p><strong>Period</strong></p></li>
  <li><p>PeriodID (Int (inc) - PK)</p></li>
  <li>_From (Datetime )</li>
  <li>_To (Datetime)</li>
  <li>HotelID(Nvarchar(10)  - FK)</li>
  </ul>
  
  <p>then in the second Table (Period) there is the FK (HotelID) to connect the 2 tables;
  Happen sometime i have a HotelName that gets more periods(PeriodID) so my purpose is to show the data in an only one Row into a DataGrid, i show  you an example as i want show the data in my DataGrid  if there are more periods in the same HotelName:</p>
  
  <p>| HotelName   |  From  |  To   |  From(2) | To(2)  | From(3) | To(3)  | From(4)|  To(4) |</p>
  
  <hr>
  
  <p>| Excelsior   |12/5/10 |3/6/10 |  2/8/10  | 9/9/10 | 23/9/10 | 1/10/10| 2/11/11| 1/12/10|</p>
  
  <p>so i ask do you have any idea/suggest about how to show the data in a DataGrid inside one Row using Linq To Sql ?</p>
  
  <p>thanks so much for your attention .</p>
  
  <p>Have a good time .</p>
  
  <p>Cheers</p>