I have an add/edit program I've written and I'm trying to find an example of how to test/check an Account Number that a person enters in a textbox to the database(SQL) to make sure it is unique.
View 1 RepliesI have a table with one column auto number key ID. I have an index on another column as unique value. Every time that I try to add a new value into the ddbb that already exist on the index column, I got an alert using on error procedure. This is fine, but since the error is got when the insert command is execute a new ID is created and next time a correct value is added, it means, not duplicated, the ID number jumps. For example.
auto ID=1 new record (OK) unique value
auto ID=2 new record (OK) unique value
auto ID=3 new record (got error) not unique value, no new record added
[Cdoe].....
The question is, there is anyway to check if the value exist before to do the insert() command? or anyway to avoid ID number lost.
The ddbb is open using gridview with sqldatasource.
How to check the inserted test in a textbox is number?
In vb windows phone application.
I am using VB .Net to access the eBay API and store all completed orders in a database. This database is then fed into a proprietary shipping system, which can not handle an order number larger than 20 characters. eBay returns an order number like so 230407279314-680141236013 which is too long. The order number is always 12 numbers a hyphen and 12 more numbers. What I need to do, is turn this (the result can be alpha numerical) into a shorter, unique order key to store in my database alongside the true orderId (so that this can be referenced by the shipping software instead of the actual order number). The reason for the 20 character limit is the barcode algorithm used. Is there any way to achieve this in VB .Net 2010? This number can be anything unique, so long as it does not exist already (even a good uniqueid function would work, but I would have to query the database to make sure it isn't taken)
View 2 RepliesI'm using the datagridview. This is the sample data:
[Code]....
How do I parse through the grid to rename the duplicate values in a particular column (in this example it's the l_name field) into such a format?
[Code]....
How generate the unique no. 1,2,3 and so on .... on button click of each new user ..
the code mentioned below is a readwrite coding in vb.net ...
but the problem is it generate the same id for different users on button click event... but i want the no. of times button clicked the new ids will be generated
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim FILE_NAME As String = Server.MapPath("counts.vbi")
[Code].....
Unique constraint - these columns currently doesn't have unique values..?? I have created Unique Constraint with 3 columns. My code works perfectly but once - two users @ same time entered same data and somehow it saved in DB; after that incident. This UniqueConstraint gives me error - These columns currently doesn't have unique values. How can I check if user enters this kind of entry or how can I restrict the Entry?
View 2 RepliesI don't understand the error, Argument not specified for parameter 'test' of 'Public Shared Function TestThis(test As String)'.
Partial Public Class Form1
Shared Sub ReceiveCallback(ByVal ar As IAsyncResult)
Form1.Invoke(TestThis, New Object(){"test"}) 'error
[code].....
This my working method to send a email
Sub emailConfirm()
Dim email As String = txtMail.Text
Dim name As String = txtPrenom.Text + txtNom.Text[code]....
note:I want to send Link contains a unique identifier and verify the unique identifier in the login.aspx.I don't know when to do this...I found nothing interesting on the net ...
[code]...
and from VB6 project I reference to Test.dll but an error messege was appear A reference to Test.dll file could not be added (If I create VB NET project and reference to file Test.dll it OK )
Probably a dumb question, but can you write a unit test project in one language to test against another project in a different language?I'd like to translate one of our VB assemblies into C#, but want to build unit tests to verify the results. I've tried to set a unit test project up to do this, but I can't seem to access the VB code within a unit test... I can't figure out if I'm just missing/doing something stupid, or it really isn't allowed.
View 2 Replieshow unique is this ? will i ever get duplicates ? and will it ever change ?... i want some way of relating my software to the customer .... is there a system GUID?
Function GetCPUID() As String
Dim sReturn As String = ""
Try
[code]....
I'm making a sign in/out program using mysql and visual basic and need a little help I have two tables event_in and event_out and under each table I have event_id, which automatically generates a number(starting from 1) for each row. I was wondering if it's possible to generate the numbers based on the users. So let's say User A comes and signin, 1 is generated into the event_id. Then User B comes and signs in. I want 1 generated for him too...so all User A's event_id will be 1,2,3... and each user's event_id for both the in and out table will also be the same.
With this I will be able to subtract each user's timestamp in event_out from that of event_in to get how long they were in. I believe that if I don't generate the numbers separately for each user, then let's say User A signs in (1 is generated for event_id in the event_in table) but does not sign out yet and then User B comes and signs in (he get 2 for the in) but then he signs out before User A does and he gets 1 for the out and user A gets 2 for the out. So now user and with my current query I will not be able to calculate the timestamp.
[Code]...
I was wondering if there would be anything else I could use in my Hardware ID protection that would make it much more unique.
I am currently using Processor ID Volume ID MAC Address Graphics Card Name
<data>
<food>
<id>1</id>
<name>asparagus</name>
[Code]....
i would like to get the unique catlogs, so from this list i want to extract only 7190, 7192, and 7193. i have a script that puts it into a dropdownlist by using:
DropDownList1.DataSource = dv
DropDownList1.DataBind()
but i need it to get only the unique values.
I want to generate a unique ID in VB.NET that starts with ASXXXXX where XXXX represents a number. The number has to start in an orderly fashion. This ID will then be stored in a SQL Server express table.
View 8 RepliesI'm a non developer user of VB. I'm using a simple form to input data to a database. have some text boxes bound to data and use a Binding navigator. I want to be able to handle or catch the error when a non unique ID is added. I have tried to include an error handler in several places but the exception is generated anyway. For example I select to add a new record the change the id to a duplicate value and navigate to the previous record and get the error. I want to check or validate the value before it generates the error to avoid the program crashing if someone includes a duplicate id.
View 5 RepliesIs there any way to get a system specific ID in vb.net?
View 2 RepliesIs GUID really unique? I have a webservice that the client application connects to, which generates a GUID. I know GUID are generated using the mac adress of the NIC. Is the NIC in the webservice server used or the client NIC?
View 1 RepliesI have a database (using Sqlite) that has ID has a primary key with autoinc, that loads the values into a listbox control. If I loop through the database normally, adding the values of the database into my listbox, I can't get the ID by using SelectedIndex because the Index will not always be the same as the ID, and the ID will not always be the Index. :( This makes it painful when I want to query to delete the row, based on SelectedIndex.
I want to delete the row by ID, but I have no way of getting that ID with the loop I use Is there some hidden field type attribute I can use?
Primary key must be unique....while inserting data into the database,i need to check whether the data already exist in the primary key column or not.......If not then only data will be inserted in the database else a msgbox will be displayed and data will not get inserted in the database....
View 13 RepliesI'm trying to return a unique ID from the URL with changes every time you login.
The URL look like this: Quote:
[URL]
949285 is the ID
I tried with this regex:
PHP
Dim sPattern As String = "q=(*.?)&p"
Dim src As String
[Code].....
I code on the side for a little extra cash. Up to now it has always been one off conversion programs. The problem is that I am being asked to generate a report program and there is a dealer acting as the go-between for the end user. I want to maintain control of this program. I don't want this dealer to be able to distribute it to all his customers (or worse sell it), but have no idea of the best way to do it. Since I do this on the side, I obviously cannot afford to purchase a third party utility.When I try to search, all I get are links to people asking what to do when an installation fails. Can anyone point me to a tutorial or article on how to do this without resorting to buying a utility?
View 4 Repliesprovide the code to generate a unique system id for a machine which is unchangeable even we format our HDD.
View 1 Repliesregarding a UNIQUE value that needs to change.Within my XML for each record i need a Unique Value to be entered. What i have so far is to use the Date and time to give me a unique value when i click my button. But because i click the button once, all records in the XML have the sme value entered. I need to be able to Add 1 to the Unique value each time to make them different? E.g I click the button now and the unique value is "CDS61510" then for each Unique value after i want to add 1 to it, "CDS61511", "CDS61512" etc
<ROOT>
<RECORD VALUE="CDS61510">
......
</RECORD>
[code]....
I need to identify each computer with different identification, so which should I use? Is it motherboard serial number or MAC address?
View 9 RepliesAll my users can click on an image button accept one.When she hovers over the imagee it does not provide info on the status bar as if it doesn't even recognize there is a image button there.ALL the other users roll over it and the info comes up on the status bar and they can click the button and it works.What should I be looking for that one user can not access this button.There is not code specific that locks her out and the ahref links on her page work but not the image button.
View 4 RepliesI want to add only unique items into the list box.I am using lstListBox.FindStringExact(strKey) it works perfectly. But I have large number of strings and it is taking too much time. It also make the CPU uses 100%.
View 5 RepliesQuestion: When you have a .NET GUID for inserting in a database, it's structure is like this:
60 bits of timestamp,
48 bits of computer identifier,
14 bits of uniquifier, and
6 bits are fixed,
128 bits total Now I have problem with a GUID, because it's a 128 bit number, and some of the DBs I'm using only support 64 bit numbers. Now I don't want to solve the dilemma by using an autoincrement bigint value, since I want to be able to do offline replication.
[Code]...
i've researched and written a generic class (all my objects are the same structure) and i'm was just working on the collection using a hash table but i've just read a comment within (url...) in this forum...that we shouldn't use hashtables at all with vs2008.i actually need and object collection that contains other object collections within them.the application i'm trying to write is relatively simple (but i'm new to vb.net)it keeps track of the time for weight lifting training/workouts.a workout consists of 'say' a bench press, military press, curls, dead lift, etc within the "bench" you have 1,2, or 3 sets (how many times you do "the bench", within a set you have 1,2,3 or 4 lifters, each lifter does reps.then it starts over with military press..i guess i could base it on a treeview type structure (with parent child type relationships) but i usually think in terms of collections it appears that a collectionbase has no key and i'd have to keep track of them on my own...
View 2 Replies