Win app C# การใช้คำ For เช็ครหัสพนักงานว่ามีรหัสไหนว่าง เขียนไม่เป็น

sql ="select max(id) from tabelname"
cmd = New OleDbCommand(Sql, Conn)
getRecord = cmd.ExecuteScalar

for i as short = 1 to getRecord 
  sql = "select count(*) as cnt from tablename where id="& i
  cmd = New OleDbCommand(Sql, Conn)
  tempid = cmd.ExecuteScalar
  if tempid = 0 then
    tempid = i
    exit for
  end if
next

if tempid = getRecord then
NewID = getRecord +1
else
NewID = tempid
end if

string sql = null;
sql = "select max(id) from tabelname";
cmd = new OleDbCommand(sql, Conn);
getRecord = cmd.ExecuteScalar;

for (short i = 1; i <= getRecord; i++) {
	sql = "select count(*) as cnt from tablename where id=" + i;
	cmd = new OleDbCommand(sql, Conn);
	tempid = cmd.ExecuteScalar;
	if (tempid == 0) {
		tempid = i;
		break; // TODO: might not be correct. Was : Exit For
	}
}

if (tempid == getRecord) {
	NewID = getRecord + 1;
} else {
	NewID = tempid;
}

  
            sql = "select max(Member_Finger) from  Member";
            com = new SqlCommand(sql, Conn);
            getRecord = Convert.ToInt32(com.ExecuteScalar());

            for (int i = 1; i <= getRecord; i++)
            {
                sql =  "select count(Member_Finger)  from Member where Member_Finger=" +i;
                com = new SqlCommand(sql, Conn);
                tempid = Convert.ToInt32(com.ExecuteScalar()) ;
                if (tempid == 0)
                {
                    tempid = i;                //<------ตรงนี้อยากให้เจอ record แล้วหลุด Loop เขียนยังไง
                    break;  
                }
            }

            if (tempid == getRecord)
            {
                NewID = getRecord + 1;
                textBox1.Text = NewID.ToString();
            }
            else
            {
                NewID = tempid;
                textBox1.Text = NewID.ToString();
            }