I have a form and I want each form to have a unique number when it is filled out so it will go into the database. How can I set this up so when the page loads in the label it will say 1 then the second time it loads it will say 2?
View 1 RepliesI want to generate a unique random number everytime a user submits a form. As the form is submited the data of the form should be placed in a database and a unique random number should be generated so that the user can later use this unique random number to reterieve his details from the database that refer to his unique random id. The unique random number should be atleast 9 digits long.
View 3 RepliesI've web page with 1 textbox.
If I open that page I want to display a random number between 0-9 in that text box, how?
I want to generate a unique random number everytime a user submits a form. As the form is submited the data of the form should be placed in a database and a unique random number should be generated so that the user can later use this unique random number to reterieve his details from the database that refer to his unique random id. The unique random number should be atleast 9 digits long.
View 5 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
[code]....
I have an ID field where I need to insert unique ID's
the ID should be like -
S- (YY)(MM)9999. where, (YY) is year, (MM) is month and 9999(is a four digit random number)
for example - S-11030001
how to pull a RANDOM item from the database when using LINQ. There seems to be a couple of differnet ways to handle this. What I need to do though is pull a RANDOM item from the database that the user has not seen before.
The data I am pulling from the database is very small. Is there any way I can just hit the database once for 1000 records and then randomly scroll through those?
Should I put a cookie on the users system recording the IDs of which items they have seen, pull a random record, check to see if it is seen and if so, pull from the database again? That seems like performance issues just waiting to happen.
i use sql server 2005 and Visual Studio 2008.
I am using asp.ne and vb.net for my website.
i have a table with number of rows 50,000.
i want to display the number of rows at my table in a Label when the page is on load.
so can u give me the code or the hint?
my second question is.
my table has around 50,000 items.
and i have a search box, it look like this
str= select * from mytable where item='car'
the item Car is located in my table in row number of 45,000.
i guess when i search from the table where the item is car, then it will search row by rows, then as the number of rows become huge, it will be so late to find the result.
so is there any method how to search from table with good speed of searching?
is it possible to make an online form generate a random reference number unique to that form?
I'm using C# and .net 3.5
Random rand = new Random((int)DateTime.Now.Ticks);
int numIterations = 0;
numIterations = rand.Next(1, 50);
Response.Write(numIterations.ToString());
Response.Write(' ');
numIterations = rand.Next(1, 50);
Response.Write(numIterations.ToString());
Response.Write(' ');
numIterations = rand.Next(1, 100);
Response.Write(numIterations.ToString());
Response.Write(' ');
numIterations = rand.Next(50, 100);
Response.Write(numIterations.ToString());
[Code]....
This is what i have so far. first 2 number gives 1-50, then 1-100, then last two give 50-100
now i need to make the first 2 numbers give even or odd numbers. how can i do this?
i will set a random number for uploading files. how could i do that?
is it possible to set a random name with 20-50 characters?
Not sure if I'm approaching this correctly but this is what I've got and what I'm trying to do
I have a table with 10 Labels in it (Labels Id A1 thru A10)
I'm trying to have each label assigned a random number using 0-9
Need to have each labels number value different from the other
Code Below:
Randomize()
A1.Text = Int(Rnd() * 10)
A2.Text = Int(Rnd() * 10)
A3.Text = Int(Rnd() * 10)
A4.Text = Int(Rnd() * 10)
A5.Text = Int(Rnd() * 10)
A6.Text = Int(Rnd() * 10)
A7.Text = Int(Rnd() * 10)
A8.Text = Int(Rnd() * 10)
A9.Text = Int(Rnd() * 10)
A10.Text = Int(Rnd() * 10)
How to create sql server table with unique random identity between 45365 - 5782155129452 ?
View 5 RepliesRecently, I am working on the website where I am generating random number and storing it in database as the primary key. So, this key would be foreign key for many table, now how would I generate the random number and check if random number does not have duplication? Is there any function to check if number is not duplicate?
View 1 RepliesHow To Display Data In Following Format?
In the Format below abc has multiple occurance which count is displayed in brackets as 2669.
[code]....
generating random numbers in texbox and then submit to database. code should check if the generated number already exist in database before submiting to database.
View 1 RepliesI need to made a table like that:
Table customers
Name :
Number of customer:
So i must have a unique of customer , for every customer. Then if i try to insert a repeat number i will have a label saying that customer numer already exist. So you must choose this one. And the numer will appear. How can i do the code for a unique customer number ?
how to start/formulate codes on this.I want that in every form load, textbox1 will generate autonumber and random number for textbox 2.
View 2 RepliesI have an easy problem for the experts here...been a few years since my last development work. I have an appl that will track complaints. When an administrator logs in, they go to the main admin.page. From there, they can create a new complaint record-here is where i'm stuck and am looking for a better way. When the admin loads the create.aspx page. i need a way go generate a unique number that i can insert into the db. What is the best way to generate the number...i don't care whether it's numerical or combo, just unique and durning postback the number does not change...the number will be given out as a reference back to the complaint... This seems pretty standard but I can't think of a way that will not duplicate numbers and am looking for best practice with low
View 3 RepliesI have a feedback form in my website. After submitting the feedback (using Submit button), form's Reference number should generate and showed to the user (with successful message) in a "Pop up" as below:
i.e, your feedback is submitted successfully. Your refrence number is 'xyz10'
This refrence number should be unique for every user who fills the feedback form.
how can i generate different number,it is generating the same number
Random rand = new Random(100000);
rand.Next();
I want to generate a 16 digit random account number that should be unique in database for every new user of my website. kindly guide me how can i generate a 16 digit unique number.obviouly i understand that i would have to check that number in my database table for uniqueness and if that generated number already exist then i would have to generate it again.
View 11 RepliesI would like to create a confirmation number using both letters and digits just like when you book your flights, the confirmation number looks like '9Z3RG6R'
View 7 RepliesI'm trying to implement a code that will generate a fix lenth alphanumeric code; number from 0...9 and capital letters A...Z. I want the code to be formated as this: XXX-XXX (where X representes a random character between 0...9 and A...Z). It doesn't matter if the letters and/or the numbers repete. But it will be great if the don't. I'm using VB.Net. How can I do this?
View 4 RepliesI need to generate a Unique Reference number that has 7 digits.
It should be formatted in the following way:
1st: B (Ball), G (Gift), C (Cat)
2nd: represents year of booking A(2010), B(2011),C(2012), etc
3rd: represents the month of booking J(Jan),F(Feb),M(Mar),A(Apr),Y(May), U(Jun), L(Jul),G(Aug), S(Sep),O(Oct),N(Nov),D(Dec)
4th: days of booking A(1st) - Z(26th), 1(27th) - 5(31st)
5,6,7th: These are counters for the number issues each day. Each can be A-Z,0-9 giving a total of 46,656 combinations. So 0 is first, then 1, 2, 3, 4, 5, 6, 7, 8, 9, A-Z, then 00 to 0Z, then 10 to 1Z, then 20 to 2Z, etc
Now , the 1st Digit is a Character that I generate based on a condition and that shouldn't be a problem.