Home / Community & Support / Developer Productivity Tools Forums / Silverlight > GridView > Load on Demand GridView

• armarocha

  Posted on Apr 16, 2009 (permalink)

  Hi,
  
  Im using GridView/FirstLook Sample, and i want load data on demand when i clik expand column, its is possible?
  
  Thanks,
  Armando Rocha
  
  
  

  Reply

• Vlad Vlad

  Posted on Apr 21, 2009 (permalink)

  Hello Armando,
  
  Generally the grid will always load hierarchical data on demand. Please post a bit more info about your scenario.
  
  All the best,
  Vlad
  the Telerik team

  
  Instantly find answers to your questions on the new Telerik Support Portal.
  Check out the tips for optimizing your support resource searches.

  Reply

• armarocha

  Posted on Apr 21, 2009 (permalink)

  Hi Vlad,
  
  This is the scenario:
  
  I have a gridview with a list of users that i get Asynchronously from a database sql server 2008. What i want to do is ONLY when i click "+" column, invoke a service that return a collection of items related also from database, like i found in a sample in treeview load on demand.
  
  The question is: There is any event where i can put the code to add  data related only for the user i choose in "+" column?
  

   

  This is how i bind the grid:
  In page load:

   

   

  void Page_Loaded(object sender, RoutedEventArgs e)

  {

  proxy.GetUsersCompleted += new EventHandler<SLMaps.SLDataService.GetUsersCompletedEventArgs> proxy_GetUsersCompleted);

  proxy.GetUsersAsync();

  }

  void proxy_GetUsersCompleted(object sender, SLDataService.GetUsersCompletedEventArgs e)

  {

  List<Users> users = new List<Users>();

  // Prepare Child Table

  //relation

  TableRelation relation = new TableRelation();

  relation.FieldNames.Add(new FieldDescriptorNamePair("IMEI", "IMEI"));

  //definition

  GridViewTableDefinition definition = new GridViewTableDefinition();

  definition.AutoGenerateFieldDescriptors = false;

  GridViewDataColumn column = new GridViewDataColumn();

  column.DataMemberBinding = new Binding("DataStart");

  column.DataFormatString = "{0:dd-MM-yyyy HH:mm}";

  column.HeaderText = "Start";

  column.IsFilterable = false;

  definition.FieldDescriptors.Add(column);

  column = new GridViewDataColumn();

  column.DataMemberBinding = new Binding("DataStop");

  column.DataFormatString = "{0:HH:mm}";

  column.HeaderText = "Stop";

  column.IsFilterable = false;

  definition.FieldDescriptors.Add(column);

  column = new GridViewDataColumn();

  column.DataMemberBinding = new Binding("Distance");

  column.HeaderText = "Distance";

  column.IsFilterable = false;

  column.Width = new GridLength(4, GridUnitType.Star);

  definition.FieldDescriptors.Add(column);

  definition.Relation = relation;

  RadGridView1.TableDefinition.ChildTableDefinitions.Add(definition);

  relation.FieldNames.Add(new FieldDescriptorNamePair("IMEI", "IMEI"));

  foreach (var user in e.Result)

  {

  if (user.LastLat != 0)

  users.Add(new Users(user.IMEI, user.Name, user.LastDate, new Location(user.LastLat, user.LastLong)));

  else

  users.Add(new Users(user.IMEI, user.Name, string.Empty, new Location(user.LastLat, user.LastLong)));

  }

  RadGridView1.ItemsSource = users.ToList();

  }

   

  
  Best Regards,
  Armando Rocha

  Reply

• Answer Vlad Vlad

  Posted on Apr 22, 2009 (permalink)

  Hello Armando,
  
  I've attached small example to illustrate you how to achieve your goal.
  
  Let me know how it goes.
  
  Sincerely yours,
  Vlad
  the Telerik team

  
  Instantly find answers to your questions on the new Telerik Support Portal.
  Check out the tips for optimizing your support resource searches.

  Attached files

  • silverlightgriddataservicehierarchy.zip

  Reply

• armarocha

  Posted on Apr 22, 2009 (permalink)

  Hello Vlad,
  
  Thanks for your sample, this is exactly what I needed.
  
  Best regards,
  Armando Rocha

  Reply

• armarocha

  Posted on Apr 24, 2009 (permalink)

  Hi Vlad,
  
  I have a problem with the scroll on the Customers grid, I expand severals Customers to see the orders, when i scroll down to finish and after scroll again to begining the Event  OrdersGrid_Loaded fire again, even the orders has expanded.
  
  I cant't figure out why its happen. You can try the sample that you sand me and you will see.
  
  Best regards,
  Armando Rocha
  
  

  Reply

• Vlad Vlad

  Posted on Apr 27, 2009 (permalink)

  Hello Armando,
  
  When you scroll up/down the grid will destroy rows outside of the viewable area and will recreate them when needed.
  
  Best wishes,
  Vlad
  the Telerik team

  
  Instantly find answers to your questions on the new Telerik Support Portal.
  Check out the tips for optimizing your support resource searches.

  Reply

• armarocha

  Posted on Apr 27, 2009 (permalink)

  Hi Vlad,
  
  Is there any way to avoid this happen? It is very important, because i have a grid inside a stackpanel and when i expand rows i can't show the scroll bar in my stackpanel to view all the rows, i prefer use the scroll in stackpanel instead in the grid. How I solve this issue?
  

  It seems that when i use a grid inside a stack panel its not work very good.
  
  Best regards,
  Armando Rocha

  Reply

• Stefan Dobrev Stefan Dobrev

  Posted on Apr 28, 2009 (permalink)

  Hi armarocha,
  
  You should put your StackPanel in a ScrollViewer in order have the content scrollable as expected:
  
  

  <ScrollViewer>

  <StackPanel x:Name="LayoutRoot" Background="White">

  <telerik:RadGridView x:Name="CustomersGrid" AutoGenerateColumns="False">

  <telerik:RadGridView.Columns>

  <telerik:GridViewDataColumn HeaderText="CustomerID" DataMemberBinding="{Binding CustomerID}" />

  <telerik:GridViewDataColumn HeaderText="CompanyName" DataMemberBinding="{Binding CompanyName}" />

  <telerik:GridViewDataColumn HeaderText="ContactName" DataMemberBinding="{Binding ContactName}" />

  <telerik:GridViewDataColumn HeaderText="Country" DataMemberBinding="{Binding Country}" />

  <telerik:GridViewDataColumn HeaderText="City" DataMemberBinding="{Binding City}" />

  </telerik:RadGridView.Columns>

  <telerik:RadGridView.HierarchyChildTemplate>

  <DataTemplate>

  <telerik:RadGridView x:Name="OrdersGrid" DataContext="{x:Null}" ShowGroupPanel="False"

  Loaded="OrdersGrid_Loaded" AutoGenerateColumns="False">

  <telerik:RadGridView.Columns>

  <telerik:GridViewDataColumn HeaderText="OrderID" DataMemberBinding="{Binding OrderID}" />

  <telerik:GridViewDataColumn HeaderText="OrderDate" DataMemberBinding="{Binding OrderDate}" DataFormatString="{}{0:d}" />

  <telerik:GridViewDataColumn HeaderText="Freight" DataMemberBinding="{Binding Freight}" DataFormatString="{}{0:c}" />

  <telerik:GridViewDataColumn HeaderText="ShipAddress" DataMemberBinding="{Binding ShipAddress}" />

  <telerik:GridViewDataColumn HeaderText="ShippedDate" DataMemberBinding="{Binding ShippedDate}" DataFormatString="{}{0:d}" />

  </telerik:RadGridView.Columns>

  </telerik:RadGridView>

  </DataTemplate>

  </telerik:RadGridView.HierarchyChildTemplate>

  </telerik:RadGridView>

  </StackPanel>

  </ScrollViewer>

  
  Hope this helps.
  
  Regards,
  Stefan Dobrev
  the Telerik team

  
  Instantly find answers to your questions on the new Telerik Support Portal.
  Check out the tips for optimizing your support resource searches.

  Reply

• armarocha

  Posted on Apr 30, 2009 (permalink)

  Hi Stefan,
  
  The ScrollViewer not work.
  
  Thanks anyway
  Best regards,
  Armando Rocha

  Reply

• Lawrence

  Posted on Jun 25, 2009 (permalink)

  Is it possible if you could change this sample to use RIA in a SL3 environment, while still maintaining the same SL2 controls?

  Reply

• Vlad Vlad

  Posted on Jun 25, 2009 (permalink)

  Hi Lawrence,
  
  Indeed you can use the same approach with SL3 however you will need our SL3 build.
  
  Kind regards,
  Vlad
  the Telerik team

  
  Instantly find answers to your questions on the new Telerik Support Portal.
  Check out the tips for optimizing your support resource searches.

  Reply

• UB K

  Posted on Dec 22, 2009 (permalink)

  Hi,
  
  Is there a way to achieve the same thing with Visual Studio 2005 (ASP.NET C#) and Oracle 10g?
  

  Reply

• manmohan

  Posted on Nov 22, 2010 (permalink)

  Hello Team,
  I need the same functionality with Up\Down Key. When I press 'Right\Enter' it should expend the selected row.
  Like in following scenario I am able to Hide\Show the row details through mouse click.
  void RadGridView1_RowLoaded(object sender, RowLoadedEventArgs e)
          {
              GridViewRow row = e.Row as GridViewRow;
              row.DetailsVisibility = Visibility.Visible;
          }
  
  But i want the handle the same with keyboard….something like this.Which is not working
   private void RadGridView1_KeyUp(object sender, KeyEventArgs e)
          {
  
  
              if (e.Key == Key.Enter || e.Key == Key.Right)
              {                
                  //(sender as GridViewDataControl).RowDetailsVisibilityMode =GridViewRowDetailsVisibilityMode
  .VisibleWhenSelected;
              } 
  
  OR
                  
                   //Row in not avaialble 
  
  
                   //GridViewRow row = e.Row as GridViewRow;
                   //row.DetailsVisibility = Visibility.Visible; 
  
  
          }
  Thanks in advance for response.
  Regards
  ------------------
  Manmohan
  

  
  

  Reply

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / Silverlight > GridView > Load on Demand GridView