title: Reading data from xml to datatable
body: <p>My xml</p>
  
  <hr>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt;
  &lt;Category&gt;
    &lt;Youth&gt;
  
    &lt;/Youth&gt;
    &lt;GeneralStores&gt;
  
    &lt;/GeneralStores&gt;
    &lt;Schools&gt;
  
    &lt;/Schools&gt;
    &lt;Colleges&gt;
  
    &lt;/Colleges&gt;
    &lt;GovernmentOffices&gt;
  
    &lt;/GovernmentOffices&gt;
    &lt;Restaurants&gt;
  
    &lt;/Restaurants&gt;
    &lt;MovieTheatres&gt;
  
    &lt;/MovieTheatres&gt;
  
  &lt;/Category&gt;
  </code></pre>
  
  <p>I need data table like</p>
  
  <pre><code>_______________________
  
  Category
  __________
  Youth
  GeneralStores
  Schools
  Colleges
  GovernmentOffices
  Restaurants
  MovieTheatres
  </code></pre>
  
  <p>I am binding this datatable to telrik rad grid on need datasource event</p>
  
  <p>here is my .cs code</p>
  
  <pre><code>protected void CategoriesRadGrid_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
  {
      try
      {
          //create the DataTable that will hold the data
          DataTable CategoryDT = new DataTable("MainCategory");
          CategoryDT.Columns.Add("Category", System.Type.GetType("System.String"));
        CategoryDT.ReadXml(@"C:\Users\MyID\Documents\Visual Studio 2010\Projects\SomeName\InfoXML\XMLCategory.xml");
      }
      catch (Exception ex)
      {
  
      }
  }
  </code></pre>
  
  <ol>
  <li>Code executes good with no data in data table.</li>
  <li>Also tell me How to give file location when file is on servers?
  presently I am using my local machine path where the file is located.</li>
  </ol>