Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>your code does not show where, when or how you try to remove the subitems. Based on the Title, I'm guessing that the LVI is already assigned to the ListView, so doing stuff to TempNode might not do anything (it could be a different LVI by this time.)</p> <p><code>ListViewItem.SubItems.Clear()</code> is the correct syntax but this will also remove the <code>Item.Label</code> So:</p> <pre><code> ' preserve "Label" and put it back: Dim txt As String = LV.SelectedItems(0).Text LV.SelectedItems(0).SubItems.Clear() LV.SelectedItems(0).Text = txt </code></pre> <p>or reference as <code>LV.Items(IndexOfTheItemToClear).Text</code></p> <p>another way:</p> <pre><code> ' loop BACKWARDS to remove all but the last subitem (index = 0) For n As Integer = LV.SelectedItems(0).SubItems.Count - 1 To 1 Step -1 LV.SelectedItems(0).SubItems.RemoveAt(n) Next </code></pre> <p>since you are removing things from the collection you are looping on, you have to loop backwards otherwise your code runs out of items before <code>N</code> is reached.</p> <p>EDIT</p> <p>Your question is not nearly as clear as you might think it is. If you are trying to remove the Item represented by TempNode in the code, you have to find it and remove it. Once TempNode has been added to the LV, you cannot recreate TempNode (<code>TempNode = New ListViewItem(TempStr)</code>) because NEW makes a <strong>new</strong> ListViewItem which is not the same as the one you added earlier. So, you need to find the old one and remove it (not the same as <code>clear[ing] the entire listview</code> or <code>flush all data from tempnode</code>. So:</p> <pre><code>' presumably 'pendrun.Rows(pop)("RID")' is the item text, so find it: Dim search As String = pendrun.Rows(pop)("RID") For n as integer = 0 to LV.Items.Count - 1 if LV.Items(n).Text = search then LV.Items.RemoveAt(n) Exit For End iF Next n </code></pre> <p>It wont clear the LV but will find a specific item and remove it and the associated ListViewItem.SubItems from the LV. Matching on Text is pretty weak, so if you have something more unique like an ID, you can store that as a subitem and search that way:</p> <pre><code> if LV.Items(n).SubItems(WhereYouPutIt).Text = search then... </code></pre> <p>or even stash it in the <code>ListViewItem.Tag</code> property:</p> <pre><code>if LV.Items(n).Tag = search then... </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POReset a listviewitem which is linked to listview
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USPlutonix
    1. USPlutonix
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POReset a listviewitem which is linked to listview
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI am not trying to delete any single item I am trying to clear the entire listview and any file holding data associated with it so my timer can tick again and run the same fetching code and not have the same data Plus the new data show when the timer ticks again, I successfully cleared the listview with listview2.items.clear() which happened right before this for statement was called
      singulars
      1. PO
      1. USJames Stafford
    2. COwell, as in your post, `listview.items.clear()` will clear the entire ListView of all ListViewItems...your code will have to handle clearing data files we have no way of knowing what is going on there.
      singulars
      1. PO
      1. USPlutonix
    3. COas I stated in the question the only question is how to clear the content of Tempnode (the listviewitem) which I have identified to be carrying over information to the next run
      singulars
      1. PO
      1. USJames Stafford
 

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