Show next ID in textbox from database?

Read the whole article and adopt Option 3 to auto generate custom ID.
http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-server[^]

Solution for your Question.

Same Questions[^]

Suggestion:

This is the worst idea i think , Do not try to Display the next Id on the Textbox while on Page Load,If two or three user's open the same page at a time then what will happen?
Each have the Same next Id on the Text Box , So there is a possibility to Insert duplicate Id on Table.

public string MaxTranNo()
   {
       try
       {
           int TranNo = 0;

<pre>
       _SqlCon.Open();
       _SqlCmd.CommandText = &quot;SELECT MAX(TRAN_NO) FROM TABLE_NAME&quot;;
       da = new SqlDataAdapter(_SqlCmd);
       ds = new DataSet();
       da.Fill(ds);
       _SqlCon.Close();
       if (ds.Tables[0].Rows[0][0] != DBNull.Value)
       {
           TranNo = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
           TranNo = TranNo + 1;
       }
       else
       {
           TranNo = 1;
       }

       return TranNo.ToString();
   }
   catch (Exception ex)
   {
       throw ex;
   }
   finally
   {
       _SqlCon.Close();
   }

}

in return type you will get your value from the database