how to fetch autoincreamented varchar values from sql server

Question

1.00/5 (1 vote)

See more:

I want to fetch autoincreamented varchar values from sql server 2008 into a textbox in asp.net in pageload event.

suppose, i have a coloumn trn_no, data type varchar. if the 1st value inserted manually in the table, like T100,then how would i get the value T101 in the textbox in pageload.please help me.

Posted 20-Jun-12 23:41pm

Saugata84

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-06-20T23:46:00

Solution 1

You can't, and shouldn't try. The reason is simple: SQL is a Multi user system. If you have two users sitting next to each other, they will both be looking at T101 and expecting that to be the ID of the record they enter. Since you don't want two records with the same number, the autoincrement is not applied until the record is written.

Posted 20-Jun-12 23:46pm

OriginalGriff

Comments

Saugata84 21-Jun-12 5:51am

in this case the admin will insert the record .single person

OriginalGriff 21-Jun-12 5:59am

Doesn't matter - you still shouldn't do it. Firstly, you can't assume that the admin job will remain small enough for one person (so it is bad practice to write code as is it will) and secondly because why would they admin need to know in advance of entry anyway - they may not commit the change to the DB, and until they do, it isn't set in stone that it is a used reference.