|
hai,
i m now working in ASP.NET with C# web application(.net 2003, 1.1 framework) and sql server 2000.
i m having a sql table with two fields Roll_number and name.
the roll number is auto generated by MY PROGRAM.
when user fill the name and click OK button, the record is saved in database.
this application is accessed by 1000's of users.
Here the Roll_number is getting Replica.
How to avoid this. i want to LOCK the roll_number which is generated by MY PROGRAM.
if other users try to attempt, it should give the next number.
The main aim of my process is to AVOID DUPLICATION in my database (since roll_number is primary key and
i cant generate auto number in my database). Help me! - KARAN
|
|
|
|
|
Use a stored proc to get the highest roll number then add 1
SELECT max(roll_number) FROM table
only two letters away from being an asset
|
|
|
|
|
Thanks for your reply Mark Nischalke, the same i performed.Even though when more than 1000 users accessing, the MAX value is getting repeated. (while 2 user attempt same time, the MAX value is supplied to them and when they updating REPLICA occuring)..... and also i like to handle this with my coding itself. Kindly help me.............
modified on Friday, March 14, 2008 9:35 AM
|
|
|
|
|
Just curious, why can't you use autonumber?
Assign the number when inserting the record using the same technique
only two letters away from being an asset
|
|
|
|
|
Thanks for your reply. I cant generate AUTO ID since, i just want to show the ID in text box and this auto number is mixed with some characters (eg.. "ROLL100", "ROLL101", "ROLL102" etc...) so i programmatically generate the number starting from 100(and i store this 100 in separate database table(say.."A") and find the MAX and generate the next ROll number) and add the "ROLL" as prefix and display in the user text box. After user finish all other process he save this(so, in a separate database table(say.."B") the id=ROLL100,name=KARAN etc etc will be saved).So the "A" table is only used to generate the ID and the "B" table consist of all informations. This is my full process. And in both the "A" and "B" table, i m getting replication.how to proceed this and avoid replication.? Help me plz.... - KARAN
|
|
|
|
|
I believe you are making it more difficult than it really is. Just because you want to append text to your ID doesn't preclude you from using an autonumber column.
INSERT INTO A
RETURN scope_identity()
Or just eliminate table A, you can append whatever text to the ID after it is retrieved.
only two letters away from being an asset
|
|
|
|
|
Thanks my friend. whats the major problem is here they save the information year wise. (i.e, year 2007 consist of 100 records(from ROLL100 to ROLL200 AND the year 2008 consist of the same 100 records from ROLL100 to ROLL200). so i had my table as.....
<u><b>number year</b></u>
100 2007
101 2007
100 2008
101 2008
and i will populate the year wise storing the exact storing mechanism of Roll number in master table is ("ROLL100/2007").Is there any process in which i want to LOCK this value "ROLL100" or locking the "100" numeric, so that no other should get this value and after the completion of this process, then only the next user should proceed. OR, values should placed in QUEUE status and checked... <i>some ideas like this... i like to do it programmatically plz.. </i>HELp me.. thanks in advance..... KARAN
modified on Friday, March 14, 2008 10:29 AM
|
|
|
|
|
That is the problem with some questions here, not giving all the information at first.
First it was an autonumber problem, then adding text, now we have years and a set range.
Use a singleton object to access the database and assign numbers. Unless there are still more requirements that you have yet devulge.
only two letters away from being an asset
|
|
|
|
|
FontStyle fontStyle;
fontStyle = FontStyle.Bold;
fontStyle = FontStyle.Italic;
How i give both Bold & Italic as a FontStyle
Best Regards,
Trishul Tandel
Software Developer
|
|
|
|
|
Following will work.
FontStyle fs = FontStyle.Bold | FontStyle.Italic;
|
|
|
|
|
Thanks
Best Regards,
Trishul Tandel
Software Developer
|
|
|
|
|
how can i find code for online examination using asp.net.
please send me the code or related topics
|
|
|
|
|
For those new to message boards please try to follow a few simple rules when posting your question.
1. Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
2. Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
3. Keep the subject line brief, but descriptive. eg "File Serialization problem"
4. Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
5. If you are posting source code with your question, place it inside
tags, or click the "Ignore HTML tags in this message" check box.
6. Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
7. Please do not post links to your question in one forum from another, unrelated forum (such as the lounge). It will be deleted.
8. Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
9. If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
10. No advertising or soliciting.
11. We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.
“The woods are lovely, dark and deep. But I have promises to keep, and miles to go before I sleep.”
|
|
|
|
|
Member 4619128 wrote: please send me the code
Ummm, no. That is not how it works around here. Here's how it works: you give it a try, get stumped, then ask for help.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Member 4619128 wrote: please send me the code
How about me sending you an invoice for that? Paypal ok right?
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Hi
I am viewing my cascading dropdown in Firefox but instead of displaying values in the boxes it displays "undefined"
Has any1 had this problem b4?
thnaks 
|
|
|
|
|
Ive got two projects which have the same .asmx file in but in one project it works and in another it doesn't.
Does the project name need to be changed somewhere?
Shout if you want me to post the .asmx file
cheers
|
|
|
|
|
|
|
original question above is not a duplicate dummy
|
|
|
|
|
Ive got two projects which have the same .asmx file in but in one project it works and in another it doesn't.
Does the project name need to be changed somewhere?
Shout if you want me to post the .asmx file
http://www.codeproject.com/script/Forums/View.aspx?fid=12076&msg=2464999[^]
I have got the asmx file in the same location as the file that references it
So I have two projects with two asmx files in them, when I run the file its (.asmx) the xml works and displays the right data but when I run it in the cascading dropdownlist it doesnt display anything
http://www.codeproject.com/script/Forums/View.aspx?fid=12076&msg=2464817[^]
I ahve a .asmx file which contains the code for my cascading dropdown
I have copied it from one project to another
Do I need to add any code anywhere else e..g webconfig to enable this file
They are look quite similar to me.
I think we can be civil and drop the "dummy" if you want to continue here.
only two letters away from being an asset
|
|
|
|
|
Hi
I am viewing my cascading dropdown in Firefox but instead of displaying values in the boxes it displays "undefined"
Has any1 had this problem b4?
thats the orignal post
|
|
|
|
|
Hi,
I am trying to get the membership values from the config file. I have the following code, but it is not displaying anything, the value printed to the screen is blank. What am I doing wrong:
Configuration config = WebConfigurationManager.OpenWebConfiguration("/");
MembershipSection configSection = (MembershipSection)config.GetSection("system.web/membership");
NameValueCollection pc = (NameValueCollection)configSection.Providers[0].Parameters;
string strApplicationName = pc["ApplicationName"];
Response.Write("ApplicationName = " + strApplicationName);
Please can someone help?
I am trying to get values from the membership section, but I have been struggling. If someone can help with another way please let me know.
Brendan
|
|
|
|
|
Providing you have set up your Membership provider properly, this information can be obtained by referencing the static ApplicationName property on the System.Web.Security.Membership class.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Not going to work, that's not the only the property that I want returned. There are other customer properties that were entered. I need to get these custom properties. This is why I did it this way.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
