My codes are as below; i just need to add few more lines into it stating that the return newcode = strcode.
i’m not sure on that part.
private string CheckCode(string Str)
{
string NewCode = string.Empty;
string strCode = “Select’littl’+RIGHT(‘000’+LTRIM(STR(MAX(Cast(SUBSTRING(code,6,4)as int))+ 1)),4)from horseMaster where code like ‘littl0%'”;
DataTable dtCode = DBObj.QueryDB(strCode).Tables[0];
return NewCode;
