Generate A Unique Number From DB Tables
Oct 12, 2010
I once posted a question on generating a policy number by table ID and user selctions from comboboxes. [URL]FYI . I am doing my project in vb, that why i posted it here. I managed to do that when i choose a region and product from two different comboboxes i generate a number but now my problem is that whenever i click on the comboboxes a policy number is generated before i save the record, so if my previous nummber was 72100002 whenever i click on the product combobox i generate a number e.g if i click on it five times by the time i save the number would be 72100007. I am using a stored procedure for this. Is there another way of doing this or i might end up with my first record as 72100001 and my second record 72100006.
[Code]...
View 2 Replies
ADVERTISEMENT
Aug 2, 2009
I have an application that is made for a game that you have to draw cards for. So what I have done is created a random number generator that generates a random number and then using case statements that number is associated with a picture of the card, which is displayed in a picture box. This part works fine. Each time I draw a card it is not reshuffled so I need to store the random number generated and then if that number is generated again ignore it an generate a new number.
Now to complicate matters even further when a certain card is drawn the entire deck is reshuffled and everything starts over again. Here is what I tried... I tried using arrays to store the numbers but I cannot seem to get it to search the array for the number or store the number properly within the array. The array has to be dynamic since the game is expandable and I will be adding more cards to the game in the future.
View 18 Replies
Apr 1, 2007
I am working on a Bingo game and I am stuck. I got the program to generate random number but they are not unique. I dont know how to fix this. I have researched online and nothing this is my last resource. I am using Visual Basics 2005 Express Edition. [code]
View 9 Replies
Dec 21, 2009
How would I go about generating a unique receipt number in the following range:
GA00000-GZ99999? I am not allowed to use the 'I' and 'O' letters so GI00000-GI99999 & GO00000-GO99999 would be excluded. Ideally, I'd like to create this in T-SQL but can also do it in VB.Net. This number will be stored in SQL and I can access it prior to generating the next one. They do not have to be sequential.
View 4 Replies
Jul 19, 2007
Is there a way to auto generate unique number on the form when an application starts up and it should incremente in the dataadapter and database too. How can i set it up?
View 10 Replies
Sep 21, 2010
I'm developing a policy administration system and I need to generate a unique policy in this formart
RP000000/HH
Where R is the Region i select from a Combobox, P is the product the client chooses and the auto generated six digit number and HH is the hour when the record was entered in the system. I want the auto generated number to be the ID in my ClientDetails table in my DB.Here is my code of what I have done so far.They want to be able to tell the region and the product by just looking at the policy number.
Private Function PolicyNumber(ByVal intRegion As Int16, ByVal intProductCover As Int16) As String
PolicyNumber = intRegion.ToString & intProductCover.ToString & "000000" & "/" & Hour(Now).ToString
End Function
[code]....
View 2 Replies
Mar 21, 2011
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].....
View 1 Replies
May 12, 2006
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 Replies
Jul 14, 2009
I am generating license key for our software. I have encrypted the input data and converted it to base64string. Now i want to generate a 12 character key from it. How to I generate a representative and unique key?
View 3 Replies
Nov 24, 2009
I'm creating a program, and as part of it I'm storing a customer ID, which will be automatically generated using some form of combination of the customer's first name and surname? My thought so far has been to declare individual characters as Char and then put them together to automatically generate a customer ID? Problem being
View 7 Replies
Mar 19, 2011
I have a webpage Default.aspx which generate the id for each new user after that the id will be subbmitted to database on button click on Default.aspx...
if onother user is also entering the same time the id will be the same ... till they press button on default.aspx
How to get rid of this issue...so that ... each user will be alloted the unique id ..
View 4 Replies
Sep 20, 2011
I have no idea about this. Actually i have create one form like personnel requisition form.hen user open the form, ref no will appear at the top of the form. ref no is used to search any personnel requisition later.
View 5 Replies
May 12, 2011
This question is virtually the same as this SO post, only I'm looking for a VB.NET (.NET 4) solution. I've spun my wheels long enough trying to come up with a generic solution to solving this "power set" problem.
Dim choices As IEnumerable(Of String) = {"Coffee", "Tea", "Milk", "Cookies"}
Dim choiceSets = choices.CombineAll()
I'm looking for choiceSets to be an IEnumerable(Of IEnumerable(Of T)) so that I can do something like:
For each choiceSet in choiceSets
Console.WriteLine(String.Join(", ", choiceSet))
Next
[code]...
As you can see, this is every non-repeating combination from the source IEnumerable(Of T) (which could have 1 to many items in it - this example only had 4), it operates based on the order of the items in the source IEnumerable(Of T), and each item in the list is >= the previous item in terms of number of items in the inner IEnumerable(Of T).
For what it's worth, this is not homework; though it sure does feel like it. EDIT: Updated the example so it does not look like the result is alphabetically sorted, to stress that the source IEnumerable(Of T)'s existing order is used and added a 4th choice to clarify the sorting requirement within each set.
View 5 Replies
Apr 15, 2011
I am trying to generate Unique and prominently random colors in c# or vb.net. I am using below code now. But this code generating color almost same color, not big change.How can unique kind of colors?
[code]...
View 3 Replies
Apr 9, 2009
how to generate unique ID based on combobox selection?
View 5 Replies
Apr 15, 2010
I'm creating a radio streaming application, which plays a live stream from various radio stations in a small 'gadget' like application.
The user can add his own custom radio stations, by supplying a Name, a StreamUrl and, optionally, an Image that represents a logo or something of that radio station.The logo will be drawn on the main form when that station is selected.
I need to be able to save these custom stations, and I think it makes sense to use an XML file, which could then look something like this
<CustomStations>
<Station>
<Name>Radio 1</Name>
[code]....
Before I added the support for images, this worked fine, how to store the images. I want the user to be able to select any image from his harddrive, but I don't want to force him to keep that image in the same location afterwards. So I can't rely on the path that he selected. Instead, I want to simply load the image from the path he selected, and then save it somewhere else.
I am storing the XML file in the common application data path which I think is a good place for the images too.The problem is, how to determine a name for the images? I will always have just one image per custom radio station, so it makes sense to me to simply have one Images folder that holds all images, with a unique name.I can see two solutions:
1. Generate a random filename for every image
2. Use the Name of the radio station as the image name
For option 1, I suppose I could just create a string of 16 random characters and call that the filename. The problem of course is that there is no guarantee that I will get a unique filename. Yes, the chances of generating the same name twice randomly are very tiny, but it's still possible, and I just don't like that. How can I ensure that my random filename is unique? I suppose I could always drop the whole thing in a While loop that continues when the new filename already exists, but there must be a better way... Is there nothing in the framework that allows me to generate a unique random filename, in a directory of my choice (so not in the Temp directory...)
I like option 2 much better. The Name of a radio station is unique (there can't be two stations with the same name), so I don't have to worry about filenames conflicting. The problem with this approach is that there are no restrictions on the name. There's nothing stopping the user from naming their custom station "Radio~/aij!""_.fe" or something like that, which is obviously not a valid filename... So, I will have to do 'something' to generate a valid filename from the station name. I could simply remove all non-valid path characters from the name, but then I am no longer guaranteed a unique filename... Suppose there's two stations, one called "Radio/1" and one "Radio1", then after removing the invalid "/" character, the names will be the same and so I will generate the same image path for both....
View 8 Replies
Nov 2, 2009
is there a way to generate a random number and then display that number?
like for example i want to say "i got # - # pencils" or something like that
View 6 Replies
May 17, 2010
I want to generate a serial number in this format: INDDMMYY000001, INDDMMYY000002, INDDMMYY000003, ... I can generate INDDMMYY using following code: lblNoSiri.Text = "IN" + Date.Now.ToString("ddMMyy") However, I don't know how to generate the last six digit number. I only can generate number without zero in front of it. How to create the number with fix number of digit?
View 4 Replies
Nov 29, 2009
Anyway, I'm primarily a web developer so I'm only really fluent in PHP and everything else it entails.For my assignments the examination board suggests Visual Basic, so I'm just needing a little help as I'm not too great at it yet. [code] How could I ensure it generates a number 1-13 BUT doesn't ever generate a certain number, e.g. generate a number 1-13 but NOT 7.
View 4 Replies
Jan 26, 2012
I have 2 tables in MySQL database. These table were joined through a query and handled by a dataset. Im displaying these data through setting the dataset as the datasource of my datagridview. But when it comes to Update, Insert and Delete statements, I got an error because the sqlcommandbuilder does not generate statements in multiple tables.I want is, when I press the update button..all the changes made in the datagridview will be updated in the database. Can i make it without creating a datasource in design mode or through smart tag? If I have to manually create an UpdateCommand for adapters..Can I have a code snippet for that?
View 1 Replies
Nov 19, 2010
I'm currently in the process of making some sort of copy protection for my software. I was thinking about get the motherboard serial or some other number from the hardware but I cant figure out how to get it.
I have tried a lot of code I found searching Google but none of it works.
Does anyone have a working code example for Visual Basic 2008 express?
View 5 Replies
May 28, 2009
to generate random unique number at start of my vb.net application. the same number i want to use thru out the application for different purposes
View 3 Replies
Feb 14, 2010
For part of my coursework I need to be able to enter some customer details into a form and then to press a button which give that customer a unique reference number.
View 9 Replies
Mar 17, 2012
I am trying to populate an array with all the unique values in a string, to prevent me ReDim'ing an array every time I find a value that not already contained in the array I am trying to create (consumes alot of time), I am trying to get the unique values first so I only have to ReDim once and after that I can simply iterate through the string and the array I have will be the correct size for the unique values I aquire (I am using this...)
[Code]...
View 2 Replies
Aug 10, 2011
I have a database with 3 or more tables. Each Table have 3 or more columns. In one of tables, named "Persons" i have ID column, Name Column, Date Column etc.I like to select one record (opened with click in new Form Window)for printing and give to the person one or more receipt (bill).Every person take every month one receipt of payment.
But every time i like the number of receipt to be unique. For all persons in my table and all payments.
Every payment need to show somewhere in Form for check if person has pay the months before this month.
The start number format will be 00000000 or 00.000.000 or A000000 and next will be +1.
Ask for further explanation.[URL]...I know how to copy text from text box and paste it to file in specify place and print this file.
View 6 Replies
Oct 6, 2011
The program must generate 6 unique random numbers but when I click display numbers sometimes it gives me 6 unique numbers and sometimes I get duplicate numbers. I will add the code I have so far.
Public Class frmMain
Private Sub btnExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExit.Click
[CODE]...
View 9 Replies
Apr 16, 2010
I've seen threads on this topic posted before but they didn't come up in the search that I did. What's the best way to get a computer id code of some kind that is unique for each computer so I could use that to create a unique software activation code?Does Visual Basic have any staements that can give you this kind of information.
View 18 Replies
Dec 18, 2009
I am going to have a series of numbers, I want to count how many times each unique number exists in the results.For example if I have this string" "1, 2, 3, 5, 3, 7, 1" I want to know the number 1 appears 2 times, the number 2 appears 1 time, the number 3 appears 2 times, the number 5 appears 1 time, and the number 7 appears 1 time.I want to load this up into a datagrid each unique number will be stored in a column named acct the number of times the number appeared in the string will be stored in a column named numref?
View 3 Replies
Aug 10, 2011
I have a database, 3 or more tables and a one of them with 3 or more columns.In this table i have ID column, Name Column, Date Column etc.I like to select one record for printing and give to the person one or more Receipt of payment (bill).But every time i like the number of Receipt to be unique. For all persons in my table and all payment.
View 1 Replies
Aug 12, 2011
On Stack Overflow, I found the question Generate a receipt number in this range.In answers (from Adam Maras) I find this code (very interesting for me):
Private Const FirstReceiptNumber As String = "GA00000"
Public Function GenerateReceiptNumber(ByVal lastNumber As String) As String
If lastNumber.Length <> 7 Then
[code]....
But show me error in GenerateReceiptNumber().ow do I use that code to give me a receipt number in TextBox1 when I open this form?The receipt number must be +1 next time with Form_Load.
View 2 Replies
