how to increment by 1 value in c#

Question

how to increment by 1 value in c# int x = 0; for (int i = 0; i if (tStudent.adm_no >0) { x = x + 1; tStudent.adm_no = x; } i want when i admit new student i got a new adm_no automatically

Nanhe Siddique · Answer

try this carlos SqlConnection conn; conn = new SqlConnection(WebConfigurationManager.ConnectionStrings[connectionstrigname].ConnectionString); SqlCommand cmd; sqlcommand cmd = new SqlCommand(select max( id) from tableName conn); conn.Open(); object id = cmd.ExecuteScalar(); if (string.IsNullOrEmpty(id.ToString())) { } else { Convert.ToInt32(id.ToString()); // newStudent Adm_no : string Adm_NO= Adm_no+Convert.ToInt32(id.ToString()); } i think it will help you