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 RepliesI 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]...
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.
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 RepliesHow 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.
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]....
How can i auto generate number in vb.net
View 4 RepliesI 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 RepliesHow to display the auto generate next number from sql server 2005 to vb.net 2005 textbox. This code below is not displaying any data in the textbox after retrieving the data from the database.
Code:
Imports System.Data.SqlClient
Public Class NewConnection
[code].....
im working with my thesis, to generate auto increment number. for example,when the form load for the first time it will appear transaction 1, and then next time i'll load the form it will be transaction 2, so on and so forth. i am using a VB.net and SQL server.
View 1 RepliesI am trying to generate autonumber the sequence is like this. From left to right, last two digit from Year, Month in numeric and the last three digit number be from 001 to 999. I tried with the below coding but the sequence is not coming correctly.
<code>
Imports System.IO
Imports System.Data.OleDb
[Code].....
How to autogenerate number in a texbox. in Visual Basic .NET 2005 and Using OLEDB I hv created 1 application in which there is one field in the database called "treatment ID"... and now i want to Autogenerate an ID in Incrementing Manner.
View 1 Repliesi want to genrete a auto number in my project....i used vb .net 2008 and SQl server 2005 as backend ??i want to create a serial no that is like abc/2010/01..In this..
the abc is same in all the serial no.the 2010 is used from the running Year.(using date for year)the 01 is a actual serial no that can be auto genrete...But how can i do this ....?? and How can i find max number from my serial no.....??how can i maintain it if i delete it then all after delete serial no will place it's place..(there is no break in serial no on delete)
My code: it is used to generate number in date format my problem is that it doesn't show any output in the textbox nor in the database. The last num in my database is 2012010001.
Dim i As Integer
Dim strSQL As String
Dim strMonth As String
Dim strYear As String
Dim strTheID As String
Dim today As Date
[Code] .....
I would like to generate a tracking number as primary key for my database.
There will be total 12 letters for each tracking id. Example: 2012010001-1
The "2012010001-1" is actually from combination YYYYMMxxxx-v where YYYY is the current year, MM is the current month, xxxx is the auto generate number(increment) and -v is the version where it can be -2 -3 but using the same YYYYMMxxxx.
For both YYYYMM is not a prob as i can get the value from Date.Today.Month/Date.Today.Year. But how am I going to ensure the xxxx is an auto increment but will be reset back to 0000 every new month.
For example:
2012010000-1 (Month January, so start from 0000)
2012010001-1
2012010002-1
[Code].....
how to display Auto Generate number in textbox from sql server 2005 column serial_no when click the menustrip object. Here is the sample code which i tried but it not working.
Public Sub serialnogenerate()
connect()
sqlquery = "select c_slno from newconnection"
[Code].....
I want to auto generate serial number during my form load.
View 7 RepliesHow 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].....
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 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 RepliesI'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 RepliesI 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 ..
I have created a field which automatically in sql server.I want a code in vb.net so that user the text on the get focus, the automber would display the current no on the form.This autonumber is primary key in table1(tran_head) and as foreign key in table2(trans_Detail).I want another so that when the data is saved, it would automatially update the second table with current automber displayed.
View 10 RepliesThis 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.
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]...
how to generate unique ID based on combobox selection?
View 5 RepliesI'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....
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
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 RepliesAnyway, 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