Generate A Unique Number From DB Table ID, Time And Selected Product?
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
ADVERTISEMENT
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
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
Nov 2, 2011
In VB if you prompt the user for a number between 1-20, then a word, how do you get a text box to show the word the same number of time as the number selected using loops?... Ex: please select a number: 4 / select a word: cat....the text box should display ::: catcatcatcat ........
I am doing this for a class and my brain has locked up. Prob. just over thinking it though. Thanks in advance for any help!
View 6 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
Mar 16, 2011
I am a beginner in ASP.NET using VB Code. I want to generate a Unique reference no by concortinating three column fields.[code]...
View 1 Replies
Apr 15, 2009
I am having major problems with creating my tables and populating them.The problem for the creating seems to lie when I try to create my table named WeeklyUnitStaffRota. I get the run time error 2147467259(80004005) No unique index found for the referenced field of the primary table. This has only started happening as I have been tinkering with my tables to get them to populate properly.I seem to have a problem when I have two columns with the same info but relating to a different college ie two MSC being run at 2 different colleges.[code]...
View 1 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
Dec 29, 2010
I have created the windows application in VS 2005 in VB.net. I need the following functionality for my exe
1) I want to generate the PRODUCT KEY for my exe.
2) This Exe once gets installed on machine 'A' it should not get installed on Machine B,C or any other machine.And if I uninstalled from machine 'A' it should get insatlled on it again.
View 6 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
Mar 30, 2009
Anyway, i have a list of products in a product table. Primary key 'id', and 'Price' is a float(all variables defined at the top - cut main code out)
objConnect = New OleDbConnection
objConnect.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=|DataDirectory|Ecommerce.accdb;"
[code].....
View 2 Replies
Sep 10, 2011
I am having 3 tables in my DB Challans, Challan_Details & Customers. They are as follows
Table Challans:
Customer_ID (Related with Customer_ID in Customers Table) Challan_ID (Key) Challan_VchNo (Voucher No.) Challan_Date Invoice_ID
Table Challan_Details
[Code]....
View 3 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
Aug 11, 2009
Right now i have a form in the VB where there are 2 combobox in it. user can choose from a range of products that comes together with some description and these are to be stored in a database table.. when i retrieve these data from another form in VB, i'm only able to retrieve the first product and it repeat e same product in my second textbox.
View 6 Replies
Jun 25, 2009
I have 2 datagrids. One to show Product information and another for Product purchase details entry. Both share the same dataset. The dataset (ds) is filled up with columns from 2 table
ProductMstrTbl : ProductID, ProductName..
ProductDetailsTbl: ProductID, PurchaseDate, Amt, BalanceQty..
DataSet(ds) : ProductID, ProductName, PurchaseDate, Amt, BalanceQty.
The problem is that: Showing from dataset or entering new records into the dataset is no problem, but am not able to save the modified dataset into DataBase. SqlCommandBuilder failed to generate the corresponding INSERT, UPDATE command as the dataset has multiple base tables.
View 17 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
Jul 15, 2010
For each loop through a DataSet, I need to store the values of 2 columns (we'll call them ColumnA and ColumnB) so that I can use them to search the same DataSet again later.The DataSet stores the results of a search and places the value of ColumnA into a ListBox as a new item.When the user clicks on this ListBox item, the application will loop through the DataSet again using the value of ColumnA and the value of ColumnB as criteria to identify the correct row in the DataSet to return.This would be a lot simpler if the value for ColumnA was unique every time, but a value will inevitably be repeated on occasion. That's where ColumnB comes in. This column's value is likely to be unique 90% of the time, and, given the nature of the information in the DataSet, if either column duplicates, the other won't.So I've thought of adding the values for ColumnA and ColumnB into a 2 dimensional dynamic array, but I'm doing something wrong apparently.[code]
View 3 Replies
