Web Forms :: Creating A Unique Number And Insert Into The Db
Feb 4, 2011
I 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 Replies
Similar Messages:
Jul 5, 2010
I am generating a unique Ref number using this sql statement: SELECT REPLACE(STR(CAST(CAST(NEWID() AS binary(5)) AS bigint),12),0,0) as REF Subsequently, I need to insert this REF into sql database table in stored procedure. Here is what I did in my stored procedure:
USE [iBankRecords]
GO
/****** Object: StoredProcedure [dbo].[stp_addPayee] Script Date: 07/05/2010 21:57:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[stp_addPayee]
(
@CUSTID char(10),
@PAYEEACCNUM nvarchar(20),
@PAYEEACCTYPE char(10) ,
@PAYEENAME char(20),
@PAYERINITIAL char(20),
)
AS
DECLARE
@ReturnValue int
INSERT INTO PAYEE (CUSTID, PAYEEACCNUM,PAYEEACCTYPE,PAYEENAME,PAYERINITIAL, REF)
VALUES (@CUSTID,@PAYEEACCNUM,@PAYEEACCTYPE,@PAYEENAME,@PAYERINITIAL, REF)
IF @@ERROR<>0
BEGIN
PRINT 'ERROR'
SET @ReturnValue=1
RETURN @RETURNVALUE
END
ELSE
BEGIN
SET @ReturnValue=0
RETURN @RETURNVALUE
END
May I know how do I have generating a unique ref num and inserting the REF into the above statement?
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
[code]....
View 1 Replies
Mar 27, 2010
I 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 ?
View 6 Replies
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
May 21, 2012
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 Replies
Mar 15, 2011
I'm currently making a site that is supposed to generate search results from a separate assembly, with a gridview that has links to each robot. The links from the gridview are supposed to link to a unique robot details page, as well as display another gridview to all related robots from the set, like this:
[IMG]http://www.sawauto.com/uploader/up/2011-03-14_132416.jpg[/IMG]
how to display unique detail pages. So far, I only have a details page template, but I'm trying to figure out how I can display the data dynamically, depending on which robot was selected from the main search.
Here are my Default.aspx and Details.aspx mark-ups so far:
Default Pastebin
Details Pastebin
And the resulting Default and Details pages:
[IMG]http://www.sawauto.com/uploader/up/2011-03-14_133933.jpg[/IMG]
[IMG]http://www.sawauto.com/uploader/up/2011-03-14_133107.jpg[/IMG]
View 1 Replies
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
Jan 10, 2011
i have an application where users are allowed to fill in a form, once saved the form is given a unqiue # in this format: YYYY/MM/DD/### where ### is a 3 digit number, starts at 001, next one would be 002, etc.. the the YYYY/MM/DD is the date the form was saved, so if we had 2 saved today we would get these two:
2011/01/10/001
2011/01/10/002
I just wanted to know how to be sure that those numbers are always unqiue, if two people submit a form at the same time to make sure they are not given the same number? As we had that happen recently now that the application is being used a lot more, two people saved about the same time and once someone clicked save twice while the first save was happening and 2 of the same IDs were generated. Just want to make sure no matter what a unqiue one is always generated. I 'm able to calculate the ###, just wanted to know if there is a way to make sure it's not being used by a process saving right now.
View 6 Replies
Aug 23, 2010
i like to have unique ids for textboxes and hidden filds .is there any property which will give unique id in asp.net ?
something like
<asp:textbox id="ctr001_1" runat="server" uniqueid="textbox" />
View 4 Replies
Oct 18, 2010
How can I generate unique numbers in JQuery? I use the unique numbers for the Shopping Cart ID.
View 6 Replies
Dec 10, 2010
How do I generate a unique number in c# without the database? (max 17 digits). EDIT: digits only.
View 2 Replies
Jan 25, 2010
what the best way to create text boxes in my loop here so that the IDs are unique instead of just "TextBox" for all of them. I need to add up the Price based on the Price per unit and the Quantity.
My items are loaded from a database so there could be any number of them, so I need to generate the fields on the fly. I was thinking maybe an array of fields could be used like in a form application, or is this not the right way to go?
Here is my code:
[code]....
View 2 Replies
Dec 11, 2010
i am trying to create a Unique order number so i tried to use the code above but every time i enter the quite the page the number get rest.
If (ViewState("counter") Is Nothing) Then
ViewState("counter") = 1
Else
ViewState("counter") = ViewState("counter") + 1
End If
OrderNum.Text = ViewState("counter")
If (ViewState("counter") Is Nothing) Then
View 4 Replies
Jan 4, 2011
I'm going to write my own Authentication module and I need a unique identifier base on users requests header , I think [(user IP)+(user Agent)] can be reasonable but I know it's not completely safe do you know any other options or methods?
View 3 Replies
Jun 28, 2010
First of all here is my code chunk.
[Code]....
Right now I am creating this session with the session key "PhonePart" which is also the name of object I am passing in as a parameter in first method. In subsequent methods, I use the the same name to retreive and clear session value. My problem is, this approach works fine If I instantiate a single object of the class where these methods are defined and using that object call the methods, but when I create another instance of the same class and calls for instance method AddToSession and pass that instance, it overwrites the session value stored by the first instance of the class as the session key is the same that is "PhonePart".
Considering this scenario, is it possible that I somehow grab the name of the object as string in the calling method say "AddToSession" and create a session with that name? If Yes, then I can do the same in subsequent methods and retreive session value and also clear the session specific to that instance name without affecting the other session values stored by other instances.
View 5 Replies
Nov 28, 2010
i need code to be able to check if (the date in a textbox) is already (used) in the database or not, if yes then give an error message!!
i am using asp.net 3.5 c#
View 3 Replies
Jul 6, 2010
I have developed a Portal (Request submission) which sends an Email and also it updates all values to the Database. What ever values gets updated to the database, will be sent as an email message to an address. It works fine. I need a Unique number to be generated for a Request submission which has to be sent in the Email message and also it has to be updated in the database. I use SQL Server 2005 and Framework 2, C# laungauge.
View 10 Replies
Jan 3, 2010
For example: INSERT INTO table (col1, col2, col3) VALUES ('value1','value2,'value3')But I would only like to insert the row if value3 isnt already present in col3 in some previous row. What is the best way to do that?And the insert command is run 50+ times in a loop (with different values each time for value3)
View 4 Replies
Feb 19, 2011
I have 3 tables in Oracle database. From my asp.net C# page, I am inserting records into all three tables as shown below:
[code].....
My question is, how do I make sure that either all the above are executed or none is executed in C#.
If the first 2nd or 3rd insert fails, everything should fail.
View 3 Replies
Nov 23, 2010
I am using C# 2.0 and ASP.NET.
How to create 4 digit Sequential Number (0001 to 9999).
I have a web page, where students save their information. When the students submit the page, I want to add the string "Stu" followed by the 4 digit sequence number. The sequence number should be unique. The sequence number should increment to the next sequence, when a new record is getting added.
How to achieve this?
View 1 Replies
Aug 25, 2010
Is GUID (globally unique identifier) really unique, or it can be duplicate.
System.Guid.NewGuid().ToString()
View 6 Replies
Sep 13, 2010
I'm pretty new at ASP .NET but not to ASP. I've got a form I need to create where I don't know how many entries will be added. It has the following format:
"Age" "Duration" "Period of Duration" "etc..."
Last30Days
1-5 Months ago
6-11 Months ago
Age
Age
Age
etc.
So the Age column always has the first 3 options and then an unknown number of Age values that can be inserted. I've created a table that has the first four fields (Last30days, 1-5months, 6-11months, age) and I was thinking I could just order by those 4 columns for display. The problem I have is I'm not sure on how to proceed. Does anyone have any good ideas on how to handle this situation? Ideally data entry people could use the same form for both entering and displaying the data.
View 6 Replies
Jan 10, 2011
On page load i am doing this,, the first id inserted to DB will be (GT010001) , now the question is what about the 2nd, 3rd ... etc ?? what should i do?
[Code]....
View 5 Replies
Feb 17, 2010
If I have a checkboxlist where I insert a clients clientid and a number of interests they check off. How do I then update that later when they check off additional interests. The insert tries to insert the original ones as well as the new ones. This is a violation of the Primary key and the statement is terminated.
Is there a way to skip some or do I need to run a delete first and remove the existing interests for that client and then do a new insert? When the page opens the checkboxlist is populated with the previous interests that were inserted for the client. The user can then check additional interests for the client and then click a button to do the insert.
[Code]....
View 3 Replies
