I am populating the list view using mysql and i dont know how to avoid duplicate rows.
Private Sub Btnrefresh_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btnrefresh.Click
Using connection As New MySqlConnection(";")
Using command As New MySqlCommand("SELECT Distinct name, type, uploaded, uploader, location FROM programs", connection)
connection.Open()
[Code] .....
on button.click event,Dim category As New ListViewGroup(cbType.Text) If Listview.Groups.Contains(category) Then Arggh! this should work. Listview.Items.Add(lvi).Group = category
Else
Listview.Groups.Add(category)
Listview.Items.Add(lvi).Group = category
End If
If cbType.Text was "Dog", it will add another "dog" group header every time I add an item having selected dog, when I want to add the item to the existing dog group.
I have a datagridview extracted from a csv file. It displays duplicate rows. How can I delete those duplicate rows from the datagridview? replies would be precious.
[Code]...
How can I Avoid Duplicate values In datagrideview. IF found dublicate values in will change the row backcolour and show me the rows.
View 1 RepliesI'm currently using a timer to check for the time of midnight.At midnight each day I have to add a bunch of records into a database.My windows form program will be POSSIBLY running on multiple computers at midnight, meaning I may get duplicate records, because each running program will detect midnight at the same time and add the records accordenly.
View 3 RepliesHow can i avoid the duplicate values in the Access Database?? I am working in VB.NET, to create DataEntry Form. I have Combobox. When enter the value on Combobox and press OK button then the value should check on the database , if the value is not there then it should save on the db. else the Missage will give "It is Saved".
View 6 RepliesHow can I avoid Duplicate values in Datagrideview. When I am putting Product Id in Invoice which is adding in datagrideview if it is exist in datagrideview it will Highlight with deferent color and give me massage that this Id is existent in datagrideview
View 4 RepliesI know that this has been asked alot on the internet and i've searched for it, but can't find any good thread/page about it.What i wanna do is:I have a listview where the user can add items to. But i want the user to able to choose backgroundcolor.The only option i can find is ForeColor, and it does nearly what i want, it colors all text on the row the user add. But as I said I want it to color the background of the row, not the text.
View 3 RepliesIn WinXP with LV FullRowSelect enabled I can press and hold down the left mouse button and drag it down the right side of the left-most LV column and the rows are selected, but under Win7 I can only multiselect items with the mouse if FullRowSelect is set to false.
So I guess I need to write code to support this sort of feature for Win7 ? , and if true are there any code examples (I can't find anything) to save me some time?
I have a program where you have three entries, CD name, artist, price and it goes into a listbox and .txt file when closing. I have to have a message box if you enter the same CD name. I have a code to open the .txt file and compare strings but I need to change it to compare only the CD name and not all three entries. Is there a way to do my string compare against my listbox without opening the .txt file?? The program loads the listbox from the .txt file when opening. Private Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click' adds CD information to the list box
' declare variables
Dim strName As String
Dim strArtist As String
Dim strPrice As String
[code].....
I have a datagridview with rows and 2 columns the first for staffname the second for the price the first column name is "staff" the second is "price" I want code count's how many time the row have been repeated to count the item price
View 8 RepliesMy browser application has an option to display all the "href" elements of a web page in a datagridview.
I use the code below to populate the datagridview.[code]...
I am looping through a file and I am populating a datagridview with values. I have this part done, and it works just fine. My problem comes in when I try to remove duplicate rows from the DataGridView. I would like the code to increment a cell if a duplicate row is found and then remove the duplicate cell. For instance if the program comes across 2 instances of "duplicated value" in the DateGridView, I would like the second instance to be removed and then a value of 1 added to the first instances row, 4th column. I understand most of it, but I just can't get the darn loop(s) working correctly. Iguess my theory is to compare the first row to the last row. if there is a duplicate, then remove the duplicate and add "1".Then I should move onto the next item from the top. This would loop until all items have been checked. I have been messing with this for a while now and I just keeps getting worse.
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim col, row, MaxCount, x, y As Integer
[code]....
Using the following DataTable:
Dim d As New DataTable()
d.Columns.Add("Product", GetType(System.String))
d.Columns.Add("Value", GetType(System.Double))
[code]....
I'm trying to use LINQ to identify if there are more than one of any type of product. In SQL, this would work something like:
SELECT Product FROM SOME_TABLE HAVING COUNT(*) > 1
I can't for the life of me work out how to do this in LINQ. I was following someone who did something like this:
Dim q = From row In d.AsEnumerable()
Group row By New { column1 = row("Product"), column2 = row("Value") }
Into grp
[code]....
But I get an error when I try to actually use 'q'. how I can make this work?
I am reading a textfile and extracting information from each line. For example string1 and string2. I am then writing these string to a datatable.
However, sometimes there will be repeats in string1 and string2.
If there are repeated lines I would like to be able to delete the repeating line and add a counter to find the total number of repeating lines.
so if a string repeates 3 times I would like there to be a column with a 3 displayed next to the line in my datatable.
If I have an unbound DGV with hundreds or thousands of rows what is the easiest way to find any or all duplicate rows? ie. where the data in all the columns is the same in 2 or more rows.
View 4 RepliesI'm going nuts with this. Obviously I cannot open the reader ard writer on the same file simultaneously.
[Code]...
I have two listview in a separate form, basically what i want to do is whenever I select a row in my first listview the items in that selected row will be copied in my second listview which is empty.
View 5 Repliesi don't have any idea how to remove or prevent duplicate item in a listview when ever you update it or insert value to your data base.
View 5 Repliescheck item listview to avoid duplicate item in database. I have 1 listview, my plan the listview checking each item from database before insert to database. and item in listview obtained from opendialog excel this is my code : when items duplicate already exist, my app error/stop at cmd.ExecuteNonQuery() and I'm hopeless to code check each item when reportcode exist in row of 5 or other row
Private Sub BBIUpload_ItemClick(ByVal sender As System.Object, ByVal e As DevExpress.XtraBars.ItemClickEventArgs) Handles BBIUpload.ItemClick
Dim iCount As Integer
[Code].....
I need help on improving the performance of a program I wrote some time back. This is the main performance issue of the program below. Basically I need to look through some data that is displayed to a user in a list view and determine if the data is a duplicate of any other data in the list. If it is I need to delete the duplicate before my program continues.The below code does the job just fine, however the list view of data has approximately 30,000 rows of data. Hence looping this list 30,000 to the power 30,000 times makes the program very slow. Note subItem(4) in the data is the "unique" identifier that I later discovered was not so unique....
This was a work around function implemented in the code back when I wrote it (not meant to be permanent). I know that listView is not Ideal to store this much data.how to store the data in a more efficient manner or improve the performance of the Search and Delete [code].....
I was generously guided by the community to use LINQ to find duplicates on my listboxes the last time around. However, I am now in a tough spot because I need to find and remove duplicates from a multicolumn list view. I tried using LINQ but it says that the listview object is not "queryable". Is there a way for me to find and remove duplicates using only one column of the listview? [code]The code now runs fine when I call it. But it does not remove the duplicates:
View 1 RepliesI have this code to delete the duplicates but i am stuck on how to firstly combine the subitems before deleting the duplicates.
vb.net
Dim DuplicatesList As New List(Of String)
For Each item As ListViewItem In Me.lstTakeoffList.Items
[code].....
I have three sub tables that I want to process. For each I want to combine the rows, as they are only different by contents in the second column(I want to do the same to the fourth column, later):
'Sub table 1
xx|C201 |02300877 |Samsung |....
xx|C201 |02300877 |Toshiba |....
xx|C213 |02300877 |Samsung
[code]....
p.s. For the fourth column, Manufacturer information , I want to do the same and I'd probably get something like this for the final table:
xx| C201,C213,C606,C619 |02300877 | Samsung
xx| C201,C213,C606,C619 |02300877 | Toshiba
xx| C303, C305,C712 |02301163
xx| C207, C209, C708 |02301165
My DataGridView sorts by date. For grins I entered the date 11-02-2010 fully expecting it to be at the bottom of the list, not listed right after the last 11-02-2009 row and before the first 11-03-2009 row.How do I handle this so that come January 1, I won't see all the 01-01-2009 rows listed first followed by the 01-01-2010 rows then the 01-02-2009 rows, etc?
[code]...
I have tried reading the documentation and can't find a good example of how to add rows to a 5-column unboudn listview. I manually added the 5 columns thru the designer. I'm getting an error on the highlighted line of code. See attached screenshot.
Private Sub LoadComponentGrid()
Try
Dim lvItem As New ListViewItem
[code]....
I have this search form and I want to count the rowsThis is the code for the textbox wherein I type te names.
Public Sub showitems2()
Dim com As OleDbCommand
Dim oledbda As OleDbDataAdapter
[code].....
' PayList form
sSql = "SELECT FullName ,InvNomer, date,BalanceDue FROM Invoice"
With LvList
.Columns.Add("Name", 150)
[code]....
After I ADD To my Payment Datagridview Payment Form With InvNomer in DGV.Rows(i).Cells(1).Value
DGV.Columns.Add("FullName", "Name")
DGV.Columns.Add("InvNomer", "InvNomer")
DGV.Columns.Add("Date", "Date")
DGV.Columns.Add("BalanceDue", "Total")
Now hide my Paylist row with InvNomer where InvNomer in Payment.DGV.rows(i).cell(1).value I Have tried
Private Sub cmdPaylist_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdPaylist.Click
If pbNew Then
Dim AllItems As String = ""
[code]....
how to hide Listview rows ?
It is so easy in windows form, but in wpf it seems to be different.[code]...
View 3 Replieshow to highlight specific rows of ListView in vb.net?
View 2 Replies