.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

auto increment of primary key which is varchar

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :ASP.Net

hi everyone ...

i  was given a form in which empid is varchar  and i m supposed to auto increment it using a  function and calling it ....

i have never done this. plz help me out the way .

View Complete Post

More Related Resource Links

SharePoint Batch Update Auto Increment Field Value


Hello All,

I am making use of SharePoint List Batch Updating methodology in order to update the items in bulk. I build the query dynamically for each and every item using StringBuilder and process the data ultimately using 'ProcessBatchData' Method.

Now, I have a requirement where I have to increment a particular field value in the query while iterating through each item for building the query. How can I auto-increment a field value for each item in the batch query?


Replication and auto Identity Increment

We want to have two SQL server working on the same data at the same time (SQL Server 2008). I've been told that the auto ID's will stop working (the identity option). I'm not sure how true this is or what is the best replication to use for this.   Thanks

Auto Increment User defined Id

Hi can anyone give me an idea how to create an auto generated id like ED01,ED02 etc., so that when i am entering data the id should be automatically incremented

auto increment date

hi all, I have a table CLRYR with two columns STARTYR,  ENDYR I need to insert value into this these columns as below using a stored procedure STARTYR   ENDYR 1/1/2010 1/31/2010 1/1/2011 1/31/2011 1/1/2012 1/31/2012 i should be able to give the start yr and lets say i have to insert 50 yrs from now. So the values in these columns should add up upto 01/01/2060  01/31/2060 so i will have 50 records with the startyr and endyr. Please help me. thank you.

SQL auto increment in two tables

Hi, i have a problem with auto increment. I generated auto ID with auto increment, but after this i need to insert new ID to other table. Is possible to generate same ID to both tables? Is possible to do it without select command?

a simple way to auto-increment INT by 1 ?

Hi,   I have a field of datatype INT declared as follows  [barCodeID] int IDENTITY(1, 1) NOT NULL Each time I insert a new record into the table, barCodeID increments by 2, not by 1. Why so and can I make it increment by 1? I also tried [barCodeID] int IDENTITY(0 , 1) NOT NULL which produces exactly the same result, so what the first digit(seed) actually defines ? Thanks -- as you can see I'm a complete newbie

do not see auto increment after insert


hello all,


i'm a newbee, so maybee a simple question

i have a parent table, with , lets say an id, and another field

i have another table, the child table which uses the id of the parent, for the master-detail relation.

the id is defined as datatype int, allow nulls = no, unique = yes, primary key = yes, identity=true, identityIncrement=1, identitySeed=1

so the id is auto incremented.


i am using ado.net and have a SqlCeDataAdapter, and SqlCeCommand to set InsertCommand

when inserting data and calling the Update() method of the SqlCeDataAdapter, reload the table, i see a nice id.

but, before the table is updated, the Id field is empty, and i would like to see what the id is, because i have also a child table which uses this id.

so, how can i see the id, or how can i add the values to the child, and use a reference (the id or something else) before updating the table ? or is it better to use another technique. I would like to work with the dataset because the data is loaded in memory, and will not save everytime the changes. 

if you know some nice samples, please let me know.

thanks ! andy 


auto increment column in SQL View



Can you please show me what is the syntax to add an increment column to Select Query? There will be additional column which goes 1,2,3 ... n. 

Document ID auto increment


I have a standard document library that I'm adding documents to.  I would expect that the 'ID' property to auto-increment by 1 each time I upload a document, but the column is being incremented by 5.  Is this a setting I can change somewhere to have it increment by 1 instead?  Thanks.

Auto Increment not right after delete and inser


 After i delete a row and then insrt a new row the auto increment row wont assign the correct next number , for example i have


1 last first

2 last first

3 last first

after delete

1 last first

2 last first

after insert

1 last first

2 last first

4 last first


i need some help fixing this, any help would be great thanks

T-SQL how set identity seed on auto increment +1


hi everybody

I have stored procedure where i am creating table and setting primary key how to set auto increment ?

set @sql =@sql + 'CONSTRAINT [PK_'+@Table+'] PRIMARY KEY CLUSTERED ([ID] ASC)) ON [PRIMARY]'

Thanks for any idea

How to Create Auto increment Request number for browser enable infopath form field Programmatically?

hi all,

i have created an infopath which have one request no. field and it will auto increment when click on add new item on sharepoint Document library

field contains (highest value of column request no. +1 )  when infopath will open in browser.

What i have done on this:i have create new data connection on sharepoint library and then pick document library then choose ID field and insert function in the field max(ID)+1.

help me



Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Increment div id in a repeater


How can i increment a div id each time a new item is created in a repeater?

Like :

First div item =

<div id="GoogleMap0" style="width: 500px; height: 300px; text-align: center; border-color: Black;"></div>

Second div item =

<div id="GoogleMap1" style="width: 500px; height: 300px; text-align: center; border-color: Black;"></div>

and on.....

BITS: Write Auto-Updating Apps with .NET and the Background Intelligent Transfer Service API


Both the .NET Framework and Windows have some very interesting APIs for creating applications that are capable of updating themselves automatically over a network. There are many advantages to writing your application to update itself like Windows Update does, including convenience for your users, from easier maintenance to network administration. Automatic updates require attention to factors such as discovery, security, and file replacement. In this article, the author covers the BITS API as well as a number of features of the .NET Framework that take care of these facets of auto-updating using the same facilities that the Windows Update uses.

Jason Clark

MSDN Magazine February 2003

Passing Primary Key to User Control to Display Record Detail


I'm building a user control to display detail information on a parent record. The user control will be displayed via an Ajax Modal Popup. The user control works and is displayed when expected. The problem that I'm having is that I'm not able to pass in the primary key for the parent. The control is displayed via the _ItemCommand event of a Repeater. In the markup for the user control, I explicity set the ContactId to 0 to avoid an error when the control loads (its still underdevelopment, eventually that I'll check if the value is valid).

I was assuming that I could change the property in the _ItemCommand event, but obviously its not working.

In the Page_Load event this code successfully sets the ContactId property of the control. The _ItemCommand event appears to set the value. However when I set a test label on the user control to the Me.ContactId, its showing '0' as if it was never passed in.

        UserControlContactDetail.ContactId = "1462"
        test.Text = UserControlContactDetail.ContactId

    Protected Sub RepeaterDirectory_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.RepeaterCommandEventArgs) Handles RepeaterDirectory.ItemCommand

Protected Sub RepeaterDirectory_ItemCommand(By
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend