how genrate auto endrollment number regstrtion form load event ??

hi Friend

Take this code and genrate the number which u want if this will be usefull for u then reply me

on [email protected],[email protected]    
 

  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();
  }
  }


  }