Databases
StackOverflow2013
Postsdbo
POHow to get data from listview/gridview and populate another listview/gridview?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to get data from listview/gridview and populate another listview/gridview?
    primarykey
    data
    text
    <p>Using the XAML listview/gridview with binding I populate grid using linq query and C# code:</p> <pre><code> AdventureWorkEntities awDatabase = new AdventureWorkEntities(); var products = from p in awDatabase.Products from i in awDatabase.ProductInventories where p.ProductID == i.ProductID &amp;&amp; p.ListPrice &gt; 0 &amp;&amp; p.Name.Contains(search.Text.Trim()) select new { p.ListPrice, p.Name, p.ProductNumber, p.DaysToManufacture, i.Quantity }; IListSource query = (IListSource)products; ProductsList.ItemsSource = query.GetList(); </code></pre> <p>I noticed a double click event for selected items. What is the syntax to be able to double click a row and transfer that row into another grid below it? </p> <p>The jist is that I'd like to be able to add one row from one grid to the other grid by double clicking the selected item from one grid.</p> <p>Edit: XAML Code:</p> <pre><code> &lt;ListView Name="ProductsList" IsSynchronizedWithCurrentItem="True" DataContext="{Binding}" Margin="6,76,6,220" Width="726" MouseDoubleClick="ProductsList_MouseDoubleClick"&gt; &lt;ListView.View&gt; &lt;GridView&gt; &lt;GridView.Columns&gt; &lt;GridViewColumn Width="85" Header="Product Number" DisplayMemberBinding="{Binding Path=ProductNumber}"/&gt; &lt;GridViewColumn Width="225" Header="Name" DisplayMemberBinding="{Binding Path=Name}"/&gt; &lt;GridViewColumn Width="135" Header="Days To Manufacture" DisplayMemberBinding="{Binding Path=DaysToManufacture}"/&gt; &lt;GridViewColumn Width="75" Header="Quantity" DisplayMemberBinding="{Binding Path=Quantity}"/&gt; &lt;GridViewColumn Width="75" Header="List Price" DisplayMemberBinding="{Binding Path=ListPrice}"/&gt; &lt;/GridView.Columns&gt; &lt;/GridView&gt; &lt;/ListView.View&gt; &lt;/ListView&gt; </code></pre> <p>And my Attempt:</p> <pre><code> private void ProductsList_MouseDoubleClick(object sender, MouseButtonEventArgs e) { //code to place the contents of top grid to bottome grid List&lt;IQueryable&gt; selectedContents = new List&lt;IQueryable&gt;(); selectedContents.Add((IQueryable)ProductsList.SelectedValue); IListSource query = (IListSource)selectedContents; OrderContents.ItemsSource= query.GetList(); } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USasunrey
    1. USasunrey
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYou need to provide lot more data here. You're saying listview or grid, and what kind of data you've bound here? is it a table? list? or any custom objects.
      singulars
      1. POHow to get data from listview/gridview and populate another listview/gridview?
      1. USSanjeevakumar Hiremath
    2. COI've displayed the code I'm working on. I need to be able to select a row from one grid and place it into another grid exactly like it.
      singulars
      1. POHow to get data from listview/gridview and populate another listview/gridview?
      1. USasunrey
 

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