vb novice here.. im trying to create an application that uploads an excel file and then remove all of its duplicate rows. so far i dont know how to start the code that remove the duplicates.. so far this is what i have done with my removeduplicate function..
[Code]....
How to make an code to works in that way, if the word is on box1, remove ALL from box2. Theres 3 box and 1 button like that.
[Code]...
I'm using this code to find all the start up programs.
If e.ColumnIndex = 1 Then
Dim key As String = dgv1.Rows(e.RowIndex).Cells(0).Value.ToString
If dgv1.Rows(e.RowIndex).Cells(1).EditedFormattedValue = True Then
[Code].....
how to upload excel file with duplicate name file but its don't do overwrite the previous name file. So if i upload the file with same name it will saving like windows do.ex. firstly i upload excel file = "fileExcel". then i upload again with same name ="fileExcel". And it should be 2 file on the upload folder, first with name "fileExcel" and "fileExcel(1)". so if i upload again and again with the same name of file it will continuously grow. (1),(2),(3),(4), etc
[code]...
I am trying to create a .Net application to edit a excel file by deleting some columns and keeping the columns which we need and then removing the duplicate values based on the first column which is going to be the Serial no. which should have a check to have 6 digits by default like 2563 should be displayed as 002563.
Code:
Public Function GetAllFileContents(ByVal path As String, ByRef errorMessage As String) As IList(Of String)
Dim contents = New List(Of String)
Try
Dim files = Directory.GetFiles(path, "*.xls")
If (files.Length = 0) Then errorMessage = "Please select the files"
For Each file In files
[Code] .....
I am trying to create something different by not only letting me do it for excel files but for say txt and csv files along with it. Removing all the values which I dont want and removing the duplicates and then if possible putting a check on the first column of data that the serial number number should have minimum of 6 characters and then The output file should have all the details in Uppercase
I am trying to duplicate the Match function in excel for use in Access. Public Function Match(T() As Double, TTM As Double) As Double ReDim T(LBound(T) To UBound(T)) As Double
[Code]...
I can upload excel to sql but when i upload again with old record for update and another record to insert new record [code]...
View 2 RepliesI am plan to write a Karaoke Player application using Vb.net. One main feature of application is remove vocal of singer in a mp3 files and directly play in the application. Can I do it like this? I saw some application can fullfill this requirement, like Karafun or Karaoke Sound Tools. This two software can remove the vocal of singer in mp3 file and play directly not just can save into a wav or mp3 file.
[Code]...
i wanted to make a virus remover..
View 6 Repliesi made a program that will make a system restore point for the user but i think its only 50% done. I want to add a feature that will place all of the system restore points in list box and give a user the choice of removing a restore point.
View 35 RepliesI have this data in txt file and the data keeps changing all the time.
[code]...
I would like to read all lines and compare, if the same name and same address is found, which is in the [......], then i need to count it and show the most frequent buyer!should i read it all and put in array, and compare and put the duplicate data and count into another array?
i have this sql table
Table name: Project
Fields: PrjCode, PrjName
i want to save my Project codes and name to this table, but before i will save the data from my form i want to check if the user input (PrjCode) already exist in the database. and if the prjcode exist it should not allow to save the entry since it will duplicate. (NOTE: ProjctCode is not auto number. the user will input it)
base on this scenario have this code
If PrjCodeTextBox.Text = "" Or PrjNameTextBox.Text = "" Then
MessageBox.Show("Please Complete the information required!", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error)
[Code].....
I'm new to VB and as every beginner i've begun with a browser, i've added a combobox that records the current url of the website and adds it to a "history" combo box, the problem is that when i go on a site once, the site name shows up multiple times in the combobox. I was wondering if there is a code to only add a certain value only once,
Private Sub WebBrowser1_DocumentCompleted(ByVal sender As Object, ByVal e As
System.Windows.Forms.WebBrowserDocumentCompletedEventArgs) Handles WebBrowser1.DocumentCompleted
[code].....
I am creating a program and calling it 'Dcrews Task Machine', And It's a Bot for some useful Info! I have googled this before searching and searched the forums!It's not a bad Bot in actual fact it is a good Bot and helpful/useful! It does tasks on your computer as you choose from a selected list or record as you wish to do! What I am trying to do here.. Wait! I should mention and include info of my Cursor so far..It is a form with a picturebox (Picture of Cursor myMake)The reason being as i want my own cursor as instead of the system cursor is it is my theme and i would like a nice cremy colored cursor to do the job/task!What I have already managed to do is make it move to places!What I wish to know is how do I make it click (I know how to make the system cursor click but not this) When it clicks i want it so it clicks from the themed app Cursor instead of the system cursor!
View 9 RepliesIn my winform, i m using a datagridview.. I m also allowing to enter data through it. User has to select a product and put in price for it. for products column i have used combo box and for rate column i have used text box.I want that once user has selected a product, he is not allowed to select the same product for other rows... I mean duplicate product selection not allowed... how do I prevent it..
View 11 RepliesThe code I have so far is:
--------------------------------------�
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]....
PS: The code I currently has only searches for "Hello" as an exact phrase whereas I need it to search for "Hello" and get the line containing "Hello" (Whether the word "Hello" is a the beginning middle or end of the line) and duplicate it.
I have a text box where I only want to be able to enter each character once, so no AA or 99, only one of each character. This is so I can paste into the field, but where any duplicates would be eliminated. I've tried using this code, but am not sure where I go wrong.
[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]....
I 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 want to know to how to delete duplicate items in menubar?
View 6 RepliesHaving problems with a datatable which consists of multiple datalogger information. Within the datetime field there are as the name suggests listed date and times entry i.e. 12/01/11 22:56:56 ect ect.
Problem is i am graphing this and when ms chart reads the duplicate entries as a series. It doesnt like it and comes up with a slightly odd interpretation. I need to get the duplicate entries out to establish a single time series.
I was proposing to clone the original datatable and run a loop to remove the duplicates. I have been trying to do this for days and have played with a whole load of examples, without success. Can anyone point me in the right direction on this.
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 Repliessee this codes scrapes all href links and check if it contains "/file/" to save it but I get duplicate links saved so If i can change this code to work some how with Innertext("More") I will have no duplicatestried to configure it to work with innertext it just doesn't fit the way I think it should ;/and if anyone can add how can I remove duplicated urls on my txt file that would be really nice I might need it
Dim links As System.Windows.Forms.HtmlElementCollection
Dim b As String
links = WebBrowser1.Document.Links
[code]....
I need to Replace two duplicate word into two different words.Like:
abc is a search engine and also abc a search engine.
to
google is a search engine and also yahoo a search engine.
I tried this.
Quote:
TextBox1.Text = Replace(TextBox1.Text, "abc", "google")
But it replaces all abc to google. But I need to change first abc to google and second abc to yahoo and so on.also tried this one
Quote:
Dim m14 As MatchCollection = Regex.Matches(TextBox1.Text, "abc", RegexOptions.Singleline + RegexOptions.IgnoreCase)
For Each n1 As Match In m14
Dim value As String = n1.Groups(0).Value
'MsgBox(value)
[code]....
i want to make a virus remover/scanner tht deletes files og scans for virus.. Just reply i you know some of codes or if you have a project.
View 15 Repliesi want to make a virus remover/scanner tht deletes files og scans for virus.. Just reply i you know some of codes or if you have a project.VB2008/2010..
View 11 RepliesI am making a Bingo game. I have a button which keeps on calling numbers which are then added to a list box. How do i make it that the numbers called don't repeat (get displayed in the "number called" label). Is there a way to use items already added in the list box to eliminate duplicate numbers.
View 2 RepliesFor some reason my code is executing the INSERT query twice and putting duplicate records in my table. If I put a primary key on one of the fields I get a runtime error and it complains about the fact it can't add the record twice.
The part of the code that INSERTs is near the bottom, bolded and italicized. I put the entire IF statement of code incase my logic is wrong.
This is what's being executed when a user clicks a button
If listOfCompanies.Contains(cbx_Company.Text) Then
'If the list contains the company, UPDATE the record
If LaborChecked Then
[Code].....
Basically what happens is each time it loops through it adds a number to the end of the string, and by the end I should end up with an array full of string in a format like "111 222 333 444 555 666" but I end up getting strings like this "111 111 222 222 333 333". The weird thing is, if I add a message box in every loop it works fine, but obviously I don't want a message box pooping up every time it loops through. What is causing this and how might I fix it
The code is:
For x As Integer = 0 To (NumCards.Value - 1)
NumRep = 0
[code].....
Here is my
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BHgardeners11.mdb;")
cn.Open()
Try
str = "UPDATE Products SET ProductCode = ?, ProductManufacturerCode = ?, ProductsTitle = ?,
[Code] .....
If there is only one item in the database, then this code works. If there is more than one record then the error is produced that it is trying to produce duplicate values. This is down to the Primary key in my database which is the only thing that cannot have duplicate values. However, when I remove the primary key it has the predictable problem that it goes crazy and does weird things.
