Im adding listviewitems and want to avoid duplication. Now currently, I have resorted to looping through the listview and comparing each items text property against what Im adding. But for a big table this is very slow. The ListView has a .Contains Method but this does not seem to do what I would have assumed; for example [code]Is there a way of doing this so I dont have to loop through all the items?
View 6 Repliesi have a list of record that already populated but my problems is How to find out if there are any duplicates? VB.NET
View 3 RepliesI have 3 list views: (steps)
1...One column listview_AllAddresses, read from several .txt files containing email addresses (creating a list with duplicate entries)
2...One column listview_RemoveFromList, containing email addresses populated by textbox add or drag and drop from listview_AllAddresses (working)
3...One column listview_DuplicatesRemoved, where final list is to be diplayed without duplications entries and (no code yet) items from listview_RemoveFromList removed as well
4...Write to a .txt file containing adjusted list of email addresses
Private Sub Button_ImportSource_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button_ImportSource.Click
Try
OpenFileDialog1.Reset()
OpenFileDialog1.Filter = "txt|*.txt"
[code]....
Results are that I get is an exact list moved from ListView_AllAddresses to ListView_DuplicatesRemoved.
Ok, I found some code online on how to do this, but they only compare the Listview.item.text, and they don't care what is in the entire ListViewItem. Is there any code to remove duplicates in a ListView that checks to see if all the subitems are the same as well and THEN removes the entry? [Code]
View 7 RepliesI have the following code block. I'm tired of typing the same IF statement to check if the string has any lenght before assignning them to the class properties of Employee.
Is there any better to accomplish this?
Dim title = txtTitle.Text.Trim
Dim firstName = txtFirstName.Text.Trim
[code].....
I'm working on a new DAL for my latest project. As the performance is essential I'm avoiding late binding/reflection as much as possible. One central part is the DAL function for populating Business Objects.One class is called in order to connect to the database with the given SQL (stored procedures can't be used in this environment) and the given Business Object or List is populated. As different Business Object types will be populated by the same function I made an Interface that all of the Business Objects implements with the Sub called "Fill". The question is - will reflection be used in this scenario? My thought was as I'm "describing" the objects trought the interface the compiler doesn't need to use Reflection.
[Code]...
I'm writing the following bits of code for a SaveFile Dialog box in Visual Basic 2010.NET. The code works well as the XLSX file is created and opens in Microsoft Excel. However, the problem that I am having is that if the program overwrites a file, the user is getting two prompts. One prompt is from the program's own SaveFile dialog confirming the choice. The other is from Microsoft Excel asking you the same. It's as if the program is running in the background.[code]
View 1 RepliesI want to avoid the creation of SQL queries inside the dataset. Here's the screenshot:
Dim search_by_dateofcanvass = sqlcomm.CommandText = "SELECT [#], Material_Name, Brand, Unit, Discount, Supplier, Category, Date_of_Canvass, City, ListPrice, Material_Description, NetPrice, Area FROM CanvassTable WHERE (Date_of_Canvass = " & DTPcanvass.Text & ")"
Me.CanvasstableTableAdapter.search_by_dateofcanvass(Me.FinalDatabaseDataSet.CanvassTable, datepick)
By the way that query can be use to search for date.
If dr("iname").ToString = DataGridView1.item(0).cells.item(0).valueThen Then
MsgBox("Similar items are not allowed.", MsgBoxStyle.Critical)
Exit Sub
End If
I need to avoid displaying similar data from my mysql database table iname to the gridview, but I can't identify the right syntax/code for that?
I want to insert number for City_Id and City_name , i wrote a query for auto generate number for City_Id,working fine but in the city name i want to avoid inserting duplicate value like if Mumbai is a City ihave already saved then system should not allow that name again. neither in small or in capital or mixed letter.
View 4 RepliesOne feature of C# compiler is that namespace declaration by default follows the folder name structure in the project. By e.g. you have MyProject1MyDrawing and inside you create a class MyPoint the namespace for MyPoint will be MyProject1.MyDrawing
In VB I cant see any namespace declaration(apparently it implicitly 'inherits' the project(MyProject1) namespace). If I create a MyPoint and MyLine clases in the MyDrawing folder I need to surround each of created classes with "Namespace MyProject1.MyDrawing"..."End Namespace".
Is it possible to automatically name the namespaces like in C# by the folder name?
I have an MS Access database and an MS Visual Basic 2008 front end.I get this error when trying to update a record that has related records:The record cannot be deleted or changed because table 'X' includes related records.I only want to update one field in the row in the 'parent' table which is not the primary key field of either record but the 'Update' command seems to want to rewrite the whole datarow. Rewriting the whole row causes the error (as this updates the primary key). If I switch off refrential integrity checking in the underlying database this solves the problem except that I want to maintain referential integrity so its not really a solution. I have tried beginEdit and EndEdit with no success - same error.Is there a way to update just one field in a row and write that back to the database?
View 2 RepliesI need the Logitech HD Webcam C310 to be preselected.When the Main Form opens the Webcam must be running allready, withoute having to select it from the Video Source Window.
View 1 RepliesI've seen a good bit written on avoiding updating a form from a thread.However,I was wondering if that was a problem if the thread exists in an object that programatically builds the form?Thus the form and associated logic exist within the same "thread space." Seems on the face of it like it would work since everything in the form should be in a single dispatch queue.
View 8 RepliesThis particular function is used to save the returned results for a ping sent across the internet. Unfortunately the code won't let me Use the streamwriter method or the fileopen method, because it says:"The process cannot access the file 'C:UsersChrisDocumentsPinging DataFilesave2.txt' because it is being used by another process."
Private Sub SaveToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveToolStripMenuItem.Click
FileOpen(1, "C:UsersChrisDocumentsPinging Datacount.txt", OpenMode.Input, OpenAccess.Read)
[code].....
i get a lots of errors with my application because users doesn't have the .Net Framework installed so i was thinking, can't i take every .net framework resource that my application uses and needs, and add it as a reference in my application so that the user does not need to install .Net Framework?
View 6 RepliesI am creating an application that parses an XML and retrieves some data. Each xml node specifies the data (const), a recordset's column-name to get the data from (var), a subset of possible data values depending on some condition (enum) and others. It may also specify, alongside the data, the format in which the data must be shown to the user.
The thing is that for each node type I need to process the values differently and perform some actinons so, for each node, I need to store the return value in a temp variable in order to later format it... I know I could format it right there and return it but that would mean to repeat myself and I hate doing so. So, the question: How can I store the value to return, in a temp variable, while avoiding boxing/unboxing when the type is unknown and I can't use generics? P.S.: I'm designing the parser, the XML Schema and the view that will fill the recordset so changes to all are plausible.
[Code]...
If a booking is present in database on 12/27/2011 at 5:00 pm for 2 hours and i try to make a new booking on 12/27/2011 between 5 to 7 pm then my code generates an error message. Even if i try to book at 4:00 pm for 2 hours it generates an error message as the 2nd hour will be overlapped here with already made booking from 5:00 to 7:00.
Now here comes the problem part. When day changes it doesn't generate error message i.e. IF a booking is there on 12/27/2011 at 11:00 pm for 3 hours then it should not allow new booking till 12/28/2011 2:00 am but when i try to book 12/28/2011 at 1:00 am it saves it in the database and doesn't generate an error message. I want an error message generated in such a case.
I am using two separate fields in database one for time and one for date. Both of them have DateTime datatype.
newtime refers to time on which i'm trying to make new booking addednewtime refers to time after adding the duration to time on which i'm trying to make new booking
[Code]...
Does the absolute value protect the following code from the Environment.TickCount wrap?
[code...]
I've got a Word Addin in VB.net and VSTO that exposes a COM compatible object via Word.COMAddins.Object, so that the addin functionality can be called External to Word, without accesses to Word itself being cross-process.The technique worked in VB6, but with VB.net, it still works, but it's much slower than the same code running directly from the addin via a task pane, as if the calls are all cross process when they shouldn't be.Anyone who's ever done Word automation knows that code that runs perfectly acceptably INPROC with Word (in this case the instance of the ADDIN that Word itself loads), will generally run unacceptably slowly out of process (or cross process).[code]And slow as in a factor of about 10 to 1; what takes 3 seconds to run when run directly from the ADDIN via the task pane, takes ~30seconds to run when called from external code through the COMADDIN.object object. I'm guessing that I'm running into some sort of issue with .net APPDOMAINS or something and what +really+ constitutes cross proc calls in .net, but I've found nothing so far that would even hint about this sort of thing.My next step, barring some mystical insight, will be to code up a repro, which could get tricky because of the shear number of elements in play.
View 1 RepliesIf the parameter variable is not passed then this code throws an exception of "Conversion from string "" to type 'Date' is not valid."
This is my code.
Public Shared ReadOnly Property Request_projectStartDate() As Date
Get
Dim _value As String = Nothing
[Code] .....
loading of form when I experiment with Debug.Write code?I deleted the form,placed code in a standard module before running the program but am getting an error message.With the form existing I get what I want but I just don't need to wait for the form to load and then to click cancel to close it.Is it not possible to have just a standard module in a VB 2010 Express project? If not can't I place the code in form1.vb but stop it from loading every time I test something?
View 10 RepliesI'm writing the following bits of code for a SaveFile Dialog box in Visual Basic 2010.NET. The code works well as the XLSX file is created and opens in Microsoft Excel. However, the problem that I am having is that if the program overwrites a file, the user is getting two prompts. One prompt is from the program's own SaveFile dialog confirming the choice. The other is from Microsoft Excel asking you the same. It's as if the program is running in the background. Does anyone know how I can write this code to save the file as an Excel file? [Code]
View 1 RepliesI am using Printdialog() to get my report printed (.rdlc)I want to avoid this dialogue and send the report directly to the printer without user interference.
View 1 RepliesI have code in an ASP.NET form that needs to, depending on user entry create messages in the database. We are speaking of potentially thousands of db entries. How do I protect against deadlocks, I mean apart from using Transactions and setting IsolationLevel to Serializable, as well as using WITH(NOLOCK) statement on my select statements since I don't mind a dirty read.
[Code]...
I need to draw a bitmap background with one or more moving bitmaps in the foreground; something like a chessboard where pieces move across it. I use a timer-tick event to redraw the background and then draw the relocated foreground image like the code below. But I get flicker, even though I set the form to use double-buffering. The culprit seems to be redrawing the background to refresh where the foreground images used to be; no flicker if I replace the background DrawImage with a simple Graphics.Clear. I think what I want to do is draw the background, and the foreground bitmap(s), in memory and then render it all. I used to do this with double-buffering, BitBlt, and .Refresh in VB6 but I haven't found the equivalent in VB2010. This must be a pretty common graphics requirement; what's the trick to it?
Dim Gfx As Graphics
Me.SetStyle(ControlStyles.AllPaintingInWmPaint Or ControlStyles.UserPaint Or ControlStyles.OptimizedDoubleBuffer, True)
Dim rectBrd As Rectangle 'use as clipping region for drawing
[Code].....
I am trying to implement a solution for updating form controls without using a delegate.
Imports System.ComponentModel
Imports System.Runtime.CompilerServices
Public Module MyInvoke
[code]....
I get a cross threading error as though i didnt even use this method:Cross-thread operation not valid: Control 'ComboBox1' accessed from a thread other than the thread it was created on.
How can I add my duplicates to a combobox[code]....
View 3 RepliesI have a database running on SQL server primary key is all set, my question is i dont want to allow duplicates in the primary key, i want everything to be uniqure. The database already has information in it, is there a away to set it so when i add a new row through the table adapter that it will recognise the last primary key value and increment it by +1?
View 4 Repliesi has create system registration that use vb.net 2008 & accessdatabase (oledb connection).i set ID
as primary key,when i insert new ID but if ID already in database i will get error cz data
duplicates..so anyone know any code that will promp mesej like this "Data already in data base,
insert ID corectly" if data already in accessdatabase.