How to Generate Automatic id

Question

Hi, I want to generate 'ID' automatically and then store it in table please help me..

Amruta Kirdat · Answer

hii //*** First create separte funtionc *** public string GetNextId() { int NextId = 0; try { OleDbConnection objCon = new OleDbConnection(strConn); string strQuery = "select max(Column_Name) from TableName"; objCon.Open(); OleDbCommand objComm = new OleDbCommand(strQuery, objCon); OleDbDataReader dr = objComm.ExecuteReader(); if (dr.HasRows) { dr.Read(); if (dr.IsDBNull(0)) { NextId = 0; } else { NextId = Convert.ToInt32(dr.GetValue(0)); } } dr.Close(); objCon.Close(); } catch (Exception ex) { strFunction = "GetNextId()"; exInnerException = Convert.ToString(ex.InnerException); errorLog.WriteToErrorLog(strClassName, strFunction, ex.Message, exInnerException); } return Convert.ToString(NextId + 1); } //****** call above function where you are wrinting query to insert into table like: string strInsertQuery = "Insert Into [TableName] values(" + GetNextId + ")"; i hope this will help u

Krishna Garad · Answer

you can try this also Declare @id int Set @id=(Select Max(IdColumn+1) From TableName); or Set Column as Identity

Karthikeyan Anbarasan · Answer

Please check this link http://www.mjtnet.com/blog/2010/01/26/get-auto-generated-id-created-by-insert-sql/

How to Generate Automatic id

Answers (3)