how genrate auto endrollment number regstrtion form load event ??

Question

this thype endrollment number jenrate:'2012/0001' plz help me .....

rakesh chaudhari · Answer

hi Friend Take this code and genrate the number which u want if this will be usefull for u then reply me on rlchaudhari@hotmail.comrlchaudhari@gmail.com string autoincrement = SELECT MAX(MemberID)FROM [Member]; cmd = new SqlCommand(autoincrement Connection.GetConnection()); object autoinc = cmd.ExecuteScalar(); if (autoinc.ToString() == ) { // autoinc = 1; } else { string sentence = autoinc.ToString(); ; string[] digits = Regex.Split(sentence @\D+); foreach (string value in digits) { int number; if (int.TryParse(value out number)) { string te = value; autoinc = int.Parse(te.ToString()) + 0001; string prefix=2012/; string conct =prefix +  + autoinc; Your Label Value = conct.ToString(); } } }

Tarun Bhalodi · Answer

Select Registration number from table and +1 its quit easy.... also check for null at first time.....:)

Vimlesh Mishra · Answer

Thanx Dear.