Web Forms :: Check From DB And Generate New Number Using Linq

Apr 27, 2016

public string ACtivationKey()
{
string allowedChars = "";
allowedChars = "a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,";
allowedChars += "A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,";
allowedChars += "1,2,3,4,5,6,7,8,9,0";

[Code] ....

I am generating a new order reference id in a class Called GeneratePdf.cs

I use it as  

GeneratePdf gp = new GeneratePdf();
string orderunique = "ORD-" + gp.ACtivationKey();
var uniqness = db.OrdersMasters.Where(x => x.OrderRefNumber == orderunique).Select(x => x.OrderRefNumber).Count();

I want to run a check if the reference number is not present in database. if its present generate new ...

View 1 Replies


Similar Messages:

Web Forms :: How To Generate Sequential Number

Sep 2, 2010

I need to generate sequential number for my new Users. For every user i need to show sequential number for their ID. it should be dynamic one.once they they click register i need to show this sequential number in Label.

View 3 Replies

Web Forms :: How To Generate A Random Reference Number

Apr 13, 2010

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

View 2 Replies

Web Forms :: Generate An OId Number In A Specific Textbox?

May 27, 2010

I'd like to generate an OId number in a specific textbox on a specific page which comes out of date and time, for example if today is may 27th 2010, 9:45 am,it will generate the number 270520100930

date: 27
month: 05
year:2010
time: 0930

View 5 Replies

Web Forms :: How To Generate Random Number Using Vb.net? But It Shouldn't Be Duplicated

Feb 6, 2011

Recently, 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 Replies

Web Forms :: How To Generate A Unique Random Number On A Form Submission

Sep 24, 2010

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 3 Replies

Forms Data Controls :: Generate A Gridview With A Fixed Number?

May 5, 2010

how i can generate a gridview with a fixed number of rows that is entered from a textbox

my gridview has a column with dropdownlists the others contains textboxes?

View 3 Replies

Web Forms :: Generate Random Number In TextBox And Then Save To Database Using C#

May 7, 2015

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 Replies

Web Forms :: Generate A Unique Identifier Or Reference Number Based On A Format?

Jan 22, 2010

I 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.

View 1 Replies

Web Forms :: How To Make Textbox1 Generate Autonumber And Random Number For Textbox 2

Jan 22, 2010

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 Replies

Forms Data Controls :: How To Generate A Serial Number Dynamically In Listview?

Sep 20, 2010

my listview having 3 columns:SI.No,HallticketNo,Name.

I bind data to listview but the "SI.No" column in listview showing Empty data.

So,how to generate serial number in listview ?

View 5 Replies

Web Forms :: Automatically Generate Random Reference Ticker Number On Button Click?

Feb 12, 2014

I 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.

View 1 Replies

Web Forms :: Check And Convert To Number

Apr 27, 2016

It's Convert mixed letter to Number worked.  I use sametimes russian letter с and е program must check if е then convert to 5  if с then convert to 3.

View 1 Replies

How To Generate Reference Number

Mar 15, 2010

I have a system that generates a invoice in the form of a pdf document. I just want to know, what is the correct way to generate a reference number for the invoice. Preferebly I want something in the line of D100001, D100002 etc. The "D" stand for the kids school grade "D", "E","F" etc.

View 4 Replies

C# - How To Generate A Transaction Number

Dec 9, 2010

I was thinking of formatting it like this

TYYYYMMDDNNNNNNNNNNX
(1 character + 19 digits)

Where

T is type
YYYY is year
MM is month
DD is day
N is sequencial number
X is check digit

The problem is, how do I generate the sequencial number? since my primary key is not an auto increment integer value, if it was i would use that, but its not.

EDIT can I have the sequencial number resets itself after 1 day (24hours).

P201012080000000001X <-- first
transaction of 2010/12/08
P2010120810000000002X <--- second
transaction of 2010/12/08
P201012090000000001X <--- First
transaction of 2010/12/09
(X is the check digit)

View 6 Replies

How To Generate A Random Number Of 16 Digit

Mar 7, 2010

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 Replies

How To Generate Random Confirmation Number

Jul 29, 2010

I 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 Replies

How To Generate A Random Number Alphanumeric

Nov 23, 2010

I'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 Replies

JQuery :: How To Generate Unique Number

Oct 18, 2010

How can I generate unique numbers in JQuery? I use the unique numbers for the Shopping Cart ID.

View 6 Replies

C# - Generate A Unique Number Without Database

Dec 10, 2010

How do I generate a unique number in c# without the database? (max 17 digits). EDIT: digits only.

View 2 Replies

How To Generate A Random Number Which Starts Fro 750000

Mar 17, 2010

I need to generate a random number which starts fro 750000 and should increment one by one for generating other number.

ex: 750000

second it shoul dbe 750001

View 2 Replies

Generate Simple Random Number In Webpage?

Jul 8, 2010

I want to generate simple random number in webpage ... like remain one button,when I clicked show a random number.

View 6 Replies

Databases :: Generate Random Number In Oracle?

Apr 6, 2010

I need to generate random number in oracle.i need to get always 3 digit random number(100 to 999)

View 5 Replies

Databases :: How To Generate Auto Sequence Number

Jan 18, 2010

I've scouted around and found partial answers to my question. If I insert a row into an orcle 9i db, what is the syntax in both the insert statement and then the .net code to get the id value so I can use it elsewhere?

View 2 Replies

Generate Reference Number From Database Table?

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.Example:

Column unique reference no (System Generated) - 10
Column with Product Code (User Entry) - APPLE
Column with Product Title (User Entry) - FRUITS
Unique ref No = FRUITS/APPLE/10

I want to concatenate this three fields to the column Unique Ref No.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved