First of all get the last id of the table from database.
Then parse it
e.g. in your situation:
var numAlpha = new Regex("(?<Alpha>[a-zA-Z]*)(?<Numeric>[0-9]*)");
var match = numAlpha.Match("sa00001");
var alpha = match.Groups["Alpha"].Value;
var num = match.Groups["Numeric"].Value;
var number = Convert.ToInt32(num);
++number;
var nextId = alpha;
var length = num.Length - number.ToString().Length;
if (length != 0)
{
var format = "D" + length;
nextId += number.ToString(format);
}
else{
nextId+=number.ToString();
}
Now you have next id do whatever you can do with it