Check Internal And External Duplicates?
Aug 24, 2009
Recently, I have a requirement to develop a vb.net application wherein the input excel sheet data which has an average of 5000 records should be checked for Internal duplicates (duplicates within the same sheet) and external duplicates (duplicates which exist outside this sheet). I have gone through lot of logics..some of which are ...
- Common and currently testing out..
- First insert the excel sheet data into DB..then query by following
select distinct id,mobilenumber from scrubmaster where calltablename=<calltablename given by the uploader>
Then loop for duplicates...
[code]....
The above logic works but it takes very long time..I have tried other logics from web but they "Query timeout"...
View 1 Replies
ADVERTISEMENT
Jun 13, 2009
I'm using GetDriveType function to determine the drive type.the function works fine, but not with external HDD it returns 3 or "fixed" which confuses me!! is there any way to distinguish between internal (local) fixed HDD and external (USB) HDD?
View 1 Replies
Jun 22, 2011
Scenario: We have a website that is viewed both internally and externally. When an error occurs the users are displayed with a detailed error page(Stack trace etc). Problem: The external customers do not need that much information about the error. We are looking to have the external customers see a message instead. Ex. Please contact Administrator. Also if possible we would like to log this message in our SQL database.
Note: I'm assuming I make a custom error page like - Implementing a Custom Error page on an ASP.Net website. but how do I determine whether or not the user is internal/external? Also is this the best way to approach the problem?
View 5 Replies
Nov 30, 2009
Is there a simple way in vb.net to mask a public property or method from the internal namespace? It would be helpful as a refactoring tool to isolate internal dependencies and perhaps to enforce a non-recursion policy for external services.
View 2 Replies
Oct 15, 2011
i 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 Replies
May 9, 2010
How do I not return duplicate random numbers with Do Until loop?
Dim numbers(5) As Integer
Dim subscript As Integer
Dim searchSubscript As Integer
Dim randomNum As Integer
Dim randomGenerator As New Random
Dim isFound As Boolean
[Code]...
View 2 Replies
Nov 6, 2010
I'm Using Griaule Grfinger X 4.2 SDK for a project. I am able to enroll templates into database, also identify and verify fingerprints against registered ones in the database.But I have a further challenging issue. I want to be able to run through the database to check for duplicates so as to identify them in which I would put duplicates in a hotlisted database.
View 1 Replies
May 23, 2010
Ok, my script which is a follow on from a previous thread on writing to a text file needs another thing added to make this one form hopefully complete. (in fact its two things).Firstly, when the 'Save' button is pressed, I want it to check to see if the textbox1 text is already used (textbox1 is the plu field, but still titled as textbox1). So if the save button is pressed, I want it to check first if that number has already been used, and if so, display an error message and don't save, and don't clear the fields so that way the user can enter a different number in for that item.
Secondly, several fields are numeric only. I've tried a couple of examples and are either too complex or just don't want to work for me. How do I ensure that some fields are numeric only (well one is a percentage, two fields are numeric and 1 is a currency field).
[Code]...
View 12 Replies
Oct 11, 2011
I have a list of objects, each with 2 relevant properties: "ID" and "Name". Lets call the list "lstOutcomes".I need to check the list for duplicates (meaning object1.ID = object2.ID, etc.) and set a flag (valid = false, or something) if there is at least one duplicate. Also, it would be nice to send a message to the user mentioning the "Name" of the object, when it fails.I am sure I will need to use the Group By operator to do this, but I am not used to doing that in LINQ, and the examples out there are just not helping me. This article seems to be close to what i need, but not quite and it's in C#.
Here is a starting stab at it...
Dim duplist = _
(From o As objectType In lstOutcomes _
[code]......
help?
View 4 Replies
May 3, 2009
Is it possible to have an internal XML dataset within a VB 08 program I ask because we at present have the program load an external XML on startup, but i would prefer this to be internal withing the program to stop other editing the XML file.
View 6 Replies
Feb 3, 2012
I wanted to know if it is possible to Zip a folder without any external dll nor any external references - just with native features.I've been able to Zip files with System.IO.Packaging, but it does not include folders and I cannot tell it to Zip the parent folder.I know there are external dll and so, but I'd like to know if it's possible to make it from a native way.
View 1 Replies
Oct 11, 2011
I am starting a application that will need to use a usb or included device camera to capture images. I would like to know if there are any samples or examples on how to connect to the camera and capture images. This will be using vb or c# dotnet 4.0 on vista.
View 4 Replies
Jul 21, 2011
My issue involves relationships and cascaded effects between properties, and I'm wondering what best practices are on this.I have a class that contains a list of varying length of numbers. When editing the list, sometimes the user prefer to set a TargetSum, so that the program enforces the list will always add to this sum. I am accomplishing this by programmatically setting the final element in the list such that list sum = TargetSum. For example, if the user chooses to UseTargetSum, then sets TargetSum = 10, then creates a list of length 4, and enters 1, 4, 2 for the first 3 elements, then the final element is programmatically fixed to 3. The user cannot change the final element themselves.
I do this behind the scenes by handling all necessary events, such as a list element value change, list length change, and the UseTargetSum option change. For each event trigger, it recalculates the last element's value.It works but then there was a bug when loading saved data. If a list is loaded by sequentially adding the elements, the handlers modify each entry. Regarding the example, when the first value of 1 is entered, the handlers say "a value was just added, the sum should be 10, there is currently only one element, so it needs to be 10". So the first element gets changed to 10 behind the scenes. When the second element is next added, the handlers say "a value of 4 was just added, but the first element is already 10, so it should be zero." At the end of the load, the final list reads 10,0,0,0 instead of 1,4,2,3.
I know it is possible to rearrange the load procedure such that I get the correct list. For instance, I could avoid enabling the TargetSum event handlers until after all the data is loaded. The list would first be created as 1,4,2,3 and then the handlers would change nothing.
But this experience makes me wonder if I am opening the door for other sneaky side effects. It seems you should be able to load data without worrying too much about an implicit ordering. It also seems unusual to have "cascading" effects between class properties. Is there a more accepted approach?
The other alternative I'm considering is to only enforce TargetSum only inside UI forms. Ie, when you know it's a user making the change, then enforce the TargetSum, but otherwise leave the core class logic alone.That way database loads, etc, are left unaffected. But I guess the downside of not having ubiquitous enforcement is that opens the door of incorrect sums via some unforeseen complication.
View 1 Replies
Apr 7, 2012
I'm using Visual Basic .Net 2010 Express.I know, for example, that the Visual Basic ( IEEE 754 ) Internal bit-by-bit Double Format is: Bit 63 = Sign, Bits 62-52 = 11-bit Exponent, and Bits 51-0 = 52-bit Fractional Significand.But, I can't seem to find any documentation on the Internal bit-by-bit Decimal Format.There also don't seem to be any workable mechanisms for accessing the bit structure or copying the bits to another Format for internal processing and returning the result to the Decimal Format.[code]to separate the ULongVariable into bytes for convenient manipulation. A similar reverse process allows moving the manipulated bits back into the Signed Long Variable.But, methods like << and >> are not extendable to Decimals per the Microsoft Documentation ( and I tried them anyway, and confirmed that they don't work ). Nor does there appear to be any way to copy the 128-bit Decimal into two 64-bit Unsigned Long Variables, or vice-versa.
I could, of course, forgo the use of Decimals and define my own MDJDecimal consisting of two ULongs, but that seems a bit of an overkill, and its methods would likely incur significant development time, and would probably also be rather excessively slow and cumbersome.I know I could write a workable routine in Visual C++ .Net using the Unmanaged Native Assembler, but I don't know enough about how to integrate that with Visual Basic .Net code, and I don't want to irrevocably tie what I'm developing to the Intel platform.I might also be able to write it in Managed Visual C++ .Net, but, again, I don't know enough about how to integrate that with Visual Basic .Net.
View 2 Replies
Jul 26, 2010
I have some forms that were VS2005 forms the I moved to VS2010. The forms have a tab control and on the tabcontrol are some panel containers. If I add a multi-line textbox toa panel I'm seeing the text offset from the left margin. If I make a form from scratch the margin does not appear.Any idea where this left margin is coming from?Is there a way to set the left internal margin in code?
View 9 Replies
Mar 9, 2012
I have several VB6 exe's/dll's that I have created, when I right click on the file and get the properties it says:
File version - 4.2.0.9
Product Version - 4.02.0009
Is it possible to change the File Version? I want this to say 4.2.9.123
I want to change this programmatically, so where is the file would I find these values? Are they at a specific location?
Is this going to cause an issue registering the exe/dll's with COM if I change the internal version?
View 2 Replies
Jun 20, 2012
I'm trying to connect to a remote server (from our customer) via HttpWebRequest.GetResponse but at the login page i'm always getting an exception: "The remote server returned an error: (500) Internal Server Error." In the response stream i see that i was redirected to the error-page. The code worked so far(HTTP status 200) with the old ASP-website but they'll migrate to ASP.NET soon. There's no error if i browse to the URL manually. This is the (reduced) code:
[Code]...
View 1 Replies
Nov 10, 2009
In my project, a reference xxx.dll is added. I am going to step into the code inside xxx.dll, therefore I add the project into the existing solution.So far so good for the vb.net xxx.dll file.Suppose another COM Interop.yyy.dll will be added, is there anyway to step into the yyy.dlll internal code?
View 1 Replies
Jun 3, 2011
Its been a very long time since I don't show up here.Now I am back with a small project for internal use, but I need a little help.I want to make a program that allows me to change file attributes, like 'hidden', 'read-only' and 'system'.It seems pretty simple, but I want that multiple files can be modified at once. For this I would need a list that shows the files into the interface. There is what I can't get.
I first thought on a listbox, but there is also a listview which seems much more complete, but I just don't know how to use it. I was wondering if I could make something like: I open a folder, all the items inside that folder would be listed inside the listview.I learned a bit, but not enough. I've set the listview to 'details' mode, so I can actually list items. Also, I've added three collums: one for file name, other for file size and another for file attributes. I just need to learn now how they works.
View 3 Replies
Feb 21, 2012
I know this is old hat, but when you're faced with a problem you cannot solve yourself, you need to find someone with the correct answer.In short, go to the wise.
I am working on an application that has a lot of records, and it uses a listbox control bound to a binding source attached to a table in a data source.A new record with data is added to the binding source's attached table, and, of course, to the underlying sqlServer database table:
[Code]...
View 5 Replies
Apr 29, 2011
I have a data set in the User control . It was working fine but now when I started using another copy of the user control it started showing error DataTable internal index is corrupted: '5'.
dim dv as dataview
dv = new dataview(ds.tables("Names")
dv.rowFilter ="CatNum ='"& val&"'" 'This will always give one row only
dv.item(0)("Names") = myvalue ' here the exception is occurring
View 2 Replies
Apr 15, 2011
I want to be able to display information from my internal database into a list box. I want this to show in listbox when the button has been clicked.So once i have clicked the button it will display all the information that is stored in an internal database, i also need to loop it so it shows more than 1 information. I have to show 10 different houses in the information
View 14 Replies
Jul 19, 2011
VB.NET doesn't have out parameters, but you can specify <Out()> ByRef on COM and P/Invoke methods to get the same effect for external methods.
Does specifying the same on internal methods (i.e. methods only called by .NET code) actually help the Jitter (or VB.NET compiler)? Or is it currently only useful as a programmer note.
Is it possible it could be used in a future Jitter, or is this attribute lost when compiling?
View 1 Replies
Jun 9, 2010
If I have a module in a VB.Net class library, will it's visibility be limited to the assembly? What I'm looking for is the VB.Net equivalent of a C# internal static class.
View 1 Replies
Dec 3, 2009
I get the follow error in VS 2010 Beta 2 VB[code]...
View 3 Replies
Feb 8, 2011
I have a web app with a separate DLL for Data access.[code]...
I use Telerik controls to display data and initially went to them for help, but they can find anything wrong in the way I've coded the controls.
View 3 Replies
Jun 24, 2010
Im using httpWebRequest to get a response from a website.Ive created / creating a dvd manager for my dvds on disk. My method works fine if i double click a movie name. It will download the data into the correct directories. Im implementing a "process all titles" feature and im finding that around 15 titles im getting "internal Server error 500" or the program bombs out Could this error becoming from the poor internet speed (3G dongle) and the website rejecting my query because of slow downloading?Moved into a new house and ive no broadband in yet?
View 2 Replies
Apr 15, 2011
i want to retrieve lexmar printers internal information .how can i do that....
View 1 Replies
Apr 28, 2012
I have this code to show a user their internal IP address. How can I get their external one?
vb.net Dim h As System.Net.IPHostEntry = System.Net.Dns.GetHostEntry(System.Net.Dns.GetHostName)
MsgBox(h.AddressList.GetValue(0).ToString)
View 1 Replies
Feb 18, 2011
I made a program yesterday. I have a webBrowser in my program. The webBrowser uses Internet explorer as its default browser. I would like to use firefox as the internal default browser. How do I do this without having to launch a separate program?
View 1 Replies
